https://bugs.freedesktop.org/show_bug.cgi?id=67843
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTOURBUG
--- Comment #1 from Mike Kaganski <mikekagan...@hotmail.com> ---
There are problems with the attached file.
Cell A36 in worksheet "Blank (8)" contains the following formula:
=IF(AND(OR(AND(C4<C5; C5<C6; C6<C7; C7<C8 C8>0);AND(C5<C6; C6<C7; C7<C8; C8<C9;
C9>0);AND(C6<C7; C7<C8; C8<C9; C9<C10; C10>0);AND(C7<C8; C8<C9; C9<C10;
C10<C11; C11>0);AND(C8<C9; C9<C10; C10<C11; C11<C12; C12>0);AND(C9<C10;
C10<C11; C11<C12; C12<C13; C13>0);AND(C10<C11; C11<C12; C12<C13 C13<C14;
C14>0);AND(C11<C12; C12<C13; C13<C14; C14<C15; C15>0)));1;0)
You may notice that there's no semicolon between "C7<C8" and "C8>0" in first
innermost "AND". The same problem is in next-to-last innermost "AND": no
semicolon between "C12<C13" and "C13<C14".
The formula is malformed. LO correctly displays error 509 (and description in
status bar: "Error: Operator missing"). If the formula is corrected, this
worksheet seems to work (cells C4-C15 are colored on input; the graph is drawn;
advice in H17 is given).
The problem in formula is in the file itself; it is not introduced by Calc. It
may be checked, if you open the xlsx ar zip, and inside it look into
xl\worksheets\sheet8.xml. The corresponding formula there look like this:
<f>IF(AND(OR(AND(C4<C5, C5<C6, C6<C7, C7<C8 C8>0),AND(C5<C6,
C6<C7, C7<C8, C8<C9, C9>0),AND(C6<C7, C7<C8, C8<C9,
C9<C10, C10>0),AND(C7<C8, C8<C9, C9<C10, C10<C11,
C11>0),AND(C8<C9, C9<C10, C10<C11, C11<C12,
C12>0),AND(C9<C10, C10<C11, C11<C12, C12<C13,
C13>0),AND(C10<C11, C11<C12, C12<C13 C13<C14,
C14>0),AND(C11<C12, C12<C13, C13<C14, C14<C15,
C15>0))),1,0)</f>
If MS products are more forgiving to the errors in the formulas, it does not
mean that other programs must excercise the same tolerance. LO checks formula
syntax more strictly, and IMO this is good. The source file must be corrected.
You may file a bug report to the author(s) of that file.
Closing as NOTOURBUG.
--
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
