https://bugs.freedesktop.org/show_bug.cgi?id=66646
Priority: medium
Bug ID: 66646
Assignee: [email protected]
Summary: EDITING: Paste Special... Add does not treat Empty
Cells as zero value
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
Created attachment 82123
--> https://bugs.freedesktop.org/attachment.cgi?id=82123&action=edit
Simple Paste Special... Add bug demo containing instructions to replicate
The instructions are in the attached file
PasteSpecialAddEmptyCellBug.ods
This bug is NOT present in the stable version of LibO I have installed:
Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539)
The bug IS present in a recent nightly build:
Version: 4.2.0.0.alpha0+
Build ID: 6f86d931b4266d00fec75c0124ac9fc3026a4f1b
TinderBox: Win-x86@6, Branch:master, Time: 2013-07-02_23:36:17
I noticed the bug after the Conditional Format display bug 62267 was fixed in
the Dev version nightly builds.
In brief, Copy from Row 1 then Paste Special/Add onto Row 2, should produce the
values in Row 3 (and Row 3's Conditional Format will then have green background
to confirm this. I deliberately did not include CF in the destination row as
there had been a problem with that in Bug 62267 that is now fixed)
If the Row 2 value is an Empty Cell (but not if it's a numerical zero) no value
is pasted into Row 2 and the cell remains empty. The two wrong values are
indicated by Row 3 conditional formatting background remaining red.
I hope this can be fixed before it's incorporated into a public release because
it will produce numerical errors compared to earlier versions and other
spreadsheet applications such as MS Excel.
--
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
