Print_Area is not being exported/shown in excel through Save To File

Print_Area is not being exported/shown in excel through Save To File

Posted by: pooja.bansal on 12 May 2022, 5:33 pm EST

• 

  pooja.bansal

  • Post Options:
  • Link
    Copy

  Posted 12 May 2022, 5:33 pm EST

  Hi,
  
  We are using Spread Js 14 for our web-application and Spread.Net for Desktop Client.
  
  We have set the Print_Area in Name Manager settings.
  
  When we do export/ save to file through desktop client, then it is being reflected
  
  in excel also.
  
  However, when we export the same template in web-client it doesnt show Print_Area in excel.
  
  In code _xlnm is added as a prefix with Print_Area in class-
  
  Workbook.Names
  
  If we remove the prefix _xlnm through code, then in export it is reflecting the Print_Area correctly.
  
  Q1)What is the purpose of prefix xlnm in Print_Area?
  
  Q2)Please guide how we can export the print area using SpreadJS without removing prefix?

  Please reply asap.

  Regards
  
  Pooja Bansal

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 15 May 2022, 8:56 pm EST

  Hi Pooja,

  Could you please share a sample template file and detailed steps by which we could replicate the issue at our end so that we could investigate it further and help you accordingly?

  Regards,
  
  Avinash