https://bugs.documentfoundation.org/show_bug.cgi?id=92928
Bug ID: 92928
Summary: Same network connection error for each call to
GETPIVOTDATA
Product: LibreOffice
Version: 4.4.4.3 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I have a spreadsheet with:
-- one "normal" pivot table linked to a range on another sheet.
-- one pivot table pulling data from a JDBC connection to the local network.
-- dozends of function calls to GETPIVOTDATA merge information from both pivot
tables. Currently 38 of these formulas refer to the JDBC pivot.
When my laptop is connected to the local net, I refresh the "normal" pivot
which automatically refreshes the other pivot as well. If this is intended, it
is a bad idea.
When I try to activate the pivot sheet while being unconnected or when I try to
refresh either one of the pivots, I get 38 times
"java.net.NoRouteToHostException" in intervals of 3 seconds, so it takes
several minutes holding the Escape key until I can close the document
gracefully. 38 is the count of GETPIVOTDATA formulas referring to the JDBC
pivot.
After deleting the 38 formulas, everything seems to behave normally.
The JDBC pilot does not update automatically when updating the normal one.
The error message pops up when I try to refresh the JDBC pilot.
-----------------------------------------
This is how OpenOffice 4.1 handles this:
It shows the error one time after loading the document, regardless of the
currently active sheet and whenever I try to refresh the JDBC pivot.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
