https://bugs.freedesktop.org/show_bug.cgi?id=54975
--- Comment #5 from Andrew Pitonyak <[email protected]> --- I just wanted to add a few thoughts in case anyone chooses to take this seriously and pursue it. I will start with the following: Calc "incorrectly highlights fixed mathematical calculations as formulas". I would prefer if you stated that you desired Calc to have some ability to figure out that certain types of formulas may be able to be treated as constants for some particular purpose. The trick, of course, is that it is a formula, and even if another cell is not directly referenced, some of the side effects may cause the value to not be static. When ever a function or operator is used, it is difficult to know that the operator will not do something that is not directly obvious, so if this is pursued, I expect that it would read more like.... A formula containing only constant values and only uses operators from some specific set and can only call / use functions from a specific set. Where can this go wrong? consider what happens if an operator or function returns a different value based on a date or time. In my world, it is not uncommon to write your own function that may directly accesses other stuff in a way that is not obvious by looking at the parameters. For example, a function that knows that it should look at a specified set of cells that control what is returned. This is legal, it just cannot modify any cell on the sheet that called the function. That said, limiting cells to only contain arithmetic operators with constant operands would likely suffice, but I expect that the change will require a change to published interfaces and services ( because you absolutely do NOT want a cell to state that it is a constant value when it is really a formula, because then every other piece that wants to treat it in a certain way because it is formula will fail ) when I need to deal with that, I usually simply do a copy and then "paste special" and I paste in the values of interest. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
