Re: [libreoffice-users] [CALC] row_only and column_only cell references

2013-10-14 Thread Ady
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

Re: [libreoffice-users] [CALC] row_only and column_only cell references

2013-10-14 Thread Ady
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 (other

Re: [libreoffice-users] [CALC] row_only and column_only cell references

2013-10-13 Thread Tom Davies
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

[libreoffice-users] [CALC] row_only and column_only cell references

2013-10-12 Thread Ady
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, the

Re: [libreoffice-users] [CALC] row_only and column_only cell references

2013-10-12 Thread Andrew Douglas Pitonyak
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