[Bug 61869] New: Setting cell formula produces an unreadable file

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 61869] New: Setting cell formula produces an unreadable file

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61869

            Bug ID: 61869
           Summary: Setting cell formula produces an unreadable file
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 35591
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35591&action=edit
Input file and test class

Summary: if you have multiple rows with a formula and you change the formula
content of 2 or more rows the result is an unreadable file.

Run attached Test2.java (just change the package name) on test.xlsx. Result is
an
unreadable file.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61869] Setting cell formula produces an unreadable file

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61869

Yegor Kozlov <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 OS|                            |All
         Resolution|---                         |FIXED

--- Comment #1 from Yegor Kozlov <[hidden email]> ---
Fixed in r1818818

In your spreadsheet C2 is a shared formula which spans into C2:C3. The concept
of 'shared formula' means that the formula definition is stored in C2 and C3
references it by an internal index. When POI updated the formula in C2 it broke
the shared formula relationship and Excel was not happy to open such a file.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61869] Setting cell formula produces an unreadable file

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61869

Yegor Kozlov <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |hasitha.gunasinghe@iicorpor
                   |                            |ate.com

--- Comment #2 from Yegor Kozlov <[hidden email]> ---
*** Bug 60227 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]