You need to sign in or sign up before continuing.
Correctly apply column styles when the start column index is not 0
The Excel 2003 XML format has an element Table that supports ss:TopCell and ss:LeftCell which specifies the top-left corner of the data area as 1-based integers. When these are given, orcus currently applies column styles to incorrect columns as if cell A1 is the top-left corner. This needs to be fixed.
Example file:
How it looks when opened in Excel:
How it looks when opened in Calc with the current orcus build:
Notice how the colors are shifted to the left, and column D doesn't have the date format applied. The column widths are different, but that's a separate issue not covered in this ticket.
The test file originates from the bug report: https://bugs.documentfoundation.org/show_bug.cgi?id=118227
Edited by Kohei Yoshida