https://bugs.freedesktop.org/show_bug.cgi?id=62770
Priority: medium
Bug ID: 62770
Assignee: [email protected]
Summary: CALC - import of XLS file with conditional formats,
sheet name gets inserted in conditional formula
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Libreoffice
Product: LibreOffice
This sounds similar to bug 36379 from 2011, but it's still in the current
release. My apologies in advance if this filing is a duplicate. In fact, I
thought I already reported this 6 months ago and it was reported as fixed, but
I can't find the bug now and it's still broken.
If I create a file in Excel 2000 with a conditional format for a cell like:
Formula Is: =AND(OR(L6<$B6,E6<B6,L6<E6),COUNT(L6))
and if I import this file using Calc, what appears for the conditional format
for that cell in Calc is:
AND(OR('2013'!L6<'2013'!$B6,'2013'!E6<'2013'!B6,'2013'!L6<'2013'!E6),COUNT('2013'!L6))
As you can see, each cell spec is prepended with the string:
'2013'
which is the name of the sheet.
This will arithmetically work, but the formulas are polluted with unnecessary
information. Formulas should not be changed from what was written in the
source.
In addition, (perhaps this is unrelated, I don't know) when I save this file
from calc, I get the dialog box:
Warning saving the document name-test:
Write Error.
All changes to the Basic Code are lost. The original VBA Macro Code is saved
instead.
Then when I open it again with Excel 2000, I get a notice saying that my
spreadsheet contains macros, do I want to enable them, when in fact, my
spreadsheet should contain no macros. Where did they come from?
And when I look at the conditional format formula, it is polluted with the
sheet name (as I saw in Calc).
Would it help to have a small example test case, or can you tell what's wrong
from what I've written?
--
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
