Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Resolved Question

Enable cell formulae in Libre Calc ?

Aug 24, 2014 9:36PM PDT

Hi;
This will probably seem pretty lame, but I installed Libre Office this weekend and like it, but can't seem to get any Calc cell to accept a formula(as in MS Excel). I've been an MS Office user for nearly 20 years.
Excel lets me simply enter any formula in a cell, such as :
=a17+c57-b12, and the cell shows the formula result.
In Libre Calc, just a fault letter and number comes up and the end of my formula.
I cant even get a cell to replicate elsewhere with a simple
=a1 type of formula.
Is there some setting in Calc I'm missing ?

Discussion is locked

robmik1943 has chosen the best answer to their question. View answer

Best Answer

- Collapse -
Technically
Aug 24, 2014 11:11PM PDT

Technically that's not a formula, it's an expression. An incomplete one unless you assume that whatever cell you're inputting it into is the implicit other side of the = sign.

Excel is just setting up a shortcut to the =SUM() formula from the looks of it. So worst case scenario just do =sum(a17+c57-b12) If you remember back to like 5th or 6th grade math, you'll remember that subtraction is really just adding a negative value, which is why there's no =subtract() or =difference() formula.

I also assume you're aware that spreadsheets follow operational order of precedence. So multiply and divide before add, unless it's within parentheses, etc. If you're going to be stringing together formulas operating on more than 2-3 values, it's wise to keep that in mind so you don't get the wrong results. Computers are completely literal and will do only what we tell them to do and it's not possible for developers of programs to divine the intentions of every single possible formula someone might enter into a spreadsheet. You should also keep in mind that if precision is important, Excel is well known to take a number of shortcuts that are less precise. For most people it's a non-issue, but statisticians, bankers, even scientists, may need a level of precision Excel isn't able to give them. If you fall into one of those categories, you may want to be rethinking using a spreadsheet period. Not sure if LibreOffice Calc takes the same shortcuts, but it's probably best to assume it does, same with QuattroPro and any others I'm forgetting.

- Collapse -
I looked at a spreadsheet i created in Excel
Aug 24, 2014 11:35PM PDT

and I sent it to my Google Drive and converted the file to Google Sheets. The column I used a formula was to get a projected next due date for my credit cards So the formula was =sum(A1+30) with A1 being a date. The value and formula converted to the same thin in Google Sheets.

- Collapse -
reply
Aug 25, 2014 12:18AM PDT

Sorry, that's not what I seek. I wish to find the setting in Libre Calc or OfficeOrg calc that will let me enter the same information into a cell I've used in Excel for many years.

- Collapse -
reply
Aug 25, 2014 12:14AM PDT

Thanks, but this doesn't work. Excel accepts and processes the values I enter into a cell.
Libre Calc and Office org Calc do not. No matter how I "phrase" them.

- Collapse -
Thanks everyone, but I figured it out
Aug 25, 2014 3:27AM PDT

Thanks to everyone, but I have come up with the answer. When entering a formula in Excel, one
enters it right in the cell you want to use. In Libre or Open Office, you go to the cell you want, then
click on the fx symbol, right beside the sigma symbol. A screen open up and you enter your formula
in that screen, then hit OK...no need for any parentheses or any additional + signs, just basic.
Works fine. Cheers.

- Collapse -
Answer
I went and tried a formula like yours in excel
Aug 24, 2014 10:52PM PDT

A1 = 12
B2 = 23
C3= 34

I typed in C5 +A1+B2-C3 Excel changed the formula to =+A1+B2-C3

So it looks like you need a =+A1 instead of =A1 (The plus sign is missing)

- Collapse -
I just tried something similar
Aug 24, 2014 11:13PM PDT

I just tried something similar with Excel 2013 and it didn't modify the formula at all, but it just assumed I was doing a =sum() formula. I took the same expression, stuck it inside a =sum() formula and got exactly the same result. So it's just a shorthand Excel allows, which will degrade readability later when you're trying to debug some complex chain of formulas and isn't really a good idea to use in practice.

- Collapse -
reply
Aug 25, 2014 12:16AM PDT

Thanks, but what works fine for me in Excel does not work
for me at all in Libre Calc or in Office Org calc.

- Collapse -
reply to your post
Aug 25, 2014 12:11AM PDT

Sorry, that doesn't work.
I also tried such a formula in Excel and it doesn't add the plus sign, it just accepts
the basic type of formula ie: =AI+B22 for instance...and works fine.
Neither Libre nor Office Org will accept the formula.

- Collapse -
Answer
What happens if ...
Aug 24, 2014 10:57PM PDT

you import an Excel spreadsheet with such a very simple formula?
How does it show in Calc? Can you edit it?

Kees

- Collapse -
reply
Aug 25, 2014 12:12AM PDT

If I import an Excel document to Libre or Office Org,
it comes across without any formulae, and cannot be edited at all.