Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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" <miguelangelrv@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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.