See this: https://bytefreaks.net/applications/libreoffice-calc-get-the-distinct-unique-values-in-a-column-or-a-list-of-elements
You can use Ctrl-z to undo the command, but don't use Ctrl-Shift-y to redo it
on another column. You must go through the command again on another column and then do Ctrl-z again. Mike On 6/9/21 3:07 AM, users+h...@global.libreoffice.org wrote:
Many moons ago I was using some Calc sheets with AutoFilter routinely. The filter value would be changed, the sheet closed and sometime later opened again. To understand the displayed rows the filter values needed to be known. And that involved opening each filter and checking the value. So I asked, is there a way to display those values? No answers. And the need went away. Just recently had the same need in Excel. Found online the exact answer needed to make it work. https://www.extendoffice.com/documents/excel/1444-excel-display-show-filter-criteria.html The section "Display / Show auto filter criteria in worksheet with VBA code" is what I referenced. I've used that info to try and extrapolate a similar method in Calc to no avail. Have done a limited amount of searching in Andrew Pitonyak's OpenOffice.org Macros Explained book and searched through OASIS Open Document Format documents using terms like "filter" and "range". The answer might have been staring me in the face, I'm thinking in particular of section 15.6.3 of Andrew Pitonyak's OpenOffice.org Macros Explained, but I just didn't understand it. Can anyone provide guidance to display the autofilter values in a Calc sheet equivalent to the instructions provided for Excel at the link above? Thank you.
-- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy