[Libreoffice-bugs] [Bug 48548] New: Show formulas : copy / paste formulas pastes a #REF error when pasted in Notepad (or pasted as text only in libreoffice writer)

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48548

             Bug #: 48548
           Summary: Show formulas : copy / paste formulas pastes a #REF
                    error when pasted in Notepad (or pasted as text only
                    in libreoffice writer)
    Classification: Unclassified
           Product: LibreOffice
           Version: unspecified
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: joel.obrecht at gmail.com


It is useful to use the "show formulas" option to copy / paste the formulas
from calc in order to make search / replace with regex expressions, for
instance in Notepad++.

But there is some problem avoiding to copy the text shown in the cells, to
paste it as text, in a notepad, or for instance doing "paste special" ->
"unformatted text" in libre office writer.

Steps to reproduce : open a simple calc workbook with several formulas. Use the
"Show formulas" in tools / options to show the formulas, not the result. Select
the formulas and paste those in a notepad.

Copied text : 
='DB EU'.$E1    ='DB EU'.$G1    ='DB EU'.$M1    ='DB EU'.$V1    ='DB EU'.$X1   
='DB EU'.$Y1    ='DB EU'.$AE1    ='DB EU'.$AG1

Result in Notepad :
=#REF!.$E1    =#REF!.$G1    =#REF!.$M1    =#REF!.$V1    =#REF!.$X1   
=#REF!.$Y1    =#REF!.$AE1    =#REF!.$AG1

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Windows XP

Thanks,

Joël

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.