https://bugs.documentfoundation.org/show_bug.cgi?id=167120
Bug ID: 167120
Summary: Upgrade from 24.8.6.2 to 25.2.3.2 has broken Paste
Special / Unformatted Options/Functionality
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
To date, only tested on Linux/64-Bit.
Issue:
After scraping data from another application [specifically, Firefox], an
attempt to paste the same to an empty Calc tab, using the options: "Paste
Special" / Unformatted Text" results in a situation where for every single
successive paste , the application forgets the options previously set and
defaults back to an incorrect set of values.
This issue did not occur with the previous edition of LO I was running,
24.8.6.2.
The data I am trying to capture originates in the form of a table of
electricity consumption data [from a smart meter]. Where each row of the data
looks like this:
12:00am 0.10 kWh
and there are 48 rows per day [sampling every 30 minutes]. With 24.8.6.2 I was
able to select "Paste Special" and then "Options" and then select the
attributes I wanted the application to take, for example selecting the
"Separated by" top level option. Beyond "Separated by", the dialogue box for
both editions of LO has a series of radio-button selection options, for things
like tab, comma, semicolon, space and other.
For my data, I want to have the "space" option active. However, with 25.2.3.2,
each time I return to my "work area" tab to paste the raw data ahead of
formatting it, the dialogue box has returned to what I'll describe as "shipping
defaults".
With LO 24.8.6.2, once I had set the "paste special" dialogue options the very
first time I used that edition, it remembered those settings across restarts.
The process I'm using is highly repetitive and this paste special option is a
critical part of my workflow. It probably sounds trivial, but having to go to
the dialogue screen and accurate click the "space" option slows the whole
process down massively...
Is there any way you would either be willing to revert this dialogue back to
"do the least surprising thing", which is remember the options I set once I
have set them?
I kept the earlier edition of LO installed on my machine, which means that I
can revert back to it for this task... so I don't think this qualifies as an
"urgent" bug... but I'd be very grateful if you could revert this paste option
back to "least surprising" operation please?
Is it possible that this change is related to the extra options that appear
with the "Paste Special" dialogue box in 25.2.3.2?
Thanks in advanced.
Steps to Reproduce:
1. Launch Calc 25.2.3.2
2. Find a web page or similar source with tabulated numeric/text data
3. Attempt to paste to a workbook tab using "Paste Special"
4. Activate the option to use "space" as a separator and see the paste works as
expected...
5. Go back to the web page and retrieve more data
6. Return to the "Paste Special" dialogue box and see that LO has "forgotten"
that you just asked it to use "Space" as a separator when using "Paste Special"
to paste data.
Actual Results:
Calc keeps resetting it's "Paste Special" options back to the defaults each
time it is used, which is *really* annoying...
Expected Results:
I would expect LO Calc to remember the Paste Special dialogue options.
At minimum, I would expect it to remember the options between successive uses
during a single launched execution of the binary - i.e. without closing and
re-starting. Ideally I would expect it to consistently reproduce the
functionality of earlier 24.x editions, where it can remember the options I set
across restarts.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: Spreadsheet - Calc CL threaded
OS: Linux (Mint)
OS is 64bit: yes
Build: Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 32; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
