[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    DO NOT REPLY [Bug 51089] New: Conditional formula is constant over
From:       bugzilla () apache ! org
Date:       2011-04-20 9:44:46
Message-ID: bug-51089-47293 () https ! issues ! apache ! org/bugzilla/
[Download RAW message or body]

https://issues.apache.org/bugzilla/show_bug.cgi?id=51089

           Summary: Conditional formula is constant over cells, although
                    it shouldn't be
           Product: POI
           Version: 3.7
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: jochen@apache.org


Created an attachment (id=26910)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26910)
Test class, which is used to create ConditionalFormula.xls

The attached Java class creates a file called ConditionalFormula.xls. This file
is basically identical with the attached file ConditionalFormula2.xls, with one
important exception: The cells D3, D4, etc. have a conditional formula. When
inspecting this formula in the first file, which is created by POI, then the
formula is shown constant in Excel. In the second file, the formula is modified
by Excel and the row number matches the cells row number.

However, on the POI API level, there is no meaningful difference between the
files, as can be shown by running the "Test" class. This class is used to
extract the relevant information from the excel files.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

[prev in list] [next in list] [prev in thread] [next in thread]