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
Works for me with: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3ba85b7786663da4f2de1a3c2fe7ee9a27657293 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
And works with: Version: 24.2.2.1 (X86_64) / LibreOffice Community Build ID: bf759d854b5ab45b6ef0bfd22e51c6dc4fb8b882 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Not reproduced either in: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 39663a323c3330c18b610fcdc9e9c75ddac770f1 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded Note that I actually copied the value "100" from a different cell for step 4. If you copy 100%, it actually holds the value 1 (and therefore, dividing by 1 would not have any impact on existing values). Is that what you did? (Remember that using "format as percent" changes the underlying numerical values, e.g. from 100 to 1.)