Created attachment 82123 [details] 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.
Hi rh_libre, thanks for reporting. Reproducible with: Win7x64 Ultimate. Version: 4.2.0.0.alpha0+ Build ID: e703b429cf448deddc7682a33c3e6221889efe98 Skip empty destination cells. Works as expected: Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) Version: 4.1.0.1 Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155
Not wanting to derail this topic, but it is appropriate to report display-refresh bugs in the Dev version or should they be expected just because it's a Dev Build? (I have an 8000-row spreadsheet using Window/Freeze where the top half, above the freeze, refreshes but the bottom half doesn't until I scroll, showing, for example, the last webpage I was viewing before Alt-Tab)
Hi rh, please report a new bug about it and if possible attach a file to see the issue, remember deleting or changing any private information.
Hi, I confirm with last download: Version: 4.2.0.0.alpha0+ Build ID: cb14b1e56d2aab70d28afca8bf039a27f89671c8 TinderBox: Win-x86@6, Branch:master, Time: 2013-07-11_04:05:08 Vista-32b
It is fixed now.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=21da9b11df716a21a552e7b32357af49b728b233 fdo#66646: fix paste special with empty cells The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=690228ad4dd4cf10ad6292686d4aad8dcc9e2793 add a unit test for fdo#66646 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.