> Hi :)
> Is it possible to change the way Calc handles it's formulas by doing
>
> Tools - Options - Calc - Formula
>
> and then use the drop-down to make them use MS Excel ways. I can't
The problem with this setting is that there is no explanation of what
it really means / implies (othe
> On 10/12/2013 07:55 AM, Ady wrote:
> > Hello,
> >
> > I've been having problems with certain type of *references* in Calc.
> >
> > For example, the formula "sum(1:2)" works correctly in other
> > spreadsheet software, but it errors in Calc.
>
> I was not aware that you could do that in any prod
Hi :)
Is it possible to change the way Calc handles it's formulas by doing
Tools - Options - Calc - Formula
and then use the drop-down to make them use MS Excel ways. I can't help
thinking that trying to copy MS Excel at a time when they have finally
admitted, and corrected, some very funda
On 10/12/2013 07:55 AM, Ady wrote:
Hello,
I've been having problems with certain type of *references* in Calc.
For example, the formula "sum(1:2)" works correctly in other
spreadsheet software, but it errors in Calc.
I was not aware that you could do that in any product. It is not
supported
Hello,
I've been having problems with certain type of *references* in Calc.
For example, the formula "sum(1:2)" works correctly in other
spreadsheet software, but it errors in Calc.
The most problematic cases are related to functions such as
"indirect()", "address()" and the like. For example