Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-133

Excel Export does not evaluate Formulas on not visited Sheets and not visible section.

XMLWordPrintable

      exporting Spreadsheet Book does not work properly.

      Version 2.1.1 (i used libs from zssapp.war 2.1.1):
      formulas in not visited Sheets (client side) are not evaluated.
      depending on setPreloadColSize / setPreloadRowSize formulas in not visible section are not evaluated too.

      Version 2.3.0 (i used libs from zssapp.war 2.3.0):
      formulas in not visited Sheets (client side) are not evaluated.

      on both versions if we visit the sheets(client side) or scroll to (loading) the not visible section the export work fine.

      any workaround to solve this so that exporting whole book evaluate all Formulas on all sheets?

      In attachment simple project demonstrate this behavior.

      Thanks.

            Unassigned Unassigned
            brmohamed brmohamed
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: