https://bugs.freedesktop.org/show_bug.cgi?id=77939
--- Comment #1 from Viktor Mileikovskyi <[email protected]> --- Sorry the submition process was suddenly stopped... Problem description: If some row or column range is hidden the Data(0)(0) property of any cell in it returns 2,2250738585072E-308 instead of it's value. The attached document contain test macros linked to "Test" button: Sub Main Dim ThisIsPi as Double ThisIsPi=ThisComponent.NamedRanges.getByName("ThisIsPi").ReferredCells().Data(0)(0) Print "pi ="; ThisIsPi End Sub The cell B2 named "ThisIsPi" contain the formula =PI() Steps to reproduce: 1. Download the attachment and open it; 2. Press the "Test" button and read showed information: "pi = 3,14159265358979" 3. Hide row 2 or column B 4. Press the "Test" button and read wrong information: "pi = 2,2250738585072E-308" Current behavior: pi = 2,2250738585072E-308 Expected behavior: pi = 3,14159265358979 Workaround: Use GetValue method instead. Operating System: Ubuntu Version: 4.2.3.3 release Last worked in: 4.2.2.1 release -- 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
