I have tried pivot table functionality out again from the software “LibreOffice Calc 6.2.4.2-821.3” (Build-ID: 20(Build:2)). The option “Regular expressions” can be activated in the dialogue “Filter” for columns. https://help.libreoffice.org/6.2/en-US/text/scalc/guide/datapilot_filtertable.html Which kinds of regexes are supported here?
Hi Markus Elfring; thank you for your interest. Unfortunately, your question has nothing to do with bugs or enhancement requests, which are the only legitimate topics on this bug tracker. So please use https://www.libreoffice.org/get-help/community-support/ in case you need help. Wrt your question: the help topic you mentioned links to "Filter" page; in turn, it leads to "Options" help page; and the latter links to "List of Regular Expressions" [1]. Closing INVALID, since the topic is not a valid one for the site. Thanks! [1] https://help.libreoffice.org/6.2/en-US/text/shared/01/02100001.html.
(In reply to Mike Kaganski from comment #1) > Wrt your question: the help topic you mentioned links to "Filter" page; Yes. > in turn, it leads to "Options" help page; I have noticed the text “…, open Tools - Options - …”. > and the latter links to "List of Regular Expressions" [1]. You referred to documentation for the program “LibreOffice Writer 6.2”. Will any related adjustments become helpful also for the spreadsheet software?
Will a link (like the following) be added to the description of the pivot table filter document? https://wiki.documentfoundation.org/Documentation/HowTo/Calc/Regular_Expressions
(In reply to Markus Elfring from comment #2) > You referred to documentation for the program “LibreOffice Writer 6.2”. > Will any related adjustments become helpful also for the spreadsheet > software? I referred to the *shared* documentation, applicable from any module in LibreOffice, and linked from Calc help topic. No need to add more pages, since everything is already there.
(In reply to Mike Kaganski from comment #4) I was accidentally missing a direct link to a document from the section “Common Help Topics”. (I got doubts that regular expressions are working for pivot table filters as expected.)
(In reply to Markus Elfring from comment #2) > > in turn, it leads to "Options" help page; > > I have noticed the text “…, open Tools - Options - …”. Huh? The "Filter" help page [1] has a direct link "Options" ("Displays or hides additional filtering options") in the bottom [2]. [1] https://help.libreoffice.org/6.2/en-US/text/scalc/01/12090103.html [2] https://help.libreoffice.org/6.2/en-US/text/scalc/01/12090104.html
(In reply to Markus Elfring from comment #5) > (I got doubts that regular expressions are working for pivot table filters > as expected.) If you have doubts, please test them, and in case it doesn't work as expected, file specific bug reports with steps to reproduce. No need to discuss one's doubts. This all is rather off-topis here anyway. No idea why you decided to reopen this; still, I have no intention to start edit wars, so let others decide if this should be closed or not.
(In reply to Mike Kaganski from comment #7) Does a software behaviour difference matter in comparison to a program like “egrep”?
(In reply to Markus Elfring from comment #8) > Does a software behaviour difference matter in comparison to a program like > “egrep”? Do you mean something like "should a difference in regexp handling between LibreOffice and egrep be considered a bug"? No, we use a different regexp library - ICU (and generally, there are lots of regexp implementations, with different behaviours [1] [2]); the only thing that matters is that LibreOffice works as described in its own help. [1] https://en.wikipedia.org/wiki/Comparison_of_regular_expression_engines [2] https://en.wikipedia.org/wiki/Regular_expression#Standards
(In reply to Mike Kaganski from comment #9) There might be an opportunity for another bit of clarification in the provided software documentation to explain a different default configuration.