Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-438

export a formula with an external reference incorrectly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 5.6.0
    • Fix Version/s: 5.8.0
    • Component/s: None
    • Security Level: Jimmy
    • Labels:
      None

      Description

      Steps to Reproduce

      1. visit the zul
      2. click the button to export
      3. import the exported file back
      4. check A1:A4

      Current Result

      the cells A1:A4 don't show the expected values from source.xlsx A1:A4

      Expected Result

      shows the expected values from source.xlsx A1:A4

      Debug Information

      • the original formula is =[source.xlsx]Input!A1, after exporting it becomes =Input!A1

        Attachments

        1. exported-externalRef.xlsx
          4 kB
          hawk
        2. externalRef.xlsx
          9 kB
          hawk
        3. issue.zul
          0.4 kB
          hawk
        4. IssueComposer.java
          2 kB
          hawk
        5. source.xlsx
          8 kB
          hawk

          Activity

            People

            Assignee:
            jumperchen jumperchen
            Reporter:
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: