Select a blank column in a table, change the number format (Time) from default to another format, click OK. Go to table and enter a time, the time stays at the what you typed in even thouugh the table -->format showed the changed selection. If you go back and look it is at number -- general. Reformating it again (after data entered, it changes to new format.
1. Create table
2. Select a column
3. Table --> Number Format -->Time
4. Change from 01:037:46 PM to 01:37 PM
5. Enter Data in a cell. Results look like line below after leaving cell.
6. Reformat the cell as step 3.
7 Results are correct after leaving cell.
After second format:
07/21/2011 05:29 AM
8. Need to do this for all cells in column even though the column was original
all formatted as step three above.
This worked properly in previous version.
openSUSE 11.4(184.108.40.206-0.7-desktop)|KDE Platform Version 4.6.5 (4.6.5) "release 7"|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce 8400GS (NVIDIA-Linux-x86_64-270.41.06)
This still occurs in LibreOffice 3.4.2 OOO340m1 (Build:1204).
Sorry for this being unnoticed such a long time.
I tried to reproduce in both 3.4.3 and 35master. But cannot. Everything works as expected ..
LibreOffice 3.4.2 OOO340m1 (Build:1205)
Update about an hour ago from Build 1204. This problem appears to be fixed. i will check openSUSE 12.1 and make sure it is uptodate and this is fixed. Will post.
Cor: Thanks for looking into this.
I will be posting another problem with calc and writer if this update did not correct it.
(In reply to comment #3)
> Update about an hour ago from Build 1204. This problem appears to be fixed. i
> will check openSUSE 12.1 and make sure it is uptodate and this is fixed. Will
Great to read that.
Alas I won't be able to join the QA party tomorrow. Maybe you can take my place ..:-)
Note this bug has reappeared in both openSUSE version of 3.4.4 and Vanilla version from LibreOffice website in the writer (Table-->Number Format).
LibreOffice 3.4.4 OOO340m1 (Build:402)
openSUSE 12.1 (3.1.0-1.2-desktop #1)
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
This is still failing in LibreOffice 3.4.4 OOO340m1 (Build:402)from LibreOffice download website.
To demonstate (In Writer):
1. create a table with four columns and 4 rows.
2. First row is header: Date, Time, Amount Each, Total Amount
3. Select and highlight blanks in first column Then select Table --> Number Format-->Date--> December 31, 1999.
4. Repeat for next three columns, selecting Time--> 01:37 PM; and Currency -->
5. Go back and type in Column three dates in format mm-dd, time in format 01:09 and currency such as 34.76 for last two columns.
In past these would come up in the format selected as you move thru each box with a tab or with mouse clicking outside of the current cell.
Only way it appears to work now is to enter data in all cells in the column, highlight them and then format the cells with correct option.
This appears to be a regression or was it a change made to the way format number works?
reproduced in LibO 3.5.0 master on Fedora 64 bit
not reproducible in 3.3.4, therefore regression
Please, see on it
I am now on openSUSE 12.1, KDE 4.8.0 and LibreOffice LibreOffice 3.4.5
This bug still exists. If I have a table in a writer document. Say 4 colums. and x rows. If I select a column and go to Table--> number format --> Time and select 01:37 PM and then Ok. I would assume the column would be set to enter a time such as 07:30 and it would change to 07:30 AM when I Tab or hit enter. This is how older versions worked.
Now it does not change or add the am or pm. I can go back and select the above and it will then convert what I typed to an am or pm time.
This is real pain to have to format each entry or wait untill all are done and format.
Does same thing with date.
let me know what I can provide?
I tested this in 3.4.5 It works fine there.
But it does not work fine in 3.5.0RC3 and 3.5.0RC1
Interesting that the original bug was in a version where I/others could not reproduce it...
though there is a work around, a nasty problem IMO
(In reply to comment #11)
> I tested this in 3.4.5 It works fine there.
> But it does not work fine in 3.5.0RC3 and 3.5.0RC1
> Interesting that the original bug was in a version where I/others could not
> reproduce it...
What build of 3.4.5. I have LibreOffice 3.4.5 OOO340m1 (Build:502) from LO website. It fails in it. I can format a column in the table if I enter data first but I cannot format an empty column and then enter the data and have LO set the correct format.
I have OOO340m1 (Build:502) from the LibreOffice website too ...
Hmm, what are your settings in Tools > Options > Writer > Table > Number recognitin (or was this already checked ??)
(In reply to comment #14)
> @ russ:
> I have OOO340m1 (Build:502) from the LibreOffice website too ...
> Hmm, what are your settings in Tools > Options > Writer > Table > Number
> recognitin (or was this already checked ??)
Nothing is checked under number recognition. This is first time I ever looked at this option, Is it one where the default changed? Should number format recognition be checked?
(In reply to comment #15)
> Is it one where the default changed? Should number format
> recognition be checked?
Well, just tested it. WIth NUmber formatting checked, the setting is recognised.
With not checked, you get the initial result of this report.
Maybe you could check documentation or aks on users list if people know if that behaviour is as designed ?
Regression does appear in oldest version of bibisect-3.5.tar.lzma and must be older.
the setting in Tools > Options does not make this difference in OOo330m20 / DEV300m105
@ Russ, Sasha
Is the following problem the same you observed, or is it another problem? Do:
(1) Start LO and open a new text document.
(2) Check Option "LibreOffice Writer > Table > Input in tables > Number recognition", if not checked already.
(3) In the same Dialog uncheck options "Number format recognition" and "Alignment" if not unchecked already.
(4) Insert a table.
(5) Mark all cells of the table and assign number format (Menu: Table > Number Format...): Category: "Number"; Format: "-1,234.12"; Language: "English (USA)"
(6) Insert "123.4567" into a cell. Go to next cell (with mouse or with button Tab). The number changes to "123.46". The number format of the cell is still "Number".
I expect this: Change of the number format to "Text" and the contents should be still "123.4567".
Help text of option "Number format recognition": "If Number format recognition is not marked, only input in the format that has been set at the cell is accepted. Any other input resets the format to Text."
Behaviour observed in Versions 3.4.6 and 3.5.2 with Win XP.
I start to get more and more the feeling that the bug is complexity and a not so clear help-text.
Step by step description of settings and resulting behavrour would possibly fix this :-)
thanks for comment. According complexity: I did not check all possibilities but I think the bug I found can be summarized in one sentence:
Number Format Recognition in Writer tables is performed, though the option "Number Format Recognition" is not checked.
But I am not sure, if the problem raised by Russ is the same problem.
Thanks for interesting in Writer tables
Your bug is different from original bug. Currently in 3.5.2 I can not reproduce original bug. May be it is fixed.
Currently "Number recognition" works globally. And when disabled, number format of cell resets to "Text" when we delete content of cell and type another.
Expected: "Number recognition" can set individually for each table (otherwise it should be "Global number recognition"). And when disabled it not changes format of cells, just not recognize content.
Actually: "Number recognition" enables/disables globally. And changes format of newly changed cells to "Text"
Please, create separate bugreport for this problem.
Just checked, tools--options-->writer-->Table and it had number recognition check but also had number format recognition and alignment checked. I unchecked them and it now appears to be working. This must have happened in switching from LibreOffice version to openSUSE version.
Looks like its working again.
(In reply to comment #23)
> Looks like its working again.
Thanks for reporting and sorry for the inconvenience of course.
Glad it's OK for you now to.
Thanks for all your help. Next Time I install I'll check that first.
Created separate bugreport for found problem:
Bug 48763 - Writer FORMATTING: table option "Number recognition" behaves in wrong way
Changing status to WroksForMe, because we do not know by which patch bug fixed
(In reply to comment #22)
> @ email@example.com
> Your bug is different from original bug. Currently in 3.5.2 I can not reproduce
> original bug. May be it is fixed.
For 'my' bug I just have written a separate bug report: