https://bugs.documentfoundation.org/show_bug.cgi?id=160245
Bug ID: 160245 Summary: Paste special operations don't affect percentage cels Product: LibreOffice Version: 24.2.0.3 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ddascalescu+freedesk...@gmail.com Use case: I have a percentage column that's 100x more than the actual percentage (you'll surely recognize this situation). I want to Paste Special "100" from the clipboard with the Operation set to "Divide". However, the column remains unaffected. If I perform the same operation on a column formatted as Number, the operation succeeds. Reproduction steps: 1. In column A, enter numbers like 1, 2, 3 2. Copy column A to column B 3. Format column A as percent. You'll see 100%, 200%, 300%. 4. Copy "100" to the clipbaord 5. Select column A 6. Paste Special, with Operation set to Divide -> Notice nothing happens to column A 7. Select column B 8. Paste Special, with Operation set to Divide -> Notice numbers ARE divided by 100 -- You are receiving this mail because: You are the assignee for the bug.