Bug 35505 - Using autoformat removes date-formatting in certain circumstances
Summary: Using autoformat removes date-formatting in certain circumstances
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version: 3.3.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-21 06:21 UTC by Larsen
Modified: 2013-12-28 16:51 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
File to reproduce the problem (9.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-21 06:21 UTC, Larsen
Details

Description Larsen 2011-03-21 06:21:28 UTC
Created attachment 44670 [details]
File to reproduce the problem

Steps to reproduce using the attached file:
1. Select A1 to G5
2. Format > AutoFormat
3. Add new template
4. Click ok to apply the template

Result:
The dates in the column "birthday" are converted to numbers.

Though, when you first delete column C, the dates are preserved.
Comment 1 Rainer Bielefeld Retired 2011-05-03 00:10:30 UTC
I can confirm the reported effect with "LibreOffice 3.4Beta3  – WIN7  Home Premium  (64bit) German UI [DEV300m103 (Build:3)]", but I know too few about auto format to decide whether it's a bug and what the reasons might be.

But the result is unexpected, or course.
Comment 2 Björn Michaelsen 2011-12-23 11:46:19 UTC
[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:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 3 Larsen 2011-12-24 02:37:02 UTC
Tested with LOdev 3.5.0: now crashes LO and the Windows error reporting shows up. No further information is visible.
Comment 4 Rainer Bielefeld Retired 2011-12-24 03:03:58 UTC
<http://wiki.documentfoundation.org/BugReport_Details#Version>
Thank you for 3.5 Review!
Comment 5 A (Andy) 2013-12-28 16:51:46 UTC
I have tested it and I could reproduce it with LO 4.1.4.2 (Win8). The date category of the cells was changed to numbers, so that they lost the dates. This was done without a crash of LO.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.