Exporting Spread to Excel change cross references

Posted by: jdnevarez on 8 September 2017, 12:29 pm EST

  • Posted 8 September 2017, 12:29 pm EST

    When exporting a spread workbook with several sheets to Excel the cross references are changed from SheetX to SheetY. Do I need to import the sheets being referenced first and the ones making references at the end?


    Please help, thanks.

  • Replied 8 September 2017, 12:29 pm EST

    Do you have 2.5.2009.2005 or 2.5.1009.2002?
  • Replied 8 September 2017, 12:30 pm EST

    Hi Scott,


    The cross reference issue I am seeing is when exporting spread workbook to Excel..

  • Replied 8 September 2017, 12:30 pm EST

    Hello,


    First thing I would suggest is to get the latest maintenance release of Spread for Windows Forms. If it still does not work, could you post a small zipped project reproducing this issue for us to debug?

  • Replied 8 September 2017, 12:30 pm EST

    What version should I install? where can I get it?
  • Replied 8 September 2017, 12:30 pm EST

    Hello,


    When importing sheets that have cross sheet references of formulas, the formula parsing is turned off until you call the LoadFormulas method of Spread, which you should do after loading the Excel files.

  • Replied 8 September 2017, 12:30 pm EST

    FarPointExcel.dll 2.5.1011.2002


    FarPoint.Win.dll 2.5.1007.2002


    FarPoint.Win.Spread.dll 2.5.1007.2002


    FarPoint.CalcEngine.dll 2.5.1011.202


    Thanks

  • Replied 8 September 2017, 12:30 pm EST

    Hello,


    Are you having problems with the import of Excel files or exporting to Excel?

  • Replied 8 September 2017, 12:30 pm EST

    Hello,


    The latest version of the Spread for Windows Forms product is 2.5.1009 and can be downloaded from our web site. You would click on the Updates link on the left side of the page from this web site.

  • Replied 8 September 2017, 12:30 pm EST

    Hi Scott,


    I upgraded to 2.5.1009, unfortunately the issue is still there. I will try to recreate the error using dummy data, since sheets conatain company restricted data.


    If you fix the bug in the midterm, please let me know.


    Thanks


     

Need extra support?

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

Learn More

Forum Channels