python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How do I directly increment a cell value by 1 as part of a, LibraCalc, macro function
I am making a spreadsheet to tally votes for a car show. I used basic years ago but it is not the same as writing a macro so I have been Using the macro record function in LibraCalc (this is included...
Rag Top Bob
Votes: 0
Answers: 0
In Libreoffice Calc, which formula will check if a a keyword or part of it is contained in a cell in a row and copy the entire content of that cell?
I am learning how to use formulas in spreadsheets, I do use libre office.
I need to sort out data in a quite huge messy spreadsheet.
Each column contains mixed data, the sheet is huge, dozens of colum...
Novice2022
Votes: 0
Answers: 0
LibreOffice Calc: How to use a variable in a function/formula?
Before
After
I'm trying to dynamically fill a range of cells in a column based on a number in another cell.
So, fill x amount of cells with a value set in, say, E4. x is the value in cell E5.
If cell...
Rylan
Votes: 0
Answers: 1
Select all words with substring
In a column there are some words with the same substring. In this case it is "book".
I need to extract all the words with this substring. How can it be done without programming?
In other wor...
Kifsif
Votes: 0
Answers: 1