Bug 121977 - Function for reversing string order
Summary: Function for reversing string order
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2018-12-08 05:51 UTC by Philipp
Modified: 2020-09-08 23:05 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Philipp 2018-12-08 05:51:17 UTC
See this issue:
https://ask.libreoffice.org/en/question/60144/formula-or-function-to-reverse-a-string/?answer=175507#post-id-175507

Could you please include this feature as a standard string function in LibreOffice? Like Excel has done in =StrRev. Thanks!
Comment 1 raal 2018-12-09 08:33:36 UTC
Hello,
you wrote
I cannot find any documentation, but the functions described here: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/strreverse-function
Philipp gravatar imagePhilipp ( 37 mins ago )

and this leads to ms VBA reference: Visual Basic for Applications  Functions  StrReverse

Mike wrote that VBA function works: Could you please point to the "StrRev" function documentation for Excel? (There's none in Excel 2016 AFAIK; there's a VBA StrReverse, also present in LibreOffice's VBA compatibility mode.)
Mike Kaganski gravatar imageMike Kaganski ( 26 hours ago )

So, where is problem? Please attach test file which works in excel, but not in LO. (Like Excel has done in =StrRev.)
Thanks
Comment 2 QA Administrators 2019-09-02 09:32:31 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2019-10-03 03:04:26 UTC Comment hidden (obsolete)
Comment 4 b. 2020-09-08 23:05:14 UTC
is it just the misunderstanding that @Philipp asked for "StrRev" and the correct name in VBA and in LO Basic is "StrReverse"??? 

as this sample:  

option vbasupport 1

function test_strrev(cell)
   test_strrev = strreverse(cell.value)
End Sub 'test_strrev(cell)

works and as @Mike Kaganski described and illustrated similar with videos in  
https://ask.libreoffice.org/en/question/60144/formula-or-function-to-reverse-a-string/?answer=175507#post-id-175507  

i think the correct result for this bug is notabug ...