Bug 91298 - Standard Filter: Value changes to serial number
Summary: Standard Filter: Value changes to serial number
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.6.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-15 06:42 UTC by HD
Modified: 2020-06-07 16:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
sample data (18.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-05-15 06:42 UTC, HD
Details

Note You need to log in before you can comment on or make changes to this bug.
Description HD 2015-05-15 06:42:59 UTC
Created attachment 115615 [details]
sample data

Text such as "Dec 2" changes to serial number in Standard filter.

Steps to reproduce :

 1.Open attached document.
 2:Click [Data]-[Filter]-[Standard Filter].
 3:Set the following criteria then click [OK].

   "Column A" "=" "Dec 2"
   AND
   "Column C" "=" "1"

 4:Save the document.
 5:Click [File]-[Reload].
 6:Click [Data]-[Filter]-[Standard Filter].

Result :
You can see the Value of criteria 1 is changes to "42340"(serial number of 12/02/2015).

Test environment :
-Windows 7
-LibreOffice 4.3.6.2
-User interface: English(USA)
-Locale setting: English(USA)
Comment 1 A (Andy) 2015-05-15 07:32:36 UTC
Reproducible with LO 4.4.3.2, Win 8.1, but in my case criteria 1 is changed to "37591"
Comment 2 QA Administrators 2016-09-20 09:41:49 UTC Comment hidden (obsolete)
Comment 3 raal 2018-06-12 17:08:24 UTC
Reproducible with Version: 6.2.0.0.alpha0+
Build ID: c4c56de1b0e62ec866b519b2b24c5e805f0a86d3
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 4 QA Administrators 2019-06-13 03:00:18 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2020-06-07 16:31:51 UTC
no repro in

Version: 7.1.0.0.alpha0+
Build ID: 2047a5978ac8188e61da9cd3b2f40d86df5570bb
CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded

I see Dec 2 as condition in the dialog (and for en-US locale too)

so it's WFM now