QUESTION : I have duration data like 5:23, etc… in m:ss format. I already typed the data, but I cannot […]
Tag: libreoffice-calc
Excel / Libre Office Calc: Taking the average of a multiplication
QUESTION : I have three rows in Libre Office Weight: 0,2 0,2 0,3 0,3 Max. Points: 2 3 4 5 […]
Reference a cell with input from another cell
QUESTION : The final objective is to reference the last populated (higher row number) cell from a column (its value). […]
Find a Certain Cell based on other Cells in Excel/Calc
QUESTION : I have a spreadsheet: Beans B-kg Chips C-kg 1.4oz/12 0.47544 6.5oz/20 3.679 1.48oz/12 0.502608 7oz/12 2.3772 1.86oz/12 0.631656 […]
What is the Excel equivalent of Find & Replace catch-all “*” in libreoffice calc?
QUESTION : In LibreOffice Calc, I am trying to find and replace all characters after a blank space to delete, […]
how to convert spreadsheet cells to units of time?
QUESTION : This is the goal: +——+———————+———+———————+ | A | B | C | D | +——+———————+———+———————+ 1 | Joe […]
Conditonal sum in Excel
QUESTION : I would like to write the formula (in OpenOffice, but I imagine it won’t be any different than […]
How do I convert dates from Open Office format to MS Excel format
QUESTION : I am trying to save a file in Libre Office as an excel file but Excel sees the […]
Copy file to LibreOffice Calc [closed]
Problem : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Excel/Calc INDIRECT+ADDRESS+ROW+COLUMN cleaner alternative
QUESTION : I’m not a regular Excel/Calc user, but I’m currently using LibreOffice Calc to record some money ins and […]