Re: [libreoffice-users] Re: Calc 5.0.3.2 AutoCalculate

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