https://bugs.documentfoundation.org/show_bug.cgi?id=167028
Bug ID: 167028
Summary: [FormControls-TableControl] BorderColor cannot be set
directly, without setPropertyValue
Product: LibreOffice
Version: 24.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
When setting a Table Control’s BorderColor setting directly, using a Macro,
instead of using “setPropertyValue”, the following error is triggered:
“Inadmissible value or data type. Overflow.”
However while setting the Table Control’s Border color using “setPropertyValue”
the BorderColor is set without issue, using the same data value.
All other applicable Form controls allow the BorderColor to be set directly,
without needing to resort to “setPropertyValue”.
Steps to Reproduce:
Steps to reproduce:
1. Open a Writer document
2. Insert a TableControl Form Control.
3. Run the following Macro: (Note this Macro assumes there is only ONE CONTROL,
(the Table Control).
4. The error will occur as it is listed above. You may comment the direct
setting, and uncomment the “setPropertyValue” method to demonstrate that no
error occurs.
Macro:
Sub Main
Dim oShape1
Dim Color As Long
Dim FlatBorder
FlatBorder = 2
Color = 1000334
oShape1 = ThisComponent.DrawPage.getbyIndex(0)
msgbox(oShape1.Control.BorderColor)
oShape1.Control.Border = FlatBorder
oShape1.Control.BorderColor = Color
REM oShape1.Control.setPropertyValue("BorderColor", 1000334)
msgbox(oShape1.Control.BorderColor)
End Sub
Actual Results:
What occurs instead is there is a error triggered when trying to set the value
directly.
Expected Results:
What I expect should happen is the value should be settable without error using
either method.
Reproducible: Always
User Profile Reset: No
Additional Info:
In case it helps shed any light on things, when attempting to set the
BorderColor value using another language (AutoIt), the following error is
reported:
Description: Exception occurred.
Source: [automation bridge]
Error Description: InterfaceOleWrapper::Invoke :
[automation bridge]UnoConversionUtilities<T>:variantToAny
The provided VARIANT of type" 3" is unappropriate for conversion! at
C:\cygwin64\home\buildslave\source\libo-core\extensions\source\ole\unoconversionutilities.hxx:599
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
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 threaded
--
You are receiving this mail because:
You are the assignee for the bug.
