https://bugs.freedesktop.org/show_bug.cgi?id=80237
Priority: medium
Bug ID: 80237
Assignee: [email protected]
Summary: FILEOPEN: Importing excel spreatsheet fails when other
sheets are referenced
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 101365
--> https://bugs.freedesktop.org/attachment.cgi?id=101365&action=edit
sample excel sheet to import
Problem description:
references to other sheets doesn't import correctly (i get excel-like Sheet!A1
instead of libreoffice Sheet.A1)
Steps to reproduce:
1. open the attached file in libreoffice
2. look at list SEARCH, E2
Current behavior:
=IF(IF($D2="ne";"";INDIRECT("Kontakty!A" &
$D2))=0;"";IF($D2="ne";"";INDIRECT("Kontakty!A" & $D2)))
Expected behavior:
=IF(IF($D2="ne";"";INDIRECT("Kontakty.A" &
$D2))=0;"";IF($D2="ne";"";INDIRECT("Kontakty.A" & $D2)))
Operating System: All
Version: 4.2.4.2 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
