Bug 44310 - Base: Table field format, format code error. Field formatting resets.
Summary: Base: Table field format, format code error. Field formatting resets.
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.4.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 44307 44308 (view as bug list)
Depends on:
Blocks:
 
Reported: 2011-12-29 23:56 UTC by jorge.alberch
Modified: 2012-09-03 10:23 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
original data (4.09 KB, application/vnd.sun.xml.base)
2012-05-14 03:28 UTC, jorge.alberch
Details
attempting to replicate error (34.56 KB, application/vnd.sun.xml.base)
2012-05-14 03:28 UTC, jorge.alberch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jorge.alberch 2011-12-29 23:56:52 UTC
Problem description: In the tables, then field format, the format code resets from time to time.

This appear to be especially prevalent when making changes to the database or following a the crashing of the database.


Steps to reproduce:
1. Create table. Then in design view add some fields. Choose field type "decimal".
2. Go to format example and select e.g. #,##0.00.
3. Save changes, then close, then open database.
4. Repeat. Make more changes. Add table. Add fields. Crash system if possible.
5. Eventually somehow the formats are reset. I could not pinpoint exactly what triggers this format being reset.

Current behavior: Table field formatting resets/ is lost once in a while.

Expected behavior: Table field formatting being permanent.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7
Comment 1 jorge.alberch 2011-12-30 00:02:09 UTC
*** Bug 44307 has been marked as a duplicate of this bug. ***
Comment 2 jorge.alberch 2011-12-30 00:04:14 UTC
*** Bug 44308 has been marked as a duplicate of this bug. ***
Comment 3 sasha.libreoffice 2012-05-03 06:36:21 UTC
Thanks for bugreport
Please, attach two databases: produced in step 3 and produced in step 5
Comment 4 jorge.alberch 2012-05-14 03:28:15 UTC
Created attachment 61601 [details]
original data
Comment 5 jorge.alberch 2012-05-14 03:28:40 UTC
Created attachment 61602 [details]
attempting to replicate error
Comment 6 jorge.alberch 2012-05-14 03:30:20 UTC
Dear sasha,

Sorry for the late response.

I've tried to duplicate the error but without success. (I'm attaching the databases so you can see what I'm trying to do, but otherwise you can ignore them).

I'll continue testing and see what exactly might be causing the problem.

Thank you.
Comment 7 sasha.libreoffice 2012-05-14 03:43:40 UTC
Thanks for attachments. May be it fixed in 3.5.3
Comment 8 Jochen 2012-08-24 21:55:03 UTC
Hi Jorge,

exists your problem still using LO 3.6.0 or 3.6.1 RC1?
Comment 9 jorge.alberch 2012-08-27 11:23:07 UTC
(In reply to comment #8)
> Hi Jorge,
> 
> exists your problem still using LO 3.6.0 or 3.6.1 RC1?

I have now just installed LibreOffice 3.6.0:

- I continue to loose the formatting on the tables on my existing database that I use at work everyday. However this database is almost a year old and has gone through x100s of edits, so there might be some "bug" that I'm carrying with it.

- I'm trying to replicate the error on a fresh test database, but so far I'm unsuccessful. I'll continue testing for a while and see if I manage to "break" the new test database.
Comment 10 Jochen 2012-08-27 12:27:04 UTC
(In reply to comment #0)
> Steps to reproduce:

I don´t understand what Jorge want to say.
Reproducing the steps all works fine (OS: Windows XP; LO 3.6.0)

@Jorge:
1) List the single steps - e.g. "create table": click on "Create Table in Desing View..." etc.
2) Please create screenshot(s)

@Robert:
Have you time to look at this bugreport? Can you reproduce what Jorge means.
Comment 11 jorge.alberch 2012-08-27 13:07:03 UTC
(In reply to comment #10)
> (In reply to comment #0)
> > Steps to reproduce:
> 
> I don´t understand what Jorge want to say.
> Reproducing the steps all works fine (OS: Windows XP; LO 3.6.0)
> 
> @Jorge:
> 1) List the single steps - e.g. "create table": click on "Create Table in
> Desing View..." etc.
> 2) Please create screenshot(s)

Table formatting works fine...

But *sometimes* this table formatting is lost. I'm working with numbers formatted with "Thousands separator" box checked in the Field Format dialog and also right alignment.

Everything will look fine, I double check, close, open, close and open again the table and also the database... still everything ok. Then I'll close and open the database once more and voila! Formatting now is lost: numbers no longer have the thousands separator, and sometimes the alignment has reverted to the left default.

Again... this a rather frequent occurrence on my "old" database that I use at work every day and I've edited hundred of times.

However I'm trying to replicate (unsuccessfully) the problem with a fresh database. (Maybe I've got something on my big work database that's causing the problem... maybe legacy issue/ bug/ corruption... maybe it's some feature that I'm using on this database and not on the new test database such as macros, queries, reports... ????)

...

Meanwhile I will continue to attempt to replicate error with new test database...
Comment 12 Jochen 2012-09-01 18:20:21 UTC
Hi Jorge,
how does it look: can you reproduce the behavior with a new Base-file still?
Can it be that the problem exists only with your "old" Base-file?
Comment 13 jorge.alberch 2012-09-02 09:03:00 UTC
Dear all,

Thank you for all your given support.

I have decided to close the bug as I'm simply unable to replicate the error outside of my "old" database. 

(Maybe my "old" database odb file that goes back a number of versions and I use everyday and have edited 100s of times might have gotten corrupted/ carries some legacy bug/ or who knows what...)

So: for now I'm closing this "bug".

Thank you all!
Comment 14 sasha.libreoffice 2012-09-03 10:23:14 UTC
Thanks for additional testing
Due to last comment, changing status to WorksForMe

If problem will reproduced from scratch, please, change status to Reopened