[Libreoffice-bugs] [Bug 115983] New: findAll and replaceAll methods have an unexpected behavior when they are called from the com.sun.star.sheet.SheetCellRanges service.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 115983
           Summary: findAll and replaceAll methods have an unexpected
                    behavior when they are called from the
                    com.sun.star.sheet.SheetCellRanges service.
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: framework
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tvataire at starxpert.fr

Description:
When the findAll or replaceAll methods are called from the
com.sun.star.sheet.SheetCellRanges service, the result include more cells than
expected if the ranges of the collection are spread over several sheets.


Steps to Reproduce:
Hereafter, a sample of code that reproduces the problem.
Step to reproduce :
1. quit LibreOffice.
2. save the script into the Scripts/python path of your user profile
3. execute the script with the command : <libo_install_path>/program/soffice
'vnd.sun.star.script:cellranges_replace.py$replace?language=Python&location=user'


Actual Results:  
If the following ranges are added to an empty SheetCellRanges collection :
- '$asheet'.$A$1:$B$2
- '$anothersheet'.$B$3:$C$4,
the searched value is found (and replaced) on the following ranges :
- '$asheet'.$A$1:$B$2
- '$anothersheet'.$B$3:$C$4
- '$anothersheet'.$A$1:$B$2
- '$asheet'.$B$3:$C$4
whereas the last two ranges are not part of the collection.


Expected Results:
The scope of the findAll and replaceAll methods should be restricted to the
ranges that are parts of the collection.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
This bug yet exists in LibreOffice 6.0.1.

A workaround is to browse ranges in the collection and call the findAll /
replaceAll methods on each of theses ranges.


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0

-- 
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/20180224/72504feb/attachment-0001.html>