Bug 161468 - Missing UNIQUE Formula in CALC
Summary: Missing UNIQUE Formula in CALC
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-08 02:53 UTC by Steve Ellsworth
Modified: 2024-06-15 18:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Steve Ellsworth 2024-06-08 02:53:15 UTC 
The functionality for the UNIQUE formula was to be added to CALC in 24.8. I attempted to use the formula in 24.8 AlPHA, and it appears to be missing. It did not present itself.
Comment 1 Buovjaga 2024-06-08 07:35:01 UTC 
That's because it was added after alpha1. See bug 126573 comment 27. Grab a daily build from https://dev-builds.libreoffice.org/daily/master/current.html or wait for beta1.
Comment 2 Steve Ellsworth 2024-06-15 18:08:54 UTC 
I do appreciate the update on the bug. Not sure if I should submit another ticket, but think I found one from the my loaded current build. 

If you enter =yearac(As,B2)*12, one should get the time between dates such as,

12 Jan, 2020 and the next cell is 20 June, 2020. That formula should return a number of 5.27. When entered on LibreOffice, I receive a value error.
Comment 3 Buovjaga 2024-06-15 18:52:34 UTC 
Doesn't sound like it involves UNIQUE, so please create a new report.