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

  • 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
  • Replied 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
Need extra support?

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

Learn More

Forum Channels