Created attachment 71552 [details] Spreadsheet with cell style Date already defined Hello Steps to reproduce: 1. Open the attached spreadsheet (CF_Date.ods) 2. Type the current date in A1, next day in B1 (so, if current date is 15/12/12, type 15/12/12 in A1, 16/12/12 in B1) 3. Select A1:B1, Format> Conditional formatting> Condition> Date is> Today, Style : Date Expected result: the content of A1 is the same and applies cell style Date, B1 no change, no conditional format Actual result: A1's content transformed in number (formula bar) and applies cell style Date, B1 loses its format and is displayed as a number So conditional formatting causes the equivalent of a "clear direct formatting". Note: the exemple is given with "Date is" but same problem with others, for example: 1. type "AA" in A3 2. align right (ctrl+r) 3. Format> FC> Condition> Cell value is> equal to> "bb", style : Heading A3 loses the right alignment Reproduced (fr-discuss) Regards Pierre-Yves Operating System: All
Created attachment 71605 [details] Screencast I confirm with LibO 4.0.0.0.beta1 (Build ID: 7906242e87d3ddb2ba9827818f2d1416d80cc7) on Ubuntu 12.04.1 x86_64
Confirmed (fr-discuss) for : - Windows 7 family premium - Win7pro 64bits - Ubuntu 12.04.1 x86_64
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=315b9b4a5c53eed5fd283bc329e05d7d8fbc9ebc&g=libreoffice-4-0 we need to use a copy of the original ScPatternAttr, fdo#58338 It will be available in LibreOffice 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8a028afd55decfd269268d0d1e6adcfbdc9d85d0 we need to use a copy of the original ScPatternAttr, fdo#58338 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.
Hello WORKSFORME with daily : Version 4.0.0.0.beta1+ (Build ID: 315b9b4a5c53eed5fd283bc329e05d7d8fbc9eb) Thank you Regards Pierre-Yves
*** Bug 56989 has been marked as a duplicate of this bug. ***