[Libreoffice-bugs] [Bug 118735] False #Value! error

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
Thank you for filing this.

First of all: please always file one bug/request per issue. Here, you seem to
mention two different issues:

1. A document being marked as modified on load;
2. Formulas with URI functions [1] incorrectly returning #VALUE.

I cannot reproduce #2 using Version: 6.1.0.1 (x64)
Build ID: 378e26bd4f22a135cef5fa17afd5d4171d8da21a
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: ru-RU (ru_RU); Calc: CL.

Or, rather, kind of reproduce: when opening the document, I do see those
"VALUE"s in columns AW-AZ; but also I see the infobanner telling "Automatic
update of external links has been disabled."; and pressing "Enable Content"
there, I get the formulas recalculated and #VALUEs becoming normal results. I
suspect that the behaviour change here is related to the recent fixes of [2],
and this being the correct behaviour, not a bug.

I do reproduce issue #1 opening the document. I don't confirm this yet, though,
until you decide how to proceed here: either you let it handle the one
reproducible; or split it to two; or something else.

I set it to NEEDINFO until it is clear which issue to track here. Please set
back to UNCONFIRMED when made requested changes. Thanks!

[1]
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_webservice.html
[2] https://www.libreoffice.org/about-us/security/advisories/cve-2018-6871/

-- 
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/20180713/78078372/attachment-0001.html>