Bug: Entering formula in cell on spreadsheet replaces all other formulas

Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Russell Adams]

When using the =formula syntax in the spreadsheet and tabbing to the
next cell instead of using C-u C-c =, the entire TBLFM line is
overwritten.

Thanks!

Re: Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Carsten Dominik]

On Apr 2, 2010, at 12:17 AM, Russell Adams wrote:

> When using the =formula syntax in the spreadsheet and tabbing to the
> next cell instead of using C-u C-c =, the entire TBLFM line is
> overwritten.

Hi Russel,

I do not understand what the problem is here.  Can you make a more  
detailed description with a test file?

Thanks.

- Carsten

Re: Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Russell Adams]

On Fri, Apr 02, 2010 at 09:45:55AM +0200, Carsten Dominik wrote:
>
> On Apr 2, 2010, at 12:17 AM, Russell Adams wrote:
>
>> When using the =formula syntax in the spreadsheet and tabbing to the
>> next cell instead of using C-u C-c =, the entire TBLFM line is
>> overwritten.
>
> Hi Russel,
>
> I do not understand what the problem is here.  Can you make a more  
> detailed description with a test file?
>
> Thanks.
>
> - Carsten

When entering data, you can type "=" and enter a formula in the cell
which apparently becomes the column formula when you hit tab. It is
written to the TBLFM line under the table.

Unfortunately it replaces the TBLFM line instead of appending to it,
wiping out current formulas.

I'm on 6.34c.

Thanks.



------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Carsten Dominik]

On Apr 2, 2010, at 10:19 AM, Russell Adams wrote:

> On Fri, Apr 02, 2010 at 09:45:55AM +0200, Carsten Dominik wrote:
>>
>> On Apr 2, 2010, at 12:17 AM, Russell Adams wrote:
>>
>>> When using the =formula syntax in the spreadsheet and tabbing to the
>>> next cell instead of using C-u C-c =, the entire TBLFM line is
>>> overwritten.
>>
>> Hi Russel,
>>
>> I do not understand what the problem is here.  Can you make a more
>> detailed description with a test file?
>>
>> Thanks.
>>
>> - Carsten
>
> When entering data, you can type "=" and enter a formula in the cell
> which apparently becomes the column formula when you hit tab. It is
> written to the TBLFM line under the table.
>
> Unfortunately it replaces the TBLFM line instead of appending to it,
> wiping out current formulas.

Well, not for me, so there must be something funny in your formulas/ 
table.  Please make me an example.

- Carsten

Re: Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Russell Adams]

> Well, not for me, so there must be something funny in your formulas/ 
> table.  Please make me an example.
>
> - Carsten
>

I just figured it out. I ran into it while composing the spreadsheet
for the narrowing FR.

Its that using = in a cell create a column formula, and I kept
replacing the same column. That wasn't what I was expecting. ;]

Thanks.

------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Carsten Dominik]

On Apr 2, 2010, at 4:37 PM, Russell Adams wrote:

>> Well, not for me, so there must be something funny in your formulas/
>> table.  Please make me an example.
>>
>> - Carsten
>>
>
> I just figured it out. I ran into it while composing the spreadsheet
> for the narrowing FR.
>
> Its that using = in a cell create a column formula, and I kept
> replacing the same column. That wasn't what I was expecting. ;]

You know about ":=" ?

- Carsten

>
> Thanks.
>
> ------------------------------------------------------------------
> Russell Adams                            RLAdams@AdamsInfoServ.com
>
> PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/
>
> Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten

Re: Bug: Entering formula in cell on spreadsheet replaces all other formulas

[Russell Adams]

Carsten,

I do now! ;]

Thanks.

> You know about ":=" ?
>
> - Carsten


------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3