Created attachment 63548 [details] bugdoc saved with LO 3.6 Version : 3.6.0.0.beta2+ (Build ID: 2992b53) Ubuntu 11.10 x86_64 with gnome-shell The attached bugdoc is a spreadsheet designed with LO 3.5 and modified with LO 3.6. this spreadsheet contains conditional formatting of both types "Value is" and "Formula is". The last type is used to set the backgroung of each line, alternating between blank and yellow background. steps to reproduce: - open the bugdoc with LO 3.5 : works fine. Close the file without saving. - open the bugdoc with LO 3.6 : alternating background are lost - select cell C6 and open Conditional Formatting dialog : condition is of type "Formula is" but the formula shown is "0" instead of "MOD(LIGNE();2)=0" - in the dialog the string "Apply style" is not there unlike condition "Value is" - more generally : * dialog window is too small * dropdown list for style names is too small * it seems that exemple box is not functionnal when reopening the file Best regards. JBF
Hi Markus, It seems that is in your area :-) Do you need a screencopy ? Best regards. JBF
[Reproducible] with Server Installation of "LibreOffice 3.6.0.0.beta2 German UI/Locale [Build-ID: f010139] on German WIN7 Home Premium (64bit) I am a little worried about subjece line "saved", IMHO the main problem is "Fileopen ... not recognize condition formatting forumla". The lost CF after save is a result of that root problem. We have a new conditional formatting dialog, but the main problem seems to be that the formula for the condition will not be recognized by 3.6.0. Saving document under new name and reopening with 3.5.5 shows "0" instead of a formula as stated. Still a problem with parallel installation of Master "LOdev " 3.7.0.0.alpha0+ - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 3985521]" (tinderbox: W2008R2@16-minimal_build, pull time 2012-06-24) was still ok with beta1 @Jean-Baptiste Please feel free to revert my subject line if you do not agree @Kohei / Markus: Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug
It is one for me.
Ok this one was just a simple copy&paste error.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e8451dba20390387289765b112568166a5f411fe the end of the formula is the closing bracket, fdo#51507
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=66018b9685dd7337daae9bb62ffeb43cd4161caf&g=libreoffice-3-6 the end of the formula is the closing bracket, fdo#51507 It will be available in LibreOffice 3.6.
Thank you Markus :-) Verified on Version 3.6.0.0.beta2+ (Build ID: 66018b9). Best regards. JBF
*** Bug 51614 has been marked as a duplicate of this bug. ***
*** Bug 57246 has been marked as a duplicate of this bug. ***