Problem Export to Excel

Problem Export to Excel

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

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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:“=F9G10"
  
  After export and I open in Excel the formula will be::"=F10G11”

  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)
  

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 26 August 2020, 6:43 pm EST

  Hi,

  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.

  Regards,
  
  Ruchir