Bug 56989 - FILEOPEN particular .ods with FORMATTING loss
Summary: FILEOPEN particular .ods with FORMATTING loss
Status: CLOSED DUPLICATE of bug 58338
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.0.alpha0+ Master
Hardware: All All
: medium normal
Assignee: Markus Mohrhard
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2012-11-11 18:10 UTC by Rainer Bielefeld Retired
Modified: 2012-12-20 18:01 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2012-11-11 18:10:15 UTC 
I found the problem during my research for "Bug 56988 - FILESAVE of particular .ods adds rows in sheet with comments"

Steps how to reproduce with parallel installation of Master "LOdev  3.7.0.0.alpha0+   -  ENGLISH UI / German Locale  [Build ID: 70ec82)]"  {tinderbox: @16, pull time 2012-11-09 00:53:19} on German WIN7 Home Premium (64bit) with separate User Profile for Master Branch:

0. download Sample document of Bug 56988 "Attachment 69904 [details]"
1. Open document from LibO start Center
   Expected: Sheet "REPORT" shoud show dates in column B
   Actual: integer numbers

Strange: no problem with second sample of Bug 56988

Not reproducible with my own sample documents.

Not reproducible with other versions I tested for Bug 56988

@sandrve7:
Any ideas?
Comment 1 Joel Madero 2012-12-06 18:02:37 UTC 
Confirmed as a regression. 

Works fine in 3.6.3.2 but problem shows up in 4.1.0.0.alpha0

Marking as NEW and adding regression to whiteboard status
Comment 2 Joel Madero 2012-12-06 18:03:00 UTC 
Also changing platform to ALL as I verified this on Linux
Comment 3 Eike Rathke 2012-12-18 22:50:45 UTC 
Taking this
Comment 4 Eike Rathke 2012-12-19 10:58:24 UTC 
@moggi:
This might be your construction site with conditional formats. The cells
are assigned an automatic style style:name='ce3' style:data-style-name='N38'
where N38 is the long date format. Additionally this style has

<style:map style:condition='is-true-formula(OR(WEEKDAY([.A1])=7;WEEKDAY([.A1])=1))' style:base-cell-address='test.A1' style:apply-style-name='SabatoDomenicaScritteRosseGrassetto' />

to color weekends in red. Now that SabatoDomenicaScritteRosseGrassetto
inherits from Default and other than bold and red does not set anything
else and as such doesn't define it's own number format so that is
General, this may be related or not.

Somehow the cells' number format hard attribution is default General and the
style's date format is not applied.

Maybe you know ad hoc where to look at?

If this is not related to your changes assign it back to me.
Comment 5 Markus Mohrhard 2012-12-19 13:21:51 UTC 
Looks like another problem being fixed by http://cgit.freedesktop.org/libreoffice/core/commit/?id=8a028afd55decfd269268d0d1e6adcfbdc9d85d0
Comment 6 Eike Rathke 2012-12-20 18:01:11 UTC 
Indeed, that change applied fixes this, so actually a duplicate.

*** This bug has been marked as a duplicate of bug 58338 ***