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

Problem referencing a cell with formula in same position of other file

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 3.8.0
    • 3.5.0, 3.6.0, 3.7.0
    • ZSS Component
    • Security Level: Jean

    • JBoss 6.2

      Step to Reproduce

      1. visit demo http://zssdemo.zkoss.org/zssdemo/reference_to_another_workbook
      2. clear all content of 2 books
      3. enter 1, 2 at A1, 2 at B1 in profile.xlsx
      4. at C1 in profile.xlsx, enter =SUM(A1:B1) (must enter a formula)
      5. enter =[profile.xlsx]Source!C1 at C1 in resume.xlsx
      6. delete content at C1 in resume.xlsx
      7. paste the same formula above, =[profile.xlsx]Source!C1, at the same cell, C1

      Actual Result

      value of C1 cell in resume.xlsx is #N/A

            henrichen henrichen
            LeonardoRosa LeonardoRosa
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: