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

            Bug ID: 159862
           Summary: Calc Macro set SearchWildcard to False changes
                    SearchRegularExpression value.
           Product: LibreOffice
           Version: 7.3.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: [email protected]
          Reporter: [email protected]

Description:
In Calc, while using a Macro to modify the settings of a Search Descriptor,
setting the value of .SearchWildcard to false, even though .SearchWildcard is
already set to False, changes the value of .SearchRegularExpression to false
again if it was set tot true.

Steps to Reproduce:
1. Create a SearchDescriptor
2. Set .SearchRegularExpression to true
3. Set .SearchWildcard to false
4. Check the value of .SearchRegularExpression again. it will now be false.

Actual Results:
Setting .SearchWildcard to False, changes .SearchRegularExpression to False
also.

Expected Results:
If .SearchWildcard is set to False, .SearchRegularExpression should not be
altered.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
The below macro will demonstrate the error.

Sub main
  Dim oDescriptor  'The search descriptor

  oDescriptor =
ThisComponent.CurrentController.getActiveSheet().createSearchDescriptor()

oDescriptor.SearchRegularExpression = true 
msgbox(oDescriptor.SearchRegularExpression)

oDescriptor.SearchWildcard = fasle
msgbox(oDescriptor.SearchRegularExpression)

End Sub

Version: 7.3.4.2 (x64) / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

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

Reply via email to