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

          Priority: medium
            Bug ID: 60718
          Assignee: [email protected]
           Summary: FILEOPEN: protected folder
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.0.0.3 release
         Component: Spreadsheet
           Product: LibreOffice

Problem description: 
I have a xlsx file (without macro).
The folder named "_RiservatoAxa_" is protected (without password).


Steps to reproduce:
1. just open the file with Calc

Current behavior:
Funtion CERCA.VERT (translated: FIND.VERT) change 
from the original:
=CERCA.VERT("CodicePerito";_RiservatoAxa_!A1:B210;2;FALSO)
to:
=CERCA.VERT("CodicePerito";$_RiservatoAxa_.A1:B210;2;0)

Consequently the function value is always "0"


Expected behavior:
Function "text" should not change, so the value returned will be the right one
pointed in _RiservatoAxa_ folder

Note: if I remove protection from _RiservatoAxa_ folder everything works, but
it's a workaround

Operating System: Windows 7
Version: 4.0.0.3 release

-- 
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

Reply via email to