Bug 114945 - Currency formatting replaced by date formatting
Summary: Currency formatting replaced by date formatting
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha0+
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-10 09:34 UTC by Xavier Van Wijmeersch
Modified: 2018-01-11 09:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
spreadsheet with conditional and cell style formatting (403 bytes, text/plain)
2018-01-10 09:34 UTC, Xavier Van Wijmeersch 		Details
test file (18.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-01-10 11:07 UTC, Xavier Van Wijmeersch 		Details
printscreen (51.83 KB, image/png)
2018-01-10 16:47 UTC, raal 		Details
View All 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 Xavier Van Wijmeersch 2018-01-10 09:34:24 UTC 
Created attachment 139011 [details]
spreadsheet with conditional and cell style formatting

When i insert a amount in exp column D and there is in column B a date then the currency format is replaced by date formatting.
But in column F the resulting sum is correct and the currency format is not changed.

Steps
1 in column B enter a date
2 in column C enter a comment
3 in column D enter a amount and enter. The calculation in column F is correct.      but the amount is changed in a date
Comment 1 Xavier Van Wijmeersch 2018-01-10 09:37:29 UTC 
Tested in LO from 5.3.2.1 to 6.1.0.0Alpha0 and are effected.
Comment 2 Xavier Van Wijmeersch 2018-01-10 09:39:18 UTC 
Tested in LO from 5.3.2.1 to 6.1.0.0Alpha0 and all are effected.
Sorry for the typo.
Comment 3 raal 2018-01-10 10:33:40 UTC 
Please attach test file. Attached file is txt file. Thank you
Comment 4 Xavier Van Wijmeersch 2018-01-10 11:07:21 UTC 
Created attachment 139013 [details]
test file

my mistake
Comment 5 raal 2018-01-10 16:47:52 UTC 
Created attachment 139021 [details]
printscreen

No repro with Version: 6.1.0.0.alpha0+
Build ID: 834cebd153573eea3cc321eca5bcb572b4776dec
CPU threads: 4; OS: Windows 6.1; UI render: default;
Comment 6 Xavier Van Wijmeersch 2018-01-11 09:22:04 UTC 
@raal

I don't know what went wrong, but now it doesn't repeat the behaviour

For me it can be closed as "works for me"
If needed i will reopen the report. Thx
Comment 7 raal 2018-01-11 09:30:58 UTC 
Thanks Xavier, closing