To reproduce: 1 - Add background color to cell A1 and A3 2 - Select cells A1:A3 3 - Format > Cells > Background tab, Click 'No Fill', Click 'OK'. Cell background colors are not removed. This works in 5.1.x versions.
I can't reproduce. Win10x64 Version: 5.2.1.1 (x64) Build ID: 2d75cf29e6d05e44c404f0547047f1da6563d380 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES); Calc: CL Please try resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/UserProfile Usually it's enough renaming/deleting the file "user/registrymodifications.xcu", it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.
LO & OS info: Version: 5.2.1.1 (x64) Build ID: 2d75cf29e6d05e44c404f0547047f1da6563d380 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: en-US (en_US); Calc: single Also failed on an Ubuntu Linux OS with LO from the LibreOffice-5-2 PPA. In my steps to reproduce cell A2 should have no background color or a different background color versus A1 & A3 so that the colored cells are non-continuous with respect to color/fill attribute. 'No Fill' as a block (A1:A3) from 'Format > Cells' window fails. BUT 'No Fill' succeeds if the toolbar 'Background Color' control is used.
Confirmed on Ubuntu 16.04 LTS 64-bit. LibreOffice 5.2.0.4
(In reply to brucehohl from comment #2) > LO & OS info: > Version: 5.2.1.1 (x64) > Build ID: 2d75cf29e6d05e44c404f0547047f1da6563d380 > CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; > Locale: en-US (en_US); Calc: single > > Also failed on an Ubuntu Linux OS with LO from the LibreOffice-5-2 PPA. > > In my steps to reproduce cell A2 should have no background color or a > different background color versus A1 & A3 so that the colored cells are > non-continuous with respect to color/fill attribute. > > 'No Fill' as a block (A1:A3) from 'Format > Cells' window fails. > BUT 'No Fill' succeeds if the toolbar 'Background Color' control is used. Windows 10 (version 1607) LibreOffice 5.2.0.4 (x64) I can confirm: 'No Fill' as a block (A1:A3) from 'Format > Cells' window fails. BUT 'No Fill' succeeds if the toolbar 'Background Color' control is used.
Confirmed under Windows 10 x64 using v5.2.1.1 This is a Regression in branch 5.2 It also occurs under Linux so I changed the Platform to All.
I can see now, if some cell in the block has a different background 'Format/Cell/Background - no fill' fails.
Issue introduced in range f2070db3f2ad7e0c4b7d7233b5999bcf869226b5..37d735b27477cc1b72063b0ef307a437fa5233a1
Hi Oliver, it looks like your commit e5246a6b679cfd15ba9ec6db23448066f34c7c08 introduced this regression. Could you please take a look at it whenever you have some time? Regards
Adding Cc: to Oliver Specht
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=429be969b39867d6d9f36978c9ac15b601e78ba6 Resolves: tdf#101588, do not prevent color de-selection tdf#96382 follow-up It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/31923 for 5-2 build https://gerrit.libreoffice.org/31922 for 5-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=638f40d16c9e0b01e3cb0f53d9d5703a361b2100&h=libreoffice-5-3 Resolves: tdf#101588, do not prevent color de-selection tdf#96382 follow-up It will be available in 5.3.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=96068bd2c9dc17d9af7550ba5a02673c5c7eabad&h=libreoffice-5-2 Resolves: tdf#101588, do not prevent color de-selection tdf#96382 follow-up It will be available in 5.2.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aee66aa85e75f67135e5c6079a281e18402d261a Resolves: tdf#105740 select without selecting.. tdf#101588 b0rk It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=21cf4bb57665af0c7e2dad01729e8e18480c1b90&h=libreoffice-5-4 Resolves: tdf#105740 select without selecting.. tdf#101588 b0rk It will be available in 5.4.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1096d1c237a2c4fc7497dd073d0f62bb01ffe925&h=libreoffice-5-3 Resolves: tdf#105740 select without selecting.. tdf#101588 b0rk It will be available in 5.3.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.