Problem Export to Excel

Posted by: patrik on 25 August 2020, 6:03 pm EST

  • Posted 25 August 2020, 6:03 pm EST

    FpSpread1.SaveExcel("Test", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat Or FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders)

    This code working perfect, custom header are saved.

    But if I use that code and have disable "visible header" in Spread Designer under Settings.
    If I have a formula like:"=F9*G10"
    After export and I open in Excel the formula will be::"=F10*G11"

    If I use code below it's work perfect, but if I sometime have a header it's not exported.
    FpSpread1.SaveExcel("Test", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat)
  • Marked as Answer

    Replied 26 August 2020, 6:43 pm EST


    It works as intended. When SaveCustomColumnHeaders is used, the exported worksheet will have row header and column header, which are inserted at the left / top of the worksheet. All formulas will be adjusted as same as user insert rows/columns at that position.
    Therefore, to get the correct output in generated Excel file while using SaveCustomColumnHeaders, in addition to un-checking the 'Column Header Visible' option in the Settings dialog, please set the value of Column Header Row Count to 0, in the same dialog in Settings menu.

Need extra support?

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

Learn More

Forum Channels