Forums Home / ComponentOne / General Discussion
Posted by: krishna.vajja on 23 September 2019, 10:08 pm EST
krishna.vajja
Posted 23 September 2019, 10:08 pm EST
Hi,
I’m using Grapecity, of version v12.45.20191.0 in my product and found an issue while opening the attached excel.
Steps to reproduce,
Create an excel file, by applying the formula(=Row()) to a column.
Load this file into a spread and make some changes and save.
Reopen this file.
Attached is the file to reproduce the issue.
A quick reply is highly appreciated.
Regards,
Krishna.
krishna.vajja
Posted 23 September 2019, 10:12 pm EST
Ruchir.Agarwal
Posted 24 September 2019, 10:57 pm EST - Updated 3 October 2022, 10:55 pm EST
Hello Krishna,
What is the issue you are observing re-opening the saved file? At our end, opening your file with Spread shows value for 2 rows only however, in excel it showed values for 7 rows.
But when we try to replicate this with a new excel file consisting Row formulas, opening the same works perfectly using Spread. Even after modifying, saving and reopening it works properly.
So it seems that the issue is perhaps related to that excel file. Could you try to replicate the same using a new excel file?
Also, try using 12.45.20193.0 version of Spread.
Thanks,
Ruchir
krishna.vajja
Posted 25 September 2019, 7:56 pm EST
Thanks for the reply Ruchir.
Yes, when we try to re-open the saved file the formulas are getting lost.
Recently we updated Farpoint to version 12 and we are facing this issue.
I have created an excel with formulas in 7 cells as in shared excel and tried to open this into our application using Farpoint. For the first time, it is opened as expected with formulas and after save and reopen I am facing this issue.
For excel save we used below flags:
result = SaveExcel(fileName, ExcelSaveFlags.UseOOXMLFormat | ExcelSaveFlags.PreferTextOnExport | ExcelSaveFlags.ComboAsDataValidation);
Same way for opening the excel we used,
OpenExcel(FileName, FarPoint.Excel.ExcelOpenFlags.DocumentCaching | FarPoint.Excel.ExcelOpenFlags.DoNotRecalculateAfterLoad | FarPoint.Excel.ExcelOpenFlags.DataAndFormulasOnly);
Please suggest some fix for this.
Thanks,
Krishna.
Ruchir.Agarwal
Posted 26 September 2019, 6:29 pm EST
Hello Krishna,
I can observe the same behavior and it seems to be an issue. Hence, I’ve forwarded it to the developers for fix [ID: 276158].
I’ll update you once it is fixed.
Regards
Ruchir
krishna.vajja
Posted 12 February 2020, 5:35 pm EST
Hi Ruchir,
May I know the status of this issue as two of our customers are facing huge problems to open their datasheets.
Quick fix is highly appreciated.
Thanks,
Krishna.
Ruchir.Agarwal
Posted 13 February 2020, 10:05 pm EST
Hello Krishna,
I am glad to inform you that the issue has been fixed in Spread.Net 13 release. Regarding incorporating the fix in Spread.Net 12, I am discussing it with the team and will inform you accordingly.
Thanks,
Ruchir
Ruchir.Agarwal
Posted 17 February 2020, 9:03 pm EST
Hi Krishna,
I have created a case for you on our SupportOne portal [https://supportone.componentone.com/casedetail/421491] and replied you over there.
For further discussion, you are requested to continue over there.
Thanks,
Ruchir
