Unable to Create a new Excel unless using a user with Administrative priviliges

[Smita Badhrayan]

Hi,

We have been using Synfusion for a few years now. Recently I tried to upgrade one of our applications to use the lastest version of Syncfusion.

We use Syncfusion to create Excel files and then convert them into pdf files. After the upgrade I notice that I can only run the application as an admin user.

If I use a user without admin access I see the following error when I try to save the workbook. I have attached a zip file with the Test Project I have been using to troubleshoot this issue.

System.ArgumentException

HResult=0x80070057

Message=Item has already been added. Key in dictionary: '^' Key being added: '^'

Source=mscorlib

StackTrace:

at System.Collections.SortedList.Add(Object key, Object value)

at Syncfusion.XlsIO.Implementation.FormulaUtil.ReplaceInDictionary(IDictionary list, String[] arrOldKey, String[] arrNewKey)

at Syncfusion.XlsIO.Implementation.FormulaUtil.SetSeparators(Char operandsSeparator, Char arrayRowsSeparator)

at Syncfusion.XlsIO.Implementation.FormulaUtil..ctor(IApplication application, Object parent)

at Syncfusion.XlsIO.Implementation.WorkbookImpl.get_FormulaUtil()

at Syncfusion.XlsIO.Implementation.WorksheetImpl.ParseSheetCF()

at Syncfusion.XlsIO.Implementation.WorksheetImpl.get_ConditionalFormats()

at Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeStyles(XmlWriter writer, Stream& streamDxfs)

at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveStyles()

at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveWorkbook(ExcelSaveType saveAsType)

at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveDocument(ExcelSaveType saveType)

at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveDocument(Stream stream, ExcelSaveType saveType)

at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveDocument(String filename, ExcelSaveType saveType)

at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.Serialize(String fullName, WorkbookImpl book, ExcelSaveType saveType)

at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType, ExcelVersion version)

at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName)

at SyncfusionTest.Program.Main(String[] args) in C:\Users\sbadhrayan\Documents\smita\SyncfusionTest\SyncfusionTest\Program.cs:line 31

Attachment:

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Smita, 

Greetings from Syncfusion. 

We could not find the mentioned Test Project in your update and request you to share it. That will be helpful to investigate and provide a prompt solution at the earliest. 

Also, kindly confirm us the Syncfusion XlsIO version you are using. 

Regards, 

Keerthi.