Issue 24891 - ISERROR/DGET incorrect on load
Summary: ISERROR/DGET incorrect on load
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-01-29 04:20 UTC by rolfy
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

file that displays issue (35.43 KB, application/x-compressed)
2004-01-29 04:24 UTC, rolfy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description rolfy 2004-01-29 04:20:16 UTC
This problem appears selective, and attempts to reproduce have been 
unsuccessful.  I have therefor attached my golf spreadsheet which displays the 

On opening the spread sheet, in the "Full Summary" sheet, at G20:I20, all cells 
are blank.  If you change C1 to 11.2003, then back to 12.2003, G20:I20 now has 
the correct data in it.  An individual cell can be fixed by changing the 
formula for that cell and removing the modification then pressing enter (eg. 
edit formula, remove last closing bracket then put it back, and press enter)

The cell is empty (I believe) because ISERROR is getting an error somehow from 
the DGET done in this cell.  To prove this theory, I moved the DGET out of the 
formula into a cell to the side, and had the G20:I20 range just refer to the 
newly created field.  The problem still occurs.

The blank field problem is predominantly on load.  Using the spread sheet while 
it's open seems fine, but if you save, then reload, the information is gone. 
until to force the cells to recalculate (either by changing C1 as above, or by 
modifying the formula, removing the modification then pressing enter - I guess 
that this forces the cell to recalculate?) 

It appears that only this small range displays this problem.  I removed several 
individuals form the sheet to try to reduce the work that the sheet has to do, 
but this did not fix the problem.

Sorry that I couldn't narrow down the problem further... I hope that there's 
enough information here... I tried to load this file under Linux Open Office 
1.1, and Windows Open Office 1.1, and both displayed the problem, so I'm 
presuming that it's very reproducable.
Comment 1 rolfy 2004-01-29 04:24:33 UTC
Created attachment 12782 [details]
file that displays issue
Comment 2 frank 2004-01-29 11:33:49 UTC
Hi Sascha,

as discussed one for you.

Comment 3 sascha.ballach 2004-01-29 18:24:10 UTC
I take it.
Comment 4 frank 2004-01-30 08:31:43 UTC
Target set.
Comment 5 frank 2004-05-04 15:38:30 UTC
Due to limited time ressources I re-Target this one to OOo Later
Comment 6 Rob Weir 2013-07-30 02:18:48 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.