Summary: | Delete Decimal Places should consider the number of visible decimal places | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Rafael Lima <rafael.palma.lima> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | enhancement | CC: | buzea.bogdan, ra3356 |
Priority: | medium | ||
Version: | 24.2.0.0 alpha0+ | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108252 | ||
Attachments: |
Video of how MS Excel handles this command
Video of how LO Calc handles the same situation |
Description
Rafael Lima
2023-09-29 14:43:21 UTC
What would be an expected result on the default-formatted cells, having different widths, or numbers showing different number of decimals because of, say, different whole part size? Say, a column with 1.333333333333333 12.333333333333333 123.333333333333333 ... In some cells, their automatic display would be 1.333333 12.33333 123.3333 Selecting the whole column, and pressing Delete Decimal Places, would make their formatting different, right? Created attachment 189893 [details] Video of how MS Excel handles this command (In reply to Mike Kaganski from comment #1) > What would be an expected result on the default-formatted cells, having > different widths, or numbers showing different number of decimals because > of, say, different whole part size? In this case, I'd suggest do what MS Excel does (see attached video). Suppose you have these 3 cells (these are the visible values): 1,333333 10,33333 100,3333 If you click "Delete Decimal Places", it will consider the one with the smallest number of visible decimal places (in this case, 4 in the third cell) and then reduce them all to 3 decimal places. 1,333 10,333 100,333 Created attachment 189894 [details]
Video of how LO Calc handles the same situation
Here's the video of how LO handles the same situation.
Notice that the first time I click I get ### in all cells... and then I have to click multiple times to get to the point where the number of decimal places is smaller than the original cell contents.
Agree, makes sense. Also had a moment when I thought that something like that would be nice. *** Bug 157651 has been marked as a duplicate of this bug. *** |