Slicer not showing

Slicer not showing

Posted by: claudiu on 7 November 2018, 6:18 am EST

• 

  claudiu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 November 2018, 6:18 am EST

  Hello,
  
  I was looking at https://www.grapecity.com/en/demos/spread/JS/TutorialSample/demos/ExcelIO.html and I have come across a spreadsheet that has a slicer that isn’t being displayed, and I was wondering if I could get a little help troubleshooting the reason for it.

  One thing to note is that excel opens the file just fine.

  Thank you
  
  slicer.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 7 November 2018, 11:44 pm EST

  Hello,

  I tested this issue with our online demo and could not reproduce the behavior you mentioned.
  
  It exported the slicer data without any issues.

  Please check the demo and export the workbook to Excel.
  
  https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  You can check the slicer sheet, which seems to be working fine.

  Thanks,
  
  Deepak Sharma

• 

  claudiu

  • Post Options:
  • Link
    Copy

  Posted 8 November 2018, 1:22 am EST - Updated 3 October 2022, 2:03 am EST

  Hi,
  
  I am not looking at exporting the workbook, I only want to load it and display it.

  Loading the spreadsheet I previously attached in spreadjs does NOT display the slicer on row 10, please see attachments. Excel on the other hand does display it upon opening the same file.

  Thank you

  

  1920×643 53.8 KB

  

  1593×977 62.7 KB

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 8 November 2018, 9:17 pm EST

  Hello,

  I can replicate this issue with your Excel file. I found that the slicer is not imported to Spread.Sheets.

  However, I tested this issue with another Excel file I created and got the slicer Imported with no issues. Please test the attached Excel file with our online demo:
  
  https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  May I know how did you create the Excel file you provided?

  Thanks,
  
  Deepak SharmaSlicertest.zip