[Libreoffice-bugs] [Bug 38343] New: Behaviour of Advanced Filter in Calc/Spreadsheet

[bugzilla-daemon at freedesktop.org]

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

           Summary: Behaviour of Advanced Filter in Calc/Spreadsheet
           Product: LibreOffice
           Version: LibO 3.4.0 release
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: ghoermann at hydrology.uni-kiel.de


Created an attachment (id=47994)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=47994)
Screenshot of error message

Hello, 

the behavior of the advanced filter is very strange. Please see the attached
screenshot. An advanced filter copies the *formulas* and not the *values*, this
leads to the error messages in the screenshot (columns UVW) because the
formulas frequently loose their context after copying. In Excel only the values
are copied - this is something I would also suggest for Libreoffice, also
because imported xls files (like the one from the attached screenshot) produce
errors when the filter is applied.

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