https://bugs.documentfoundation.org/show_bug.cgi?id=153502
Bug ID: 153502
Summary: Can a text substring search function for LibreOffice
Calc be created from the Data Sort filter string
capability?
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I don't seem to be the only one who wishes there were a substring function
available for use in formulas in LibreOffice Calc. And I'm decades out of date
as a programmer myself. But maybe it's a useful observation to point out that
the possibility of such a function seems to be implied by Calc's ability to
search for indicated strings in the entries in a sorted column. Could that
ability be used to create such a function?
Steps to Reproduce:
1. Look through string functions available, and notice the lack of a
SUBSTR[ING] function.
2. Then sort out a file so as to include the sorting filters in some or all
columns.
3. Click the arrow at the top of a column, and type in the "Search items..."
space the text that you want to test for in the column.
Actual Results:
You can find all rows with entries in that column which contain the
searched-for text.
Expected Results:
It would be nice to have a function to test entries for the desired text, a
function which returns at least TRUE or FALSE for the presence of the text in
each entry, so that you can use those results in a conditional formula -- e.g.,
=if(SUBSTRING(C4)=TRUE,D4*E4,0).
Reproducible: Always
User Profile Reset: No
Additional Info:
(This is a request for an enhancement, so I don't think there's any point to
resetting my UserProfile.)
--
You are receiving this mail because:
You are the assignee for the bug.
