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

2018-03-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116129

Oliver Brinzing  changed:

   What|Removed |Added

 CC||oliver.brinz...@gmx.de

--- Comment #5 from Oliver Brinzing  ---
.

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


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

2018-03-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116129

--- Comment #4 from Volker Lenhardt  ---
Created attachment 140291
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140291=edit
Macros to display bugs using Calc cell range method clearContents with some
CellFlags

This attachment shows a set of formatted cells, numbers, date/time, strings, B3
being formatted with a cell style, as well as two cells (B4 and C4) with text
portion formatting.

You can try the effect on B3 (in fact no effect at all) by calling the macro
Sub ClearContentsByCellFlagsSTYLES

If you call the macro
Sub ClearContentsByCellFlagsHARDATTROrSTYLES
then not only all cell formatting is set to default, but B3 loses the cell
style, too.

The file comes with an additional macro to serve as an example for bug 116127
as well:
Sub ClearContentsByCellFlagsEDITATTR

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


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

2018-03-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116129

Xisco FaulĂ­  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org

--- Comment #3 from Xisco FaulĂ­  ---
Thank you for reporting the bug. Please attach a sample document, as this makes
it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive
information before attaching it. 
See
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
for help on how to do so.)

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


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

2018-03-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116129

Gerhard Weydt  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #2 from Gerhard Weydt  ---
I can confirm it for LibO 6.0.0.2 32-Bit, Windows 10

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


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

2018-03-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116129

--- Comment #1 from Hans-Werner  ---
Confirmed for:
+ LibO 5.3.7.2 (x64) @ Windows 7 Home Premium 64-bit
+ LibO 6.0.2.1 (x64) @ Windows 7 Home Premium 64-bit
Greetings Hans-Werner

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