https://bugs.documentfoundation.org/show_bug.cgi?id=118735
Mike Kaganski <[email protected]> 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 <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
