search

taviso / 123elf

A native port of Lotus 1-2-3 to Linux.
1.18k stars 59 forks source link

Wiki: How to enter a formula that starts with a cell reference? #116

Closed jhartzell42 closed 1 year ago

jhartzell42 commented 1 year ago

If I want to have C1 be A1+B1, and I just type A1+B1, it assumes I want a label. I think there is probably some way to make it know I want to write a value instead, but this is not mentioned in the wiki intro. How do you do this, and can this be added to the Value section of the wiki?

Thanks in advance, and excited to learn how to use this spreadsheet program!

taviso commented 1 year ago

Thanks - good idea, I'll add that!

You usually do +A1+B1, but parens, numbers @ (functions) all also work!

taviso commented 1 year ago

Done!

https://github.com/taviso/123elf/wiki/Getting-Started#values-and-formulas

A formula can also start with a logical operators # and decimals, but I don't want to overwhelm people with information in the Getting Started page 😄