Notes and editing after saving to excel

Posted by: thesilentkill on 8 September 2017, 2:18 pm EST

  • Posted 8 September 2017, 2:18 pm EST

    Hi guys,

     How do I save the notes on the column headers? when I save them to Excel the notes are gone.  Also the columns aren't editable on the excel sheet. I am using Excel 2003 and using FP Spread 5.0. Code below:

    Me.fpsObject.SaveExcel(sFileName, FarPoint.Excel.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders)

  • Replied 8 September 2017, 2:18 pm EST

    Hello,

    I don't find any way to export notes in header to excel.

    As you said that you are not able to get into edit mode after the export in excel, please check if the Sheet is protected.Unprotecting the sheet will resolve your issue.

    Thanks,

     

     

     

Need extra support?

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

Learn More

Forum Channels