Apache OpenOffice (AOO) Bugzilla – Issue 25874
Tables in Writer have Number Format alignment problem
Last modified: 2013-08-07 14:38:26 UTC
We are running OO on Red Hat 8 remote shells to NCD thin clients. If I open a new document and insert a table into it and select the whole table, then set the number format to numbers, when I start entering numbers into the cells and move to the next cell it takes what I entered in the previous cell and left aligns it. I tested this on an XP PC and it worked right. or I created a new table and select it all and set it to align right and then set the number format to numbers enter some digits, actually reset the cells again so it right algns, go back and select them and then set the number format to text it throws my alignment back to the left. I tested this on an XP PC and it had the same result. Something isn't quite right here???
Sorry! In the first scenario after I select the whole table I set it to align right before I set the number format to Numbers.
set target OOo later
Reassigned to MRU
In the first case, there seems something to be wrong. Second case looks quite correctly to me. For any reason, in the first case the numbers you enter are interpreted as text by OO, which makes OO's table align them to left. I cannot reproduce the problem with OO 1.1, so please tell me, on which locale you work respective which defaul language do you use. Maybe the problem is digged there... Thanksin advance for information!
City of Largo, Florida, USA English(USA)
I'm also seeing this issue. OpenOffice-1.1.1 on Windows 2000 sp4. Create a new text document. Insert a table with 2 columns. Enter a date in a column. It gets center-aligned. OK so far. Now change the date to a different value and exit the field. Still OK. Now left-align it. Still OK. Now edit the date and exit the field. Field is now right-aligned. NOT OK!
MRU->AMA: the behaviour is not really consistent. When there's an alignment set by a style (such as in the table header) the alignment is not overwritten by the number recognition. If the alignment is set as a hard attribute, the number recognition overwrites this. I think, this is not very transparent for a user.
I have a table. In one column I am adding a number (as text - it refers to an element of a list which I happened to have numbered but I could have labelled a,b,c etc for example). When I first enter the number it is left aligned. When I tab to the next box it jumps to the bottm right hand corner of the box if it is a single number. If I add additional numbers in a comma separated list (or add a carriage return) the text stays aligned in the top left corner. This only happens with numbers, not with letters
-> tallus, I don't see the bug?! Our number recognition recognizes single numbers and if it does so, these number will be right aligned. BTW: You may disable this feature Tools/Options/Text Document/Table/Table input, if you don't like it. And you're able to stay with the number recognition but to get rid of the automatically alignment. -> all, AFAIK our alignment algorithmn works like this: if it recognized a number and if the alignment is not centered (like in table headings!) a hard attribute with alignment right is set. It's not important if the attribute was a style or a hard attribute, only "centered" will be saved, other will be overwritten. I've to admit it's not that transparent and I appreciate suggestions for improvement.
This is a duplicate of bug #54397 (or vice versa).