Discrepancies between OOO and Gnumeric regarding a cell's (percentage) format
I see some weird behavior in Gnumeric (and ssconvert) where the return value of CELL("FORMAT", x)
differs.
The basic determination of a percentage-formatted cell works fine (case 1). OOO somehow distinguishes "General" cells from numeric "General" cells while Gnumeric sees it as "G" (case 2). The reason for the bug report is the last case though: if a custom format for percentage, e.g., with 3 decimals ("0.000%") is given, Gnumeric treats it as "G" although I think it should be "P3" as it is in OOO.
I could not exactly pin-point the problem but I presume it is either in the importer code for .ods
files or the underlying implementation of the CELL
function (or in OOO). The behavior changes if I export the file in OOO as .xls
or .xsls
. In the latter case the last test is indeed "P3" (but I get an error message "Undefined number format id '42'" when opening the file first).
The attached file has been created by OOO 6.1.5.2 and I am using Gnumeric 1.12.44.cell_format_woes.ods. I have also attached a screenshot of a side-by-side view.