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



On 11/24/2012 10:39 PM, Joel Madero wrote:
Hi All,
We need UX input on this bug:

https://bugs.freedesktop.org/show_bug.cgi?id=54975

Seems like we already have two different opinions. Basically we need to know if a cell should be considered a value if there is no cell reference in the formula, for instance:

=24/8

Personally I think it should, a lot of the times with "harder" calculations it's just easier to enter a formula but we are really just aiming at getting to the value. If we consider it a value and not a formula we would expect conditional formatting to work with them, that's the crutch of the bug report.

Regards,
Joel

It would be very wrong to suddenly consider the cell a constant.... which really means that CALC notices that it is "constant" and then converts it to a constant.

Now, assume that it is all internal and I write a little macro that probes each cell to see if it is a formula. If it is a formula, then convert it to a value. Well, if the cell reports that it is a constant, then my code would not touch it and it would stay the formula that it really is.

I think that what you really want is that for some particular thing that you want to do that refuses unless a cell contains a constant, allow that to work for a cell that appears to be a constant (based on some specific rules). Sounds handy.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


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.