GNOME Bugzilla – Bug 320970
Incorrect #####-overflow when zoomed
Last modified: 2005-11-10 05:56:38 UTC
In a departamentally created spreadsheet, some fields that should contain simple constant values turn up as ####. When I edit the fields, the value is there, and I can edit it, but it still turns up ####. I suspect the formatting of the field breaks something. In attached sheet, it happens in F21, F30, F33-34, F36-38.
Created attachment 54467 [details] Spreadsheet with constants replaced with ####
"####" is Gnumeric's (and Excel's, for that matter) way of saying that the number is too wide to be shown in the cell. In this case, that isn't really true. We seem to have a bug related to the fact that the sheet is zoomed. The numbers are shown as expected if you reset the zoom to 100%.
Probably has something to do with the use of "\ *" in the format. Removing the * made it work when zoomed as well, and it also works when printing. Bug is not quite so serious then, IMHO.
*** This bug has been marked as a duplicate of 310492 ***