https://bugs.documentfoundation.org/show_bug.cgi?id=85410
--- Comment #15 from Justin L <[email protected]> --- Created attachment 193059 --> https://bugs.documentfoundation.org/attachment.cgi?id=193059&action=edit reduceDecimalPlaces.ods: several situations trying to reduce decimal place The function handling this is ScViewFunc::ChangeNumFmtDecimals(bool bIncrement) It isn't as bad as it originally sounded, IMHO. Most situations handle it correctly. When a range of cells is chosen, only the "current" cell is evaluated - that seems logical and simplifies things. The problem happens in the "General Number" case, when there is not enough space to display the whole number. In that case, the program is allowed to "round" the number based on the column width instead of showing ###. However, the "real" number is more decimal places than can be shown. By decreasing the decimal point, we now force X number of decimal places, which in the "auto-rounded" cases likely means it won't fit any more. In other words, you will only see this problem on cells where more decimal places will be shown if you increase the width of the column. So this depends on font size, zoom level, etc. -- You are receiving this mail because: You are the assignee for the bug.
