Bug ID: 115983
           Summary: findAll and replaceAll methods have an unexpected
                    behavior when they are called from the
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: framework

When the findAll or replaceAll methods are called from the 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

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

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to