https://bugs.documentfoundation.org/show_bug.cgi?id=95513
Bug ID: 95513
Summary: handling of INDIRECT function when switching between
XLS and ODS formats
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:41.0)
Gecko/20100101 Firefox/41.0
Build Identifier: LibreOffice 5.0.3.2
These appears to be a regression - I was not getting this problem in 5.0.2
XLS uses <!> as the separator between workbook and sheets in the INDIRECT
function. ODS uses <.>
When switching between different formats, formulae become corrupted.
Recommend that Calc is changed to handle both conventions.
When use COL:COL (e.g $H:$H instead of $H$1:$H$999999) formula is corrupted
Reproducible: Always
Steps to Reproduce:
1. Create spreadsheet, use INDIRECT and COL:COL references in file
2. Save as XLS, save as ODS
3. ODS is corrupted
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Reset User Profile?No
--
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
