[Bug 172034] CALC: Autofilter by CONDITION presents a human date in the 1st selector but internal date subsequently
https://bugs.documentfoundation.org/show_bug.cgi?id=172034 BogdanB changed: What|Removed |Added CC||[email protected] ||g Blocks||103512 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103512 [Bug 103512] [META] AutoFilter-related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Bug 172034] CALC: Autofilter by CONDITION presents a human date in the 1st selector but internal date subsequently
https://bugs.documentfoundation.org/show_bug.cgi?id=172034 --- Comment #4 from ady --- Hmm. No repro with: Version: 26.8.0.0.alpha0+ (X86_64) Build ID: ddbd78e13a92747a2d68c836237f922fa6a43884 CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded This is the same LO Dev version tested by Miguel (comment 3), on a different OS version, UI Render and Locales. Having said that, the AutoFilter feature has never been consistent on Date columns (going back to LO 3.3). There are several issues with filtering dates, depending on the version of LO Calc. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 172034] CALC: Autofilter by CONDITION presents a human date in the 1st selector but internal date subsequently
https://bugs.documentfoundation.org/show_bug.cgi?id=172034 m_a_riosv changed: What|Removed |Added Ever confirmed|0 |1 CC||[email protected] ||rg Status|UNCONFIRMED |NEW --- Comment #3 from m_a_riosv --- Reproducible with: Version: 26.2.3.1 (X86_64) Build ID: d444ea7836163cb762d1627df3bc33e112fa142a CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded AND Version: 26.8.0.0.alpha0+ (X86_64) Build ID: ddbd78e13a92747a2d68c836237f922fa6a43884 CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
[Bug 172034] CALC: Autofilter by CONDITION presents a human date in the 1st selector but internal date subsequently
https://bugs.documentfoundation.org/show_bug.cgi?id=172034 Colin changed: What|Removed |Added Severity|normal |minor --- Comment #2 from Colin --- (In reply to Colin from comment #0) > When a date column is autofiltered and the intention is to select a range > then the procedure is to select the first date >= and the popup is a > "localised" date but the second selection for >= presents an internal date. My bad should say "but the second selection for <=" -- You are receiving this mail because: You are the assignee for the bug.
[Bug 172034] CALC: Autofilter by CONDITION presents a human date in the 1st selector but internal date subsequently
https://bugs.documentfoundation.org/show_bug.cgi?id=172034 --- Comment #1 from Colin --- Created attachment 207010 --> https://bugs.documentfoundation.org/attachment.cgi?id=207010&action=edit Screen Grab Demonstrating the error -- You are receiving this mail because: You are the assignee for the bug.
