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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116129
           Summary: Calc Cell Range method ClearContents does not work
                    with com.sun.star.sheet.CellFlags.STYLES
           Product: LibreOffice
           Version: 5.3.0.3 release
          Hardware: All
                OS: 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 remove cell style formatting on a Calc sheet cell range by a macro,
nothing happens:

oRange.clearContents(com.sun.star.sheet.CellFlags.STYLES)

But if I combine STYLES with HARDATTR, not only all hard formatting is set to
default, but formatting with cell styles is removed as well. This way you can
remove cell style formatting, but with the drawback of getting default formats
in the rest of the cells.

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).

Steps to Reproduce:
1. Format a sheet cell with some cell style.
2. Take a cell range oRange containing that cell.
3. oRange.clearContents(com.sun.star.sheet.CellFlags.STYLES)
4. Nothing happens
5. oRange.clearContents(com.sun.star.sheet.CellFlags.HARDATTR Or
com.sun.star.sheet.CellFlags.STYLES)


Actual Results:  
With (com.sun.star.sheet.CellFlags.STYLES) alone nothing happens.
With (com.sun.star.sheet.CellFlags.HARDATTR Or
com.sun.star.sheet.CellFlags.STYLES) all cells in the range are reset to
default formats incl. the cell with cell style.

Expected Results:
With (com.sun.star.sheet.CellFlags.STYLES) alone all cells formatted by cell
styles should be reset to default formats.


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/c5fad5b9/attachment-0001.html>