Hi: Gnumeric is another free software spreadsheet that has conditional formatt. It usually comes in the GNU/Linux Distribution repositories. Sometimes it comes installed.
http://www.gnumeric.org/?ckattempt=1 WPS has installer to Ubuntu at least. http://wps-community.org/downloads Regards, Jorge Rodríguez El mar, 24-11-2015 a las 00:34 -0800, James E Lang escribió: > > -----Original Message----- > From: "m.a.riosv" <miguelange...@libreoffice.org> > To: users@global.libreoffice.org > Sent: Mon, 23 Nov 2015 21:21 > Subject: [libreoffice-users] Re: Calc 5.0.3.2 AutoCalculate > > Hi James, > > sorry but I think not a good news. > https://bugs.documentfoundation.org/show_bug.cgi?id=56896 > https://bugs.documentfoundation.org/show_bug.cgi?id=92664 > > [Thank you for those links. I'm not sure how much they apply to the problem > I'm encountering but they are certainly interesting. > > I'm not interested in migrating to Excel under any conceivable circumstance. > I don't even want to use WPS (the Chinese clone of Excel) though that might > be an answer in terms of performance. :( > > Does anyone know whether WPS can be run via Wine on Linux? I know it does not > play fair with LO on Windows. I don't think programs on Linux through Wine > can override system settings. As long as I could control the software update > process I think I might trust WPS if it were running on Linux. -- jl] > > Maybe the problem is in relation with your formulas in the conditional > format, using functions inside CF makes it very slow. I think specially with > the STYLE() function. > > [Thank you Miguel. > > I do not use _any_ functions in my very simplistic conditional formatting. I > have six custom styles defined that differ from the default style in terms > only of their background color. They apply to the range Sheet1.AH3:AJ2870. > They are activated by six conditions as follows > > Condition 1: Formula is $Sheet2.$AP3=1 > Condition 2: Formula is $Sheet2.$AP3=2 > ... > Condition 6: Formula is $Sheet2.$AP3=6 > > This color codes the background in columns AH through AJ on the first sheet > based on any of six specific values or none of them in column AP on the > second sheet. Unchecking AutoCalculate turns off this color coding but does > not streamline data entry which is taking place in columns AH through AJ on > the first sheet. IOW, unchecking AutoCalculate not only fails to accelerate > data entry but it also hides visual clues as to what data is supposed to be > entered. -- jl] > > Regards. > Miguel Ángel. > > -- > Jim > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
