Issue 20067 - the report result is not right with date fields
Summary: the report result is not right with date fields
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20039
  Show dependency tree
 
Reported: 2003-09-25 15:07 UTC by marc.neumann
Modified: 2013-04-24 01:40 UTC (History)
2 users (show)

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


Attachments
Bugdoc with BasicMacro (8.11 KB, application/vnd.sun.xml.writer)
2005-01-07 13:04 UTC, berend.cornelius
no flags Details
Sample document with Basic macro (7.69 KB, application/octet-stream)
2005-02-10 13:15 UTC, thomas.lange
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description marc.neumann 2003-09-25 15:07:00 UTC
- create a new dbase table with a date field
- insert some different data and leave some fields blank
- create a report with the field
==>> the result is not right.
The empty datefields are filled with a default value.
Comment 1 hans_werner67 2004-02-02 12:28:10 UTC
change subcomponent to 'none'
Comment 2 berend.cornelius 2004-06-07 09:47:57 UTC
.
Comment 3 berend.cornelius 2004-06-07 11:14:45 UTC
BC->CLU: Sorry it's not yet fixed. Not before the integration of OS30 that's in
the quality assurance right now. If you don't mind you can keep it with you till
it's integrated. I have a lot of other bugs to the same issue that I will return
to you than. But you can also send it back to me if you want to.
Comment 4 berend.cornelius 2004-09-07 16:23:43 UTC
.
Comment 5 berend.cornelius 2004-09-07 16:24:23 UTC
.
Comment 6 berend.cornelius 2004-09-07 16:24:49 UTC
.
Comment 7 marc.neumann 2005-01-03 11:17:23 UTC
reopen for reassign
Comment 8 marc.neumann 2005-01-03 11:17:41 UTC
reassign to bc
Comment 9 berend.cornelius 2005-01-07 13:01:35 UTC
BC->Should be the same problem as Bug i20067 where the numberformat of boolean
fields are not set correctly. As Attachment you find the same document with
Basic macro
Comment 10 berend.cornelius 2005-01-07 13:04:33 UTC
Created attachment 21186 [details]
Bugdoc with BasicMacro
Comment 11 thomas.lange 2005-01-12 12:26:06 UTC
TL->ER: Since the same problem can be experienced with Calc this seems to be an
issue of the number formatter. Please take over. Thanks!
Comment 12 berend.cornelius 2005-01-19 08:57:17 UTC
BC: On my behalf this works fine in SRC680m72, as I could see in the report
wizard that is based on a textdocument
Comment 13 niklas.nebel 2005-01-20 13:33:16 UTC
I can't see anything wrong with the NumberFormatter either, so it's back to BC.
Comment 14 berend.cornelius 2005-02-07 14:27:42 UTC
BC: On my behalf I added the following code. After retrieving the double value
of the column I have a chance to subsequently query if the value was null, If
yes I return void:

DblValue = new Double(xResultSetRow.getDouble(ColIndex) + (double)
super.getNullDateCorrection());
if (xResultSetRow.wasNull())
        return Any.VOID;
else
	return DblValue;

However the method  setDataArray from the interface XCellRangeData returns a
Runtime Exception, when a field of the Array has the value 'Any.Void', or 'null'
or '"

XCellRangeData xDataArray = (XCellRangeData)
UnoRuntime.queryInterface(XCellRangeData.class, xNewRange);
					xDataArray.setDataArray(datalist);



com.sun.star.uno.RuntimeException: 
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at
com.sun.star.lib.uno.protocols.urp.Unmarshal.readExceptionValue(Unmarshal.java:464)
	at com.sun.star.lib.uno.protocols.urp.Unmarshal.readAnyValue(Unmarshal.java:400)
	at com.sun.star.lib.uno.protocols.urp.Unmarshal.readValue(Unmarshal.java:208)
	at com.sun.star.lib.uno.protocols.urp.urp.readReply(urp.java:190)
	at com.sun.star.lib.uno.protocols.urp.urp.readMessage(urp.java:312)
	at com.sun.star.lib.uno.protocols.urp.urp.readMessage(urp.java:624)
	at
com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.invoke(java_remote_bridge.java:185)
	at
com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:170)


BC->TL: As we discussed->toyou
Comment 15 berend.cornelius 2005-02-07 14:31:17 UTC
BC->TL: Please send back to me when you fixed it
Comment 16 thomas.lange 2005-02-10 13:14:09 UTC
.
Comment 17 thomas.lange 2005-02-10 13:15:23 UTC
Created attachment 22417 [details]
Sample document with Basic macro
Comment 18 thomas.lange 2005-02-10 13:17:46 UTC
Fixed in CWS tl07.

Files changed:
- unotbl.cxx  new revision: 1.90.180.1
Comment 19 thomas.lange 2005-02-24 11:19:50 UTC
.

re-open issue and try to reassign to sw@openoffice.org
Comment 20 thomas.lange 2005-02-24 11:20:06 UTC
try to reassign to sw@openoffice.org
Comment 21 thomas.lange 2005-02-24 11:20:14 UTC
try to reset resolution to FIXED
Comment 22 stephan.wunderlich 2005-03-01 11:35:21 UTC
sw->msc: look like one for you

re-open issue and try to reassign to msc@openoffice.org
Comment 23 stephan.wunderlich 2005-03-01 11:35:25 UTC
try to reassign to msc@openoffice.org
Comment 24 stephan.wunderlich 2005-03-01 11:35:32 UTC
try to reset resolution to FIXED
Comment 25 berend.cornelius 2005-03-15 13:50:02 UTC
BC->TL: I tested with a table where a cell already contains a value and found
that this value was not overwritten.
Comment 26 berend.cornelius 2005-03-15 13:52:20 UTC
Please fix in dbwizard4 ASAP
Comment 27 thomas.lange 2005-03-15 15:04:38 UTC
Fixed for dbwizard4.

Files changed:
- unotbl.cxx

TL->BC: Please check in yourself. I'll change the owner back to you.
Comment 28 thomas.lange 2005-03-15 15:05:10 UTC
.
Comment 29 berend.cornelius 2005-03-16 10:33:45 UTC
BC: Fixed in dbwizard4

re-open issue and reassign to msc@openoffice.org
Comment 30 berend.cornelius 2005-03-16 10:33:54 UTC
reassign to msc@openoffice.org
Comment 31 berend.cornelius 2005-03-16 10:33:58 UTC
reset resolution to FIXED
Comment 32 marc.neumann 2005-03-17 12:37:36 UTC
hi,

verified in cws dbwizard4

Bye Marc
Comment 33 marc.neumann 2005-03-24 11:14:22 UTC
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc
Comment 34 ulf.stroehler 2005-03-31 10:22:45 UTC
As desired by gatekeeper reopening.
Comment 35 ulf.stroehler 2005-03-31 10:23:14 UTC
setting back fixed.
Comment 36 ulf.stroehler 2005-03-31 10:23:48 UTC
Setting back to Verified.
Comment 37 marc.neumann 2005-04-18 10:46:53 UTC
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc