On 2015-11-25 05:41, jorge wrote:
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
Some RPMs and tar also.
Regards,
Jorge Rodríguez
El mar, 24-11-2015 a las 00:34 -0800, James E Lang escribió:
-----Original Message-----
From: "m.a.riosv" <[email protected]>
To: [email protected]
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
--
To unsubscribe e-mail to: [email protected]
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
