[Libreoffice-bugs] [Bug 130698] sum error when opening an xlsx in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130698

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
It is reproducible with ersion: 6.4.1.1 (x64)
Build ID: 56f3c78975db08733f771c53643b5d1aa7c57567
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL

It uses the cached value stored in the XLSX file:

>            <c r="E30" s="23" t="n">
>                <f aca="false">SUM(E5:E29)</f>
>                <v>454</v>
>            </c>

It depends on the default setting "Recalculation on File Load": "Excel 2007 and
newer" - "Never recalculate" under Options->Calc->Formula. If, however, it is
set to "Always recalculate", this is expectedly shown correct. Also doing a
hard recalc on the file normalizes the calculated data. Actions in the sheet
like copy and paste to other places that don't affect the formula cell e.g. in
E30 will expectedly *not* recalculate its value, since SUM is not a volatile
function.

I don't know if this should be closed NOTABUG. Eike, what do you think?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200216/3a582177/attachment-0001.htm>