https://bugs.freedesktop.org/show_bug.cgi?id=81061
Priority: medium
Bug ID: 81061
Assignee: [email protected]
Summary: Calc not correct save long function in a single cell
Severity: critical
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Formula Editor
Product: LibreOffice
If i try to insert a long function in a single cell, that's not saved
correctly.
This is the correct function:
SE(O(E(AF162="R";AE162="R";AD162="F");E(AF162="R";AE162="F");E(AF162="R";AE162="N");E(AF162="N");E(AF162="";AE162="R";AD162="N");E(AF162="";AE162="N");E(AF162="";AE162="R";AD162="F");E(AF162="";AE162="R";AD162="R";AC162="N");E(AF162="";AE162="R";AD162="R";AC162="F");E(AE162="";AD162="N");E(AE162="";AD162="R";AC162="F");E(AE162="";AD162="R";AC162="R";AB162="F")E(AD162="";AC162="R";AB162="F"
);E(AD162="";AC162="R";AB162="R";AA162="F");E(AD162="";AC162="N");E(AD162="";AC162="R";AB162="N"));"R";SE(O(E(AF162="R";AE162="R";AD162="N");E(AF162="F";AE162="R");E(AF162="";AE162="F";AD162="R");E(AF162="";AE162="R";AD162="R";AC162="N");E(AE162="";AD162="F";AC162="R");E(AE162="";AD162="R";AC162="R";AB162="N");E(AD162="";AC162="F";AB162="R");E(AD162="";AC162="R";AB162="R";AA162="N"));"P";SE(O(AF162="P";E(AF162="";AE162="P");E(AE162="";AD162="P");E(AD162="";AC162="P");E(AF162="F";AE162="F";AD162="R");E(AF162="";AE162="F";AD162="F";AC162="R");E(AE162="";AD162="F";AC162="F";AB162="R");E(AD162="";AC162="F";AB162="F";AA162="R"));"M";SE(O(AF162="M";E(AF162="";AE162="M");E(AE162="";AD162="M");E(AD162="";AC162="M");E(AF162="F";AE162="F";AD162="F");E(AF162="";AE162="F";AD162="F";AC162="F");E(AE162="";AD162="F";AC162="F";AB162="F");E(AD162="";AC162="F";AB162="F";AA162="F"));"N";"ECCO"))))
This instead is the function saved in the cell.
SE(O(E(AF162="R";AE162="R";AD162="F");E(AF162="R";AE162="F");E(AF162="R";AE162="N");E(AF162="N");E(AF162="";AE162="R";AD162="N");E(AF162="";AE162="N");E(AF162="";AE162="R";AD162="F");E(AF162="";AE162="R";AD162="R";AC162="N");E(AF162="";AE162="R";AD162="R";AC162="F");E(AE162="";AD162="N");E(AE162="";AD162="R";AC162="F");E(AE162="";AD162="R";AC162="R";AB162="F")E(AD162=""~AC162="R"~AB162="F"
);E(AD162="";AC162="R";AB162="R";AA162="F");E(AD162="";AC162="N");E(AD162="";AC162="R";AB162="N"));"R";SE(O(E(AF162="R";AE162="R";AD162="N");E(AF162="F";AE162="R");E(AF162="";AE162="F";AD162="R");E(AF162="";AE162="R";AD162="R";AC162="N");E(AE162="";AD162="F";AC162="R");E(AE162="";AD162="R";AC162="R";AB162="N");E(AD162="";AC162="F";AB162="R");E(AD162="";AC162="R";AB162="R";AA162="N"));"P";SE(O(AF162="P";E(AF162="";AE162="P");E(AE162="";AD162="P");E(AD162="";AC162="P");E(AF162="F";AE162="F";AD162="R");E(AF162="";AE162="F";AD162="F";AC162="R");E(AE162="";AD162="F";AC162="F";AB162="R");E(AD162="";AC162="F";AB162="F";AA162="R"));"M";SE(O(AF162="M";E(AF162="";AE162="M");E(AE162="";AD162="M");E(AD162="";AC162="M");E(AF162="F";AE162="F";AD162="F");E(AF162="";AE162="F";AD162="F";AC162="F");E(AE162="";AD162="F";AC162="F";AB162="F");E(AD162="";AC162="F";AB162="F";AA162="F"));"N";"ECCO"))))
2 ";" ar replaced from 2 "~".
The problem still after all modify types of the cell:
1 replace the 2 "~" in the upper bar;
2 drag & drop the correct function in the opened cell
Is this a bug?
Can i resolve it?
(ps, sorry but im'not speak english...)
--
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
