[Libreoffice-bugs] [Bug 118735] Opening a spreadsheet with saved values of URI functions shows #VALUE! instead of cached values (see comment 7)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|False #Value! error         |Opening a spreadsheet with
                   |                            |saved values of URI
                   |                            |functions shows #VALUE!
                   |                            |instead of cached values
                   |                            |(see comment 7)
           Hardware|x86-64 (AMD64)              |All
             Status|NEEDINFO                    |NEW
                 OS|Linux (All)                 |All

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Fitch from comment #4)
> The info is already in the spreadsheet, so it should not come up value
> again

(In reply to Fitch from comment #6)
> The #VALUE! bug is more concerning.

The info is not already in the *original* spreadsheet. The XML inside the ODS
has these records:

> <table:table-cell table:style-name="ce202" table:formula="of:=IF([.AR2]="";"";COM.MICROSOFT.FILTERXML(COM.MICROSOFT.WEBSERVICE("http://www.geopostcode.org.uk/api/"&[.AR2]&"");"//osgb36/north"))" office:value-type="string" office:string-value="" calcext:value-type="error"><text:p>#VALUE!</text:p></table:table-cell>

But I *do* reproduce if I enable content (allowing to fetch from WEB), and
re-save the normal values. Then the file has this:

> <table:table-cell table:style-name="ce202" table:formula="of:=IF([.AR2]="";"";COM.MICROSOFT.FILTERXML(COM.MICROSOFT.WEBSERVICE("http://www.geopostcode.org.uk/api/"&[.AR2]&"");"//osgb36/east"))" office:value-type="string" office:string-value="437871" calcext:value-type="string"><text:p>437871</text:p></table:table-cell>

but still opening it in Calc brings the #VALUE!.

So the problem is that Calc should show the cached values for the WEBSERVICE
formulas, but shows #VALUE! instead.

Setting to NEW.

-- 
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/44962f47/attachment.html>