You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/06/27 09:57:21 UTC
[Bug 122603] New: Date field displays incorrect value as number text
in Base report
https://issues.apache.org/ooo/show_bug.cgi?id=122603
Bug ID: 122603
Issue Type: DEFECT
Summary: Date field displays incorrect value as number text in
Base report
Product: Base
Version: AOO400-dev
Hardware: All
OS: All
Status: CONFIRMED
Severity: major
Priority: P2
Component: code
Assignee: issues@openoffice.apache.org
Reporter: fanyuzhen@gmail.com
CC: issues@openoffice.apache.org
Flags: 4.0.0_release_blocker?
Steps:
1. Create a table with date field
2. Create a report based on this table and check the value of the date field
Actual result: the date value displays as number char, like "40716"
Expected result: the date value displays as date, like "11/06/22"
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
4.0.0_release_blocker requested: [Bug 122603] Date field displays
incorrect value as number text in Base report
Posted by bu...@apache.org.
fanyuzhen@gmail.com has asked for 4.0.0_release_blocker:
Bug 122603: Date field displays incorrect value as number text in Base report
https://issues.apache.org/ooo/show_bug.cgi?id=122603
------- Additional Comments from fanyuzhen@gmail.com
Steps:
1. Create a table with date field
2. Create a report based on this table and check the value of the date field
Actual result: the date value displays as number char, like "40716"
Expected result: the date value displays as date, like "11/06/22"
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
--- Comment #2 from fanyuzhen@gmail.com ---
*** Bug 122602 has been marked as a duplicate of this bug. ***
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
--- Comment #4 from hanya <ha...@gmail.com> ---
I got the following error during the new report creation using the report
wizard.
Each cells of the created table on the report document takes the same
number format with the bound column in NumberFormatter.setNumberFormat method.
Before to set NumberFormat property to the cell, FormatsSupplier property
is tried to set. But current cell in the table on the text document does not
have
FormatsSupplier property. The following error raised and NumberFormat is not
set.
com.sun.star.beans.UnknownPropertyException: FormatsSupplier
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:171)
at sun.proxy.$Proxy6.setPropertyValue(Unknown Source)
at
com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:200)
at
com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:240)
at
com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:456)
at
com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:340)
at
com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:549)
at
com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:225)
at
com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:236)
at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:359)
at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:354)
at
com.sun.star.wizards.report.ReportWizard.finishWizard(ReportWizard.java:358)
at
com.sun.star.wizards.ui.WizardDialog.finishWizard_1(WizardDialog.java:692)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:90)
at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:86)
at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:45)
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:171)
at sun.proxy.$Proxy110.execute(Unknown Source)
at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:730)
at
com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:497)
at
com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:120)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
hdu@apache.org <hd...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kschenk@apache.org
--- Comment #7 from Kay <ks...@apache.org> ---
Confirmed as well. Thanks for the patch. We'll check it out.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
hanya <ha...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |hanya.runo@gmail.com
--- Comment #3 from hanya <ha...@gmail.com> ---
It seems not only for Date but also for other kind of data types.
As a workaround,
- open the report document to edit.
- Select a column and choose Table - Number Format in the main menu and apply
format.
- Save the document.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
--- Comment #1 from oooforum <oo...@free.fr> ---
Maybe linked with https://issues.apache.org/ooo/show_bug.cgi?id=121492
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
--- Comment #10 from SVN Robot <sv...@dev.null.org> ---
"hdu" committed SVN revision 1501137 into trunk:
#i122603# fix database wizard's use of the Numberformatter
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
4.0.0_release_blocker granted: [Bug 122603] Date field displays
incorrect value as number text in Base report
Posted by bu...@apache.org.
jsc@apache.org has granted fanyuzhen@gmail.com's request for
4.0.0_release_blocker:
Bug 122603: Date field displays incorrect value as number text in Base report
https://issues.apache.org/ooo/show_bug.cgi?id=122603
------- Additional Comments from jsc@apache.org
grant showstopper flag, patch available
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
jsc@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jsc@apache.org
Flags|4.0.0_release_blocker? |4.0.0_release_blocker+
--- Comment #9 from jsc@apache.org ---
grant showstopper flag, patch available
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Assignee|issues@openoffice.apache.or |hanya.runo@gmail.com
|g |
--- Comment #12 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Changed "Assigned to" to patch submitter to ease reliable queries.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
hdu@apache.org <hd...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ACCEPTED |RESOLVED
Resolution|--- |FIXED
Target Milestone|--- |AOO 4.0
--- Comment #11 from hdu@apache.org <hd...@apache.org> ---
Applied Hanya's patch and updating the status to FIXED.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
--- Comment #5 from hanya <ha...@gmail.com> ---
Created attachment 80925
--> https://issues.apache.org/ooo/attachment.cgi?id=80925&action=edit
Proposed patch to fix the problem.
When setNumberFormat method is called from DBColumn::initializeNumberFormat
method,
the number formatter is the document's one.
And the passed arguments are from the database column.
Before the format key is set to the table cell, the format key from the
column is used to generate new key on the number format supplier.
Therefore to set FormatsSupplier property of the cell is not required
(I mean, document's one is used).
The same setNumberFormat method is called from other wizard, so the line
should not be removed, check the property existence before to set it.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
hdu@apache.org <hd...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |ACCEPTED
CC| |hdu@apache.org
QA Contact| |hdu@apache.org
--- Comment #8 from hdu@apache.org <hd...@apache.org> ---
Confirming the original problem too and confirming that Hanya's patch works
great (as always :-) ). Thanks for the patch!
Suggesting to include it in the imminent release: The patch fixes the problem
and cannot have any impact on other areas.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
fanyuzhen@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|major |critical
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122603] Date field displays incorrect value as number text in
Base report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122603
--- Comment #6 from hanya <ha...@gmail.com> ---
Created attachment 80926
--> https://issues.apache.org/ooo/attachment.cgi?id=80926&action=edit
Test case containing a table with number formatted columns
To verify:
- Open the attached NumberFormatTest.odb file.
- Click Reports in Database and then click Use Wizard to Create Report...
- Push >> button to add all fields to the report.
- Push Finish button.
The result should be:
ID DATE VALUE
0 01/01/2000 100.0200
1 02/02/2001 200.0001
2 02/02/2002 300.1000
...
for the following number formats: DATE: YYYY/MM/DD, VALUE: 0.0000
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.