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 2011/11/09 19:46:54 UTC
DO NOT REPLY [Bug 118590] New: Tables in Writer do not respect
locale format
https://issues.apache.org/ooo/show_bug.cgi?id=118590
Bug #: 118590
Issue Type: DEFECT
Summary: Tables in Writer do not respect locale format
Classification: Code
Product: l10n
Version: OOO330m20
Platform: PC
OS/Version: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P5
Component: localedata
AssignedTo: ooo@erack.de
ReportedBy: info@fotoab.de
CC: ooo-issues@incubator.apache.org
Created attachment 76992
--> https://issues.apache.org/ooo/attachment.cgi?id=76992
Sample Writer document with inserted table - play around with it!
If numbers in a table inserted in a Writer document are the results of a
calculation - for example, a simple multiplication of a quantity column and a
cost column - the result column format is incorrect. While numbers can be
right-clicked and the "Number format" chosen, a decimal tab in that column's
ruler has no effect and different length numbers are not correctly aligned to
the (different) decimal point symbol for the chosen langauge.
In my specific case I'm writing an invoice or a purchase order in US dollars on
a system that is set up for German by default. Any alteration to the figures
throws out the chosen US format with a comma thousands separator and decimal
point and reverts to German with a dot thousands separator and decimal comma.
This gives a diabolically incorrect mathematical result.
Changing the format after figures have already been entered in cells even
changes the figures to zero!
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118590] Tables in Writer do not respect locale
format
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118590
mla@openoffice.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |ms_interoperability
Priority|P5 |P3
Status|UNCONFIRMED |NEW
Component|formatting |open-import
Ever Confirmed|0 |1
--- Comment #5 from mla@openoffice.org 2011-11-10 11:00:42 UTC ---
The formatting and formulas are working after adjustment. However, when closing
and reopening the doc this is gone. Needs to be investigated in the
import/export filters.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118590] Tables in Writer do not respect locale
format
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118590
mla@openoffice.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Version|OOO330m20 |OOo 3.3
Component|localedata |formatting
Platform|PC |All
AssignedTo|ooo@erack.de |writerneedsconfirm@openoffi
| |ce.org
Resolution| |INVALID
Product|l10n |Word processor
OS/Version|Windows 7 |All
--- Comment #2 from mla@openoffice.org 2011-11-10 00:15:57 UTC ---
I cannot see any problems with changed formatting or wrong sum formulas. Please
note that you have to setup the language and number formatting correctly (in
this case: number format and language). Select the table cell(s) and choose
"Number Format" from the context menu (right mouse click).
I've attached a corrected version that doesn't change its format.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118590] Tables in Writer do not respect locale
format
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118590
mla@openoffice.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118590] Tables in Writer do not respect locale
format
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118590
info@fotoab.de changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CLOSED |UNCONFIRMED
Resolution|INVALID |
--- Comment #4 from info@fotoab.de 2011-11-10 08:51:54 UTC ---
Thanks for the 'corrected' document. Make a change to either quantity or price,
try and update the total/sum (Tools > Update ... ) and the result is not
updated. I therefore have to reenter the formula (=<b3>*<e3>). The result has
lost the previously chosen (in this case American) format.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118590] Tables in Writer do not respect locale
format
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118590
--- Comment #1 from mla@openoffice.org 2011-11-10 00:14:37 UTC ---
Created attachment 76993
--> https://issues.apache.org/ooo/attachment.cgi?id=76993
Sample Writer document with inserted table - corrected
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118590] Tables in Writer do not respect locale
format
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118590
orcmid <or...@openoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orcmid@openoffice.org
--- Comment #3 from orcmid <or...@openoffice.org> 2011-11-10 01:11:25 UTC ---
It is difficult from this description and the two files to know if the problem
is lack of sufficient definition to reproduce or something else.
(It is not helped that the Bugzilla has identified the attachments as having
application/msword MIME type when they are clearly .odt files.)
Since the submitter asserts that there are visible problems, presumably it is
important to understand how to reproduce the German language setup and the
procedure that brought the spreadsheet-calculated table into Writer.
I would hope that the submitter is able to provide a more-controlled case and
scenario so that the source of discrepancy is apparent. It might not be a
defect, but it is too hard to tell.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.