[Bug 129436] Unclear documentation of InStr "Compare" parameter

2024-08-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

f...@bger.ch changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |f...@bger.ch
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 129436] Unclear documentation of InStr "Compare" parameter

2024-08-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #7 from f...@bger.ch ---

apparently the compare parameter is rounded to int, and any non-zero value is
considered case insensitive.

 Instr(1, "LibreOffice Calc", "o",  0.4)   ' return 0

 Instr(1, "LibreOffice Calc", "o", -0.5)   ' return 6

see also transliteration "feature" in tdf#148650.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 129436] Unclear documentation of InStr "Compare" parameter

2024-03-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #6 from f...@bger.ch ---
for reference
https://help.libreoffice.org/latest/fr/text/sbasic/shared/03120401.html

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 129436] Unclear documentation of InStr "Compare" parameter

2019-12-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #5 from Olivier Hallot  ---
correction, string "ce".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 129436] Unclear documentation of InStr "Compare" parameter

2019-12-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #4 from Olivier Hallot  ---
(In reply to Jim Avera from comment #2)
> While fixing this, there are a couple of other improvements which could be
> made:
> 
> * Mention whether the first position of a string is 1 or 0.

Wrong. For the same example,

 iPos = Instr(4,"Office","f",0)

the result is 0 because the search starts at position 4 and 'f' occurs at 2 and
3. IOW, it will search 'f' in string 'ice'.

> 
> * Show the result from the code example (currently it just lists the code
> without saying what the expected result is).

Agree.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 129436] Unclear documentation of InStr "Compare" parameter

2019-12-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

Olivier Hallot  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 129436] Unclear documentation of InStr "Compare" parameter

2019-12-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #3 from Olivier Hallot  ---
In the example of the Help page on InStr, if we ommit Start and define Compare,
we get an error. E.g.

iPos = Instr(sInput,"c",0)

Thus I think the word "return" is misleading and should be removed.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 129436] Unclear documentation of InStr "Compare" parameter

2019-12-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #2 from Jim Avera  ---
While fixing this, there are a couple of other improvements which could be
made:

* Mention whether the first position of a string is 1 or 0.

* Show the result from the code example (currently it just lists the code
without saying what the expected result is).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 129436] Unclear documentation of InStr "Compare" parameter

2019-12-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=129436

--- Comment #1 from Jim Avera  ---
Typo, meant "unless the parameter is passed by reference"

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs