Bug 92574 - Empty cells different when pasting links of a single cells or of multiple cells at once
Summary: Empty cells different when pasting links of a single cells or of multiple cel...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste-Special
  Show dependency treegraph
 
Reported: 2015-07-06 14:49 UTC by (OPTIONAL) Real Name:
Modified: 2023-07-21 05:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
file with a few examples of what has gone wrong (14.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-07-27 20:13 UTC, (OPTIONAL) Real Name:
Details

Note You need to log in before you can comment on or make changes to this bug.
Description (OPTIONAL) Real Name: 2015-07-06 14:49:12 UTC
When you select more than one field, one of whic is empty and then paste them somewhere, with the "paste content" -> "reference", then the result breaks a lot of the expected behaviours.

To replicate create 4 fields in 1 row, 4 field in another (the ands are the seperator between the fields, all 4 fields exhibit different behaviour):
1 and 2
=1 and empty
"1" and empty
1 and empty

Now copy the 4 right field onto the 4 left fields, with the "paste reference" field enabled. 

In the "selection" part following options are bugged: 
"paste everything" 
"Text" 
"numbers" 
"formula".

In the "calculation" part all options are bugged.

following option have no effect for empty source fields, while they should insert references:
"none", addition, subtraction

the following options have an absolutely wrong effect, changing the fields themselfes and without insert references:
multiplication, division. 


The problem lies in the fact that the multicopy routine is implemented wrong and doesn't use the single copy routine, because referencing a single empty field works just fine in every case.

Either that or the empty fields type is different if stored in an array(or whatever it's stored in.
Comment 1 (OPTIONAL) Real Name: 2015-07-06 14:55:11 UTC
The expected behaviour would be to mimic the behaviour of copying a single cell 4 times.
Comment 2 Buovjaga 2015-07-26 17:23:43 UTC
Please explain, what you mean by "paste reference". Do you mean Paste special - Options: Link?
By "field" I understand you mean "cell".

I think you should create an example document and perhaps screenshots of the incorrect effects.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.
Comment 3 (OPTIONAL) Real Name: 2015-07-27 20:11:45 UTC
Yes, with field I meant cells and "paste special" with "options: link" is the buggy feature, when used with more than 1 cell and 1 of the cells is empty.
Comment 4 (OPTIONAL) Real Name: 2015-07-27 20:13:35 UTC
Created attachment 117481 [details]
file with a few examples of what has gone wrong
Comment 5 (OPTIONAL) Real Name: 2015-07-27 20:15:57 UTC
also note that cell content and displayed content are often equal in mass copy scenario (which is quite a catastrophic bug), while in the single copy scenario the cells content has it's previous content and a link with the operation in it.
Comment 6 Buovjaga 2015-07-29 15:40:09 UTC
Confirmed with test file.

Win 7 Pro 64-bit, Version: 4.4.4.3
Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8
Locale: fi_FI
Comment 7 QA Administrators 2016-09-20 10:21:12 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2019-12-03 14:41:58 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2021-12-03 04:38:36 UTC
Dear (OPTIONAL) Real Name:,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug