https://bugs.documentfoundation.org/show_bug.cgi?id=151839
Bug ID: 151839
Summary: CharBackColor text property in Calc cells is available
in API, but not exported to file formats, nor
accessible from UI
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Since GSoC 2014's Matteo Campanelli's work on "Enhancing text frames" [1],
EditEngine supports CharBackColor property. This can be used not only in Draw
(as the GSoC project was called), but anywhere where EditEngine is used,
including Calc's cells. This code works and makes first three characters in A1
to be white-on-black:
Sub SelectFirst3CharsInCell
Dim oCell, oSheet, oCursor, oVCurs
oSheet = thisComponent.CurrentSelection.getSpreadsheet
oCell = oSheet.GetCellbyPosition(0, 0)
ThisComponent.CurrentController.Select(oCell)
oCell.setString("12345")
oCursor=oCell.Text.createTextCursor()
oCursor.gotoStart(False)
oCursor.goRight(3, true)
oCursor.CharBackColor = RGB(0,0,0)
oCursor.CharColor = RGB(255,255,255)
End Sub
In bug 88276, sidebar got a UI to set the property in text boxes (v.5.0); later
in the same bug it was added also to character properties dialog for text box
objects (v.5.1).
However, it never made it into Calc's cell character properties. Also it is not
saved to ODS.
It either needs to get full support (writing to ODS, UI access), or should not
be available from the API (the property is optional, so may be absent in case
of Calc's cell).
[1]
https://wiki.documentfoundation.org/Development/GSoC/Successfully_Implemented_Ideas#Improve_Text_Boxes_in_Draw
--
You are receiving this mail because:
You are the assignee for the bug.
