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