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 Steps to reproduce: 1. Download the attachment and open it; 2. Press "Test" button and read showed information: 3. .... Current behavior: Expected behavior: Workaround: Use GetValue method instead. Operating System: Ubuntu Version: 4.2.3.3 release Last worked in: 4.2.2.1 release
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
Created attachment 97971 [details] This is the test document. The attachment is described in second comment
Tested on 4.2.4.2 release and it seems to work fine - although after the dialog appears I get a runtime error (should be reported separately). Marking as WFM - if you can reproduce this with 4.2.4.2 or 4.2.5.2 release please set to UNCONFIRMED again. Thanks
Should have added: Ubuntu 14.04 x64
Migrating Whiteboard tags to Keywords: (possibleRegression) [NinjaEdit]