How to get header formatting information

How to get header formatting information

Posted by: gagandeep.singh on 6 June 2023, 11:22 am EST

• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 June 2023, 11:22 am EST - Updated 6 June 2023, 11:27 am EST

  

  1320×781 42.4 KB

  Hi there,

  I want to save the header formatting information in the backend, but I don’t know which property of printInfo object will give me or how can I get it.

  For eg: I can get object like this.

  var printInfoObject = spread.getActiveSheet().printInfo();

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2023, 5:12 am EST - Updated 8 June 2023, 5:17 am EST

  Hi Gagandeep,

  You need to use the pageHeaderFooter() method to get the text and format applied to the custom header/footer on the page.

  let headerFooterInfo = sheet.printInfo().pageHeaderFooter().normal;

  Further, both the header and footer has left, right and center section options. You will get the string of the text and format applied to each of the left, right and center sections.

  You need to then parse the string and get the format and other information from the string. Refer to the following code snippet:

  let leftFooterInfo = getHeaderFooterContents(headerFooterInfo.header.left);
  console.log(leftFooterInfo);
  
  let rightFooterInfo = getHeaderFooterContents(headerFooterInfo.header.left);
  console.log(rightFooterInfo);

  Here getHeaderFooterContents is a function that parses the string to get the text and format details. The function “getHeaderFooterContents” is defined in the below sample.

  Sample: https://jscodemine.grapecity.com/share/JrhXJzMGt0W23JmjcFovWQ/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  I could also see that applying the “Double” underline in Custom Header/Footer was not working with the latest version of SpreadJS. I have reported it to the concerned team for further investigation. The internal tracking id for the same is: SJS-18652. I will let you know when there is an update from the dev team on this issue.

  References:

  pageHeaderFooter method: https://www.grapecity.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Print.PrintInfo#pageheaderfooter

  IPageSectionOptions Interface: https://www.grapecity.com/spreadjs/api/v15/interfaces/GC.Spread.Sheets.Print.IPageSectionOptions

  IPageHeaderFooterOptions Interface: https://www.grapecity.com/spreadjs/api/v15/interfaces/GC.Spread.Sheets.Print.IPageHeaderFooterOptions#header

  Please let us know if you still face any issues.

  Regards,

  Ankit

  

• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Posted 8 June 2023, 9:40 am EST

  Perfect thanks

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 4 July 2023, 12:34 am EST

  Hi Gagandeep,

  The devs have informed us that the issue with internal tracking id SJS-18652 will be fixed in the SpreadJS V16.1.4 which will be released shortly. I will let you know when the version is released.

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 5 July 2023, 3:08 pm EST

  Hi Gagandeep,

  The SpreadJS V16.1.4 has been released and the mentioned issue has been fixed. Kindly upgrade to the latest version of SpreadJS.

  You may download the latest version using the following link:
  
  http://cdn.grapecity.com/spreadjs/16.1.4/Files/SpreadJS.Release.16.1.4.zip

  Please let us know if you face any problems.

  Regards,

  Ankit