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
.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 220.127.116.11 and I am using Gnumeric 1.12.44.cell_format_woes.ods. I have also attached a screenshot of a side-by-side view.