Bug 77939 - Macros: Data property of any hidden cell returns 2,2250738585072E-308
Summary: Macros: Data property of any hidden cell returns 2,2250738585072E-308
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Blocks:
 
Reported: 2014-04-25 17:03 UTC by Viktor Mileikovskyi
Modified: 2015-12-15 10:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
This is the test document. The attachment is described in second comment (14.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-25 17:16 UTC, Viktor Mileikovskyi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Viktor Mileikovskyi 2014-04-25 17:03:50 UTC
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
Comment 1 Viktor Mileikovskyi 2014-04-25 17:13:11 UTC
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
Comment 2 Viktor Mileikovskyi 2014-04-25 17:16:23 UTC
Created attachment 97971 [details]
This is the test document. The attachment is described in second comment
Comment 3 Joel Madero 2014-06-21 03:23:00 UTC
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
Comment 4 Joel Madero 2014-06-21 03:23:10 UTC
Should have added: Ubuntu 14.04 x64
Comment 5 Robinson Tryon (qubit) 2015-12-15 10:55:04 UTC
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]