Issue 6250 - MSCompatability: Decimal align places trailing nonnumbers on right of decimal tab
Summary: MSCompatability: Decimal align places trailing nonnumbers on right of decimal...
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: Other Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2002-07-02 20:49 UTC by Unknown
Modified: 2013-08-07 14:38 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Hope this makes things clearer for you. (26.11 KB, application/octet-stream)
2002-07-15 15:46 UTC, Unknown
no flags Details
PNG screenshot of alignment issue. (38.36 KB, image/png)
2002-07-21 15:59 UTC, prgmgr
no flags Details
example .doc (19.50 KB, application/octet-stream)
2002-07-22 10:38 UTC, caolanm
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-07-02 20:49:03 UTC
This is a tiny issue but one which is giving us a major headache. The problem 
is that when you open a Word document in Openoffice the decimal tabs do not 
work in the same way. MS Word assumes that if a decimal point is not present in 
a number that it is at the end of that number, thus decimal tabs line up a 
column by the least significant digit. OpenOffice unfortunately center aligns 
these numbers throwing off all our columns.
We can't just left align the columns because they include negative numbers in 
brackets, the last digit must align vertically regardless of whether a bracket 
is present or not.
In case you haven't guessed this is an accounting firm and this is causing a 
major problem.
Thanks for your time.
Richard Blackman
Comment 1 prgmgr 2002-07-14 18:00:36 UTC
Thanks for a good post Richard.

Can you upload a sample file that demonstrates this problem?  As a 
bonus, some screenshots would be great.

Thanks again.
Comment 2 Unknown 2002-07-15 15:46:28 UTC
Created attachment 2233 [details]
Hope this makes things clearer for you.
Comment 3 prgmgr 2002-07-21 15:59:32 UTC
Created attachment 2301 [details]
PNG screenshot of alignment issue.
Comment 4 prgmgr 2002-07-21 16:01:45 UTC
Duplicated on Win NT 4.0, OO 1.0.1.

Decimal aligned tab stops do not recognize numbers in brackets.  
Hence the alignment uses the whole text ( number plus the brackets ) 
instead of aligning based on the decimal point of the number without 
the brackets.

I've included a screenshot to help clarify things.
Comment 5 caolanm 2002-07-22 10:38:12 UTC
If after a tab to a decimal aligned tab there is any number at all in
the following text portion, that number is placed at the decimal tab.
Any trailing text including brackets or any chracters are left past
the tab position.
Comment 6 caolanm 2002-07-22 10:38:43 UTC
Created attachment 2306 [details]
example .doc
Comment 7 caolanm 2002-07-22 10:41:14 UTC
cmc->ft: A feature request, Word decimal tabs work quite differently
and probably better for those trying to align columns of numbers when
the text portion after the tab contains a mixture of text and numbers.
Final example opened in word and writer clearly demonstrates.
Comment 8 falko.tesch 2003-10-27 16:26:53 UTC
FT->AMA: Wrong owner. Please be so kind to take over, thx.
Comment 9 andreas.martens 2003-11-06 14:38:21 UTC
I don't promise to fix it for OOo2.0, so I set target to "Later". On
the other hand we're planning some improvement for decimal tabstops
inside tables. During this implementation we'll keep this issue in
mind and see what we can achieve (for OOo2.0).