Issue 6250

Summary: MSCompatability: Decimal align places trailing nonnumbers on right of decimal tab
Product: Writer Reporter: Unknown <non-migrated>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, oooqa
Version: OOo 1.0.0Keywords: oooqa
Target Milestone: ---   
Hardware: Other   
OS: Windows 98   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Hope this makes things clearer for you.
PNG screenshot of alignment issue.
example .doc none

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).