https://bugs.documentfoundation.org/show_bug.cgi?id=89922
Bug ID: 89922
Summary: CSE formulas not handled properly when FILEOPEN
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: j.revell...@gmail.com
CSE (shift+control+enter) formulas are not evaluated as such when Calc opens a
calc session begins (opens file), though they work fine if input within the
calc session.
For example, the CSE formula
COUNTA(IF(($A$1:$A$5=$A7),B$1:B$5))
will count the rows matching a certain value form the same row
When loaded properly the viewed cell should show
{=COUNTA(IF(($A$1:$A$5=$A7),B$1:B$5))}
and display the rows counted.
After the calc file is loaded it instead just shows this for the cell
=COUNTA(IF(($A$1:$A$5=$A7),B$1:B$5))
and either an old or incorrect static value, or the error "=VALUE!"
In order to correct the formula cell the formula has to be cleared and
reentered with shift-control-enter for it to evaluated properly. Reentering
the formula with CSE directly doesn't work right.
Once the CSE formula is entered it will work correctly for the entire session,
though calc will again not evaluate it properly when the file is opened later.
I've tried saving in both .xls and .xlsx format, and neither works right. It
doesn't seem to matter if Calc or Excel created the file. Excel will load the
file properly even when Calc doesn't.
--
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
