Bug 160245

Summary: Paste special operations don't affect percentage cels
Product: LibreOffice Reporter: Dan Dascalescu <ddascalescu+freedesktop>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO ---    
Severity: normal CC: miguelangelrv, stephane.guillou
Priority: medium    
Version: 24.2.0.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Dan Dascalescu 2024-03-17 19:31:32 UTC 
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
Comment 1 m_a_riosv 2024-03-18 00:15:44 UTC 
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
Comment 2 m_a_riosv 2024-03-18 00:17:56 UTC 
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
Comment 3 Stéphane Guillou (stragu) 2024-03-18 06:32:38 UTC 
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.)