[Libreoffice-bugs] [Bug 133789] BASIC function DIR does not deliver correct result list

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133789

Alain Romedenne <alain.romedenne at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
             Blocks|                            |127692, 106040
     Ever confirmed|0                           |1

--- Comment #12 from Alain Romedenne <alain.romedenne at libreoffice.org> ---
Observations made under Windows 10: 

When using Dir function, I do not see runtime differences, regarding the use of
filename patterns, between LibreOffice Basic an VBA compatibility mode. 

However, Joachim statement is correct, LO Basic Dir function is case-sensitive
while M$-VBA Dir function is case-INsensitive. 

We may:
1. Keep Dir function unchanged for backward compatibility and
   document this LO/M$ difference in behavior within Dir function help page
2. Have a Dir function behaving differently when VBA compatibility is set.
3. Add an extra optional third argument in Dir Function, similar to Replace
function 'compare' argument.

Filenames pattern syntax, as offered in Basic Dir function, is much poorer than
what's available using regular expressions. I would devote filename pattern
matching to the latter, and retain case-sensivity since it accompanies all
'recent' operating systems.

I vote for option 1, while leaving place for supplemental observations and
different opinions. 

PS: I add Documentation and Macros META bugs references


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=106040
[Bug 106040] [META] Help bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=127692
[Bug 127692] Using big files with v. 6.3.1
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201116/e3cfdca4/attachment-0001.htm>