https://bugs.documentfoundation.org/show_bug.cgi?id=161974
--- Comment #10 from ady <[email protected]> --- JIC, let's clarify the report. "Real" rounding values (by cell format, round() function or similar) is unrelated. There are several reports about some kind of "inconsistency" in displaying either "###" or a value, with some modified format (e.g. cell alignment) when changing zoom levels. Some reports are related to some patch that modified the behavior in some way. Some reports are related to the font's characteristics (e.g. fixed-width/mono-spaced vs proportional). This report might or might not be a dupe of any of those. I have to point out one relevant item... While changing zoom levels, if a numeric value is displayed at some zoom level, and then "###" is displayed at a higher zoom level (i.e. zooming-in), and finally a numeric value is displayed again at an even higher zoom level, then that's something that might be worth improving. But... If the "###" is displayed (instead of the expected value) when zooming-out, and then with lower zoom levels the value is never seen again (so, always the "###" is seen starting from some zoom level, and zooming out from that point), then there is no bug but a simple natural consequence of zooming out. Anyway, the reported behavior might be a consequence of how many decimals are used while displaying the cell value, the width of the column, the amount of pixels for the column's width at a certain screen resolution and zoom level, and the horizontal size of the specific characters (e.g. numbers) of the specific font/size combination. Not being a developer myself, IDK whether it is possible to adjust the algorithm for "any-and-every" font simultaneously. -- You are receiving this mail because: You are the assignee for the bug.
