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

After adding a user defined function to a sheet the application throws a NPE inserting/deleting rows/columns/cells

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.0
    • Fix Version/s: 2.5.0
    • Component/s: ZSS Component
    • Labels:
      None
    • Environment:

      Windows/OpenSUSE

      Description

      We have created a user defined function for retrieving data to populate the cell. We tried wiring through XEL and TLD but those were untestable because the Zats framework doesn't always notice the function.

      We have it wired the way POI recommends it and we can test successfully that way. The function works properly and is tested.

      However we are receiving a NullPointerException in FormulaParser at line 175 because XSSFName is returning a null from getRefersToFormula(...).

      1. COFunctionMapper.java
        1 kB
        jerryhoerig
      2. Ds.java
        3 kB
        jerryhoerig

        Activity

        Hide
        samchuang samchuang added a comment -

        Could you provide more information, a runnable sample code perhaps ?

        In the attachments, I didn't see any zul page, I am not sure how do you use COFunctionMapper.java and Ds.java ?

        Also, you mentioned you can not test custom function using ZATS, use XEL. I have tried it, it works in my environment, could you also provide the sample code ?

        Show
        samchuang samchuang added a comment - Could you provide more information, a runnable sample code perhaps ? In the attachments, I didn't see any zul page, I am not sure how do you use COFunctionMapper.java and Ds.java ? Also, you mentioned you can not test custom function using ZATS, use XEL. I have tried it, it works in my environment, could you also provide the sample code ?
        Hide
        jerryhoerig jerryhoerig added a comment -

        I have emailed the code to Wing Chan <wingchan@potix.com> to allow further investigation. The code is proprietary so I could not post it directly.

        Show
        jerryhoerig jerryhoerig added a comment - I have emailed the code to Wing Chan <wingchan@potix.com> to allow further investigation. The code is proprietary so I could not post it directly.
        Hide
        samchuang samchuang added a comment -

        fixed since 2012/9/4

        Show
        samchuang samchuang added a comment - fixed since 2012/9/4

          People

          • Assignee:
            Unassigned
            Reporter:
            jerryhoerig jerryhoerig
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: