poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53729] New: Shift rows wrongly updates static reference
Date Thu, 16 Aug 2012 13:27:47 GMT

          Priority: P2
            Bug ID: 53729
          Assignee: dev@poi.apache.org
           Summary: Shift rows wrongly updates static reference
          Severity: normal
    Classification: Unclassified
          Reporter: tmp120210@gmail.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: XSSF
           Product: POI

In my xlsx file I have a value at M17, many formulas uses it for counting.
This value is referenced as $M$17 with two dollar signs (to avoid auto
modification if generated cells).
When I am trying to shift rows up, calling sheet.shiftRows(18, 100, -3);
All formulas references in shifting rows were updated correctly, but $M$17 was 
replaced with #REF! sign. I think it is a defect, cause it should be still

Seems like POI doesn't know about $ sign and updates reference to M17 to M14,
which leads to error.

You are receiving this mail because:
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message