Summary: | VIEWING: Advanced Excel Sheet doesn't operate as intended | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Maverynthia <maverynthia> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTOURBUG | QA Contact: | |
Severity: | normal | ||
Priority: | medium | ||
Version: | 4.1.0.4 release | ||
Hardware: | Other | ||
OS: | Windows (All) | ||
Whiteboard: | BSA | ||
i915 platform: | i915 features: | ||
Attachments: | Stalk Market Guide BETA 3 |
Description
Maverynthia
2013-08-06 20:17:44 UTC
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. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.