Data and formulas are not working while importing an Excel.

Posted by: krishna.vajja on 23 September 2019, 10:08 pm EST

  • Posted 23 September 2019, 10:08 pm EST


    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.

  • Replied 23 September 2019, 10:12 pm EST
  • Replied 24 September 2019, 10:57 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.

  • Replied 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.

  • Replied 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.

  • Replied 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.

  • Replied 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.

  • Replied 17 February 2020, 9:03 pm EST

    Hi Krishna,

    I have created a case for you on our SupportOne portal [] and replied you over there.
    For further discussion, you are requested to continue over there.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels