Missing some method of GC.Spread.Sheets.Worksheet when using on NodeJS

Missing some method of GC.Spread.Sheets.Worksheet when using on NodeJS

Posted by: nguyenvu.work on 28 June 2023, 3:38 pm EST

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 June 2023, 3:38 pm EST - Updated 11 January 2024, 5:40 am EST

  • I am using SpreadJs in Nodejs and want to get

    getRowPageBreak

    in sheets. But I got an error:

    sheet.getRowPageBreak is not a function

      workBook.sheets.forEach((sheet) => {
        this.rowPageBreaks = [...Array(sheet.getRowCount()).keys()].filter((rowIndex) =>
        sheet.getRowPageBreak(rowIndex)
      );
      });
  

  • I tried log all properties in “sheet” instants and there have not property “getRowPageBreak” and “setRowPageBreak”. ColPageBreak method is the same!
  • I am using spread v16.0.4
• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 June 2023, 12:00 am EST

  Hi,

  We have deleted your response since it contains the license key. Please do not share lcenseKeys on public forums. You may create a support case in the support portal in case you need to share the license key.

  Regards,
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 June 2023, 12:46 am EST

  Hello,

  We were able to replicate the issue on our end. Hence, we have escalated this issue to the development team for further investigation of the issue. Please be rest assured that we will keep you updated as there is any progress on this issue.
  
  Please let us know if you face issues or if you need assistance.

  The internal ID for this issue will be SJS-18953

  regards,
  
  Avinash

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy

  Posted 2 July 2023, 6:22 pm EST

  • Thank you so much for your response!
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 3 July 2023, 3:30 pm EST

  Hi,

  The developers have informed us to just remove the package-lock.json file and then reinstall all the dependencies using “npm install” command again.

  Please try with the above solution and let us know if you still face any issues.

  Regards,

  Ankit

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy

  Posted 4 July 2023, 8:53 pm EST

  • I tried it but still got the same error, I attempted to resolve my problem by get what i want in workbook as JSON object temporarily but I still want to get them properly. Thank you so much for your help!
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 6 July 2023, 3:56 am EST - Updated 6 July 2023, 4:01 am EST

  Hi,

  We have tested on multiple machines and it seems to be working fine at our end. Steps we have followed:

  1. Install the dependencies using the “npm install” command.

  2. Run the sample using the “node index.js” command.

  3. If the error occurs, delete the “package-lock.json” file.

  4. Delete the “node_modules” folder.

  5. Reinstall the dependencies using the “npm install” command.

  6. Run the sample using the “node index.js” command.

  You could refer to the following attached gif that shows the steps we have followed. It might be a machine dependent issues.

  Could you kindly share us the following configuration so that we may test on a similar environment? I am sharing my system configuration below. Kindly share yours in a similar pattern.

  Operating System: Windows 11 Pro (64 bit)

  SpreadJS: v16.0.4 (Also tested with the latest SpreadJS V16.1.4)

  Processor: 11th Gen Intel(R) Core™ i7-11850H @ 2.50GHz 2.50 GHz

  Node: v16.14.2

  I have also attached the sample that we have used for testing. In the sample, kindly insert a valid key at line no. 15 in the index.js file before running the application.

  Also, it would be nice if you could share a video/gif showing the steps we have mentioned above.

  Regards,

  Ankit

  

  sample.zip

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy

  Posted 9 July 2023, 6:30 pm EST

  • Thank you so so much, my problems has been resolved. I missed

    @grapecity/spread-sheets-pdf

    and

    @grapecity/spread-sheets-print

    .
  • After add

    require('@grapecity/spread-sheets-print')

    it worked. Thank you so much <3
    
    @ankit.kumar