https://bugs.freedesktop.org/show_bug.cgi?id=56447
Priority: medium
Bug ID: 56447
Assignee: [email protected]
Summary: paste special does not skip empty cells when checkbox
is checked
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: NEW
Version: 3.6.1.2 release
Component: Spreadsheet
Product: LibreOffice
I want to update a formula in 4 columns, 2500 lines long, with lots of
strategic empty cells. When I copy the new cell, and Edit Paste Special,
Formula only, and check the Skip empty cells checkbox, I find it pastes into
all cells.
I also found this bug exists in 3.4.5, and in OO_3.1, so it seems it has always
been there.
and creating a new spreadsheet to test in, also ignores the Skip checkbox.
and trying Paste All in Paste Special, also does not skip.
Are there any combinations that Do skip empty cells?
To duplicate, enter into [cell]=___
A1= 1
A2= =A1+1
copy A2, paste A3..A5
paste B2 and B4, leaving B3 empty
B1= 4
now edit B2= =$a1+2
copy B2,
Highlight B3..B5
Paste Special, Formula, Skip empty
Result, all 3 cells now contain the formula, instead of just one.
(This example is ridiculously simple, whereas the real formula contains several
IF statements and calculations.)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
