[Libreoffice-bugs] [Bug 58687] : No 'Unique' formula
https://bugs.freedesktop.org/show_bug.cgi?id=58687 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WONTFIX -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58687] : No 'Unique' formula
https://bugs.freedesktop.org/show_bug.cgi?id=58687 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58687] : No 'Unique' formula
https://bugs.freedesktop.org/show_bug.cgi?id=58687 --- Comment #3 from Winfried Donkers --- (In reply to comment #2) A clear answer. It seems to me that this bug report can be set to resolved - notabug or worksforme. @Juan, do you agree? If so, will you close this bug report? Thank you for your help. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58687] : No 'Unique' formula
https://bugs.freedesktop.org/show_bug.cgi?id=58687 --- Comment #2 from Eike Rathke --- I don't think a UNIQUE function is a good idea. Such function would need to return an array that would change its size with data change. An array formula has a fixed return size, while removing entries from that return array and displaying #N/A for non-available entries is possible, adding entries is not. Formulas are not meant to overwrite cells that do not belong to the formula. It's also not "some strange set up and an advanced filter" you need. All you have to do is select the data range, go to Data->Filter->StandardFilter, select the field to query with Condition '=' and the special value "Not Empty", and in More Options choose "No duplication" and let the output be generated starting at a defined cell reference with "Copy results to". That is the standard spreadsheet procedure to generate a list of unique values from a set of data. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58687] : No 'Unique' formula
https://bugs.freedesktop.org/show_bug.cgi?id=58687 Winfried Donkers changed: What|Removed |Added OS|Linux (All) |All Status|UNCONFIRMED |NEW CC||er...@redhat.com, ||o...@dci-electronics.nl Ever confirmed|0 |1 --- Comment #1 from Winfried Donkers --- I confirm that such a function is presently absent in Calc. There seems to be no 'UNIQUE' function defined in Open Document Format for Office Applications (OpenDocument) Version 1.2, Part 2: Recalculated Formula (OpenFormula) Format. @Eike: you know whom to address when adding a formula to ODF seems desirable. Without a proper definition of the formula, it looks unwise to me to start adding such a function. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58687] : No 'Unique' formula
https://bugs.freedesktop.org/show_bug.cgi?id=58687 Markus Mohrhard changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs