Apache OpenOffice (AOO) Bugzilla – Issue 20067
the report result is not right with date fields
Last modified: 2013-04-24 01:40:39 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.
change subcomponent to 'none'
.
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.
reopen for reassign
reassign to bc
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
Created attachment 21186 [details] Bugdoc with BasicMacro
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!
BC: On my behalf this works fine in SRC680m72, as I could see in the report wizard that is based on a textdocument
I can't see anything wrong with the NumberFormatter either, so it's back to BC.
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
BC->TL: Please send back to me when you fixed it
Created attachment 22417 [details] Sample document with Basic macro
Fixed in CWS tl07. Files changed: - unotbl.cxx new revision: 1.90.180.1
. re-open issue and try to reassign to sw@openoffice.org
try to reassign to sw@openoffice.org
try to reset resolution to FIXED
sw->msc: look like one for you re-open issue and try to reassign to msc@openoffice.org
try to reassign to msc@openoffice.org
BC->TL: I tested with a table where a cell already contains a value and found that this value was not overwritten.
Please fix in dbwizard4 ASAP
Fixed for dbwizard4. Files changed: - unotbl.cxx TL->BC: Please check in yourself. I'll change the owner back to you.
BC: Fixed in dbwizard4 re-open issue and reassign to msc@openoffice.org
reassign to msc@openoffice.org
reset resolution to FIXED
hi, verified in cws dbwizard4 Bye Marc
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
As desired by gatekeeper reopening.
setting back fixed.
Setting back to Verified.