[Libreoffice-bugs] [Bug 113979] New: Paste unformated text does not ignore empty cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113979

            Bug ID: 113979
           Summary: Paste unformated text does not ignore empty cells
           Product: LibreOffice
           Version: 5.3.0.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jumbo4444 at yahoo.fr

Created attachment 137897
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137897&action=edit
Example file

Description: Pasting raw text, with empty columns, erase cells

Steps to reproduce:
1. Create a new sheet, with formulas in column D = SUM(A1:C1) (or open attached
document)
2. Copy this text:
1;2;3;;60
2;3;4;;61
Note: successive semi colons indicate an empty column
3. Click on menu button of Paste button > Unformated text
4. In dialog, check semi colon as separator, OK

Actual result:
Formula in column D are erased.

Expected result:
Formula in column D should be kept

Workaround: paste in another sheet, copy again and paste special with "Skip
empty cells" option

Reproduce with:
- Version: 5.3.0.1 (x64)
Build ID: 3b800451b1d0c48045de03b5b3c7bbbac87f20d9
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur
de mise en page : nouveau; 
Locale : fr-FR (fr_FR); Calc: CL
- Version: 5.3.6.1
Build ID: 686f202eff87ef707079aeb7f485847613344eb7
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur
de mise en page : nouveau; 
Locale : fr-FR (fr_FR); Calc: group

NOT reproduce with (works as expected):
- Version: 5.2.7.2 (x64)
Build ID: 2b7f1e640c46ceb28adf43ee075a6e8b8439ed10
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: CL
- Version: 5.3.0.0.alpha1 (x64)
Build ID: f4ca1573fcf445164c068c1046ab5d084e1b005f
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171121/f11d7500/attachment.html>