Bug 162601 - function UNIQUE is case-insensitive in Excel but case-sensitive in Calc
Summary: function UNIQUE is case-insensitive in Excel but case-sensitive in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Excel-Functions
  Show dependency tree / graph
 
Reported: 2024-08-23 22:07 UTC by Regina Henschel
Modified: 2024-08-25 01:12 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Test results for function UNIQUE (15.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-08-23 22:07 UTC, Regina Henschel 		Details
Same data but as xslx file to examine behavior in Excel (12.81 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-08-23 22:08 UTC, Regina Henschel 		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 Regina Henschel 2024-08-23 22:07:48 UTC 
Created attachment 195990 [details]
Test results for function UNIQUE

The new function UNIQUE is case-sensitive in Calc, but case-insensitive in Excel.

Expected: The function behaves the same as in Excel.

[@tester: The new function UNIQUE does not react on option "Case sensitive" in Tools > Optiones > Calc > Calculate. That is no bug. The function UNIQUE is expected to be independent from these global settings.]
Comment 1 Regina Henschel 2024-08-23 22:08:39 UTC 
Created attachment 195991 [details]
Same data but as xslx file to examine behavior in Excel
Comment 2 m_a_riosv 2024-08-24 01:45:22 UTC 
Reproducible
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 85e4dc15d09dc3193870041b2814263971a27791
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
compared
Microsoft® Excel® para Microsoft 365 MSO (versión 2407 compilación 16.0.17830.20056) de 64 bits