Pivot Table

Pivot Table

Posted by: svaz on 8 September 2017, 5:03 am EST

• 

  svaz

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:03 am EST

  Hi

  I understand that it is possible to create pivot tables using spread for windows 5 but I could not find any example or information in the help file. Have you got any sample application showing how to create a pivot table in spread?

   

  Many thanks

  Svaz

• 

  seanl

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:03 am EST

  Pivot tables were planned for this release, but the feature was removed from v5 before the beta release.  The pivot table support was not high enough quality to pass the initial phase of internal testing, so it has been delayed.
  
  

• 

  bevans

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:03 am EST

  Hi

   

  I've read this previous mail dated from 2009. Is pivot table functionning in the last release of Spread for Windows form??? 

• 

  manpreetkaur

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:03 am EST

  Hello,

  I would like you to know that the creation of pivot tables is still not possible with Spread, it has been planned for the future releases of Spread. However, using version 5, you can load Excel files containing macros, VBA code, and pivot tables using the new ExcelOpenFlags.DocumentCaching, and you can make changes to the spreadsheets and save them to Excel using ExcelSaveFlags.DocumentCaching, and it will preserve the unsupported content in the Excel file.

  Hope it will help you. Please let me know if you have any queries further.

  Thanks,

  Manpreet Kaur
  
  

• 

  liang

  • Post Options:
  • Link
    Copy

  Posted 5 May 2021, 8:21 pm EST

  [li][/li]