[Libreoffice-bugs] [Bug 116127] New: Cell Range method ClearContents does not work with com.sun.star.sheet.CellFlags.EDITATTR

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: volker.lenhardt at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180301/bb22f33b/attachment.html>