LibreOffice is great at opening files that newer office software can no longer open, but very difficult to use.
—Help leads nowhere
—Spreadsheet columns cannot be expanded to create a header, nor is there a way to create a header
How do I access Help, or a tutorial?
What and where are the formulas for SUM and Multiply? I cannot get it to do anything? Nor do I have any luck with MSCalc so it must be %*$#@ Windows 10 pro…
Have you tried F1 for accessing Help ? You can find useful informations in the documentation page of libreoffice site.
As @ratrace said, try F1 to access Help. You can also type “how to use libreoffice” into your browser search box to see a plethora of articles ranging from “Getting Started with LibreOffice 4.0” (by The Document Foundation), to “Taming LibreOffice,” to “Instructions for Using LibreOffice Calc” (a wiki via LibreOffice.org).
From you comments, I’m not quite sure what you mean by “Spreadsheet columns cannot be expanded to create a header…” A spreadsheet document header can be accessed and customized from Format > Page by clicking the Header tab.
If you are referring to freezing rows to create a static column heading while the detail scrolls, select View > Freeze Rows and Columns. This will freeze rows to the left of your cursor and freeze columns above your cursor.
The “formulas for SUM and Multiply” are basically the same as in Excel. The equal sign (=) entered as the first character in a formula indicates a mathematical operation. “=SUM([From]:[To])” adds the cells for the range specified. Multiplying cells uses the asterisk (*) symbol to indicate a multiplication operation.
I hope this helps.
Please click the check mark next to the post you believe best answers your question.
To make the answer a little more clear, Adding and Multiply both use function “SUM”. Addition uses symbol “:” and Multiply uses “*”.
BTW, using “SUM” for both addition and multiplication is entirely wrong. Seems M$ messed up if that is how it works in Excel. SUM in math means “addition”.
RayN, I did not mean to imply that “SUM” would be used for multiplication. If my answer was unclear on this point, I apologize.
Insert function product.
Note: not multiply, but product.