https://bugs.documentfoundation.org/show_bug.cgi?id=116127
Bug ID: 116127
Summary: Cell Range method ClearContents does not work with
com.sun.star.sheet.CellFlags.EDITATTR
Product: LibreOffice
Version: 6.0.1.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: volker.lenha...@uni-due.de
Description:
If I try to clear formatting within parts of the cell contents on a cell range
by a macro, nothing happens:
oRange.clearContents(com.sun.star.sheet.CellFlags.EDITATTR)
This behavior is proved for Windows 7, LO 5.3.7., Windows 10, LO 6.0.0.2 (32
bit) and for Linux openSUSE LEAP 42.2 with LO 5.3.0 and LO 6.0.1.1 (both
generic versions).
Doing so in AOO (any version) operates as desired, it clears the formatting of
text portions and gives the whole text the actual cell format.
Steps to Reproduce:
1. Take a sheet cell containing the text "blue and yellow".
2. Select the words "blue" and "yellow" and give them the CharColors blue and
yellow resp.
3. Take a cell range oRange containing that cell.
4. oRange.clearContents(com.sun.star.sheet.CellFlags.EDITATTR)
Actual Results:
All formats of text portions in a Calc sheet cell remain untouched.
Expected Results:
The formatting of text portions should be cleared and the whole text should be
given the color of the actual cell format.
Reproducible: Always
User Profile Reset: No
Additional Info:
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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs