https://bugs.documentfoundation.org/show_bug.cgi?id=89633
Bug ID: 89633
Summary: CALC does not properly import / edit Excel hyperlinked
formula cells containing formula or numeric
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bugzi...@rhynas.com
Created attachment 113656
--> https://bugs.documentfoundation.org/attachment.cgi?id=113656&action=edit
7Zip file contains 3 spreadsheet files illustrating the issue
Cells hyperlinked in Excel (using the hyperlink GUI window), cannot have their
URL edited when opened in LibreOffice CALC. Also, if the CALC .ods version of
the spreadsheet is subsequently re-saved as .xls, ALL the original Excel
hyperlinks are lost i.e. no going back.
The above observation refers to cells containing a numeric value or formula. I
have many sheets containing hyperlinked prices which I'm trying to migrate to
LO CALC, and this problem makes it unacceptably risky. Text hyperlinks seem ok
although the CALC hyperlink formatting of them is lost when saved back as .xls.
The spreadsheet examples attached illustrate the problems:
1) Price_Test.xls The original Excel .xls spreadsheet with hyperlinked
price and text cells
2) Price_Test.xls.ods The .xls spreadsheet opened in CALC, cells added
and saved as .ods
3) Price_Test.xls.ods.xls The .xls.ods spreadsheet re-saved from CALC as
.xls, then opened in Excel
NOTE: I originally raised enhancement request "bug 89572" to improve the
editing of cells containing hyperlinked values, before I realised the
significance of the Excel hyperlinks actually vanishing. Hence escalation to
serious bug.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
