Hi,
I have s spreadsheet where I populate the first cells in a row with a copy/paste.
Then I have some more cells with formulas that use that data, but I have to pull them down by hand for each new row. (see video below for example)
Is there any way to automate this process, so that I only have to copy paste the data, and the rest or the row automatically pulls the formulas from the above cell?
InsertCalcRows_LO.odt (23.3 KB)
Download the text document to a trusted directory according to Tools>Options>Security>Macro Security.
The document consists of Python code, a frame with instructions and install button and a Basic macro as installation routine.
Open the document and push the button to install the Python macro. The user interface is up to you. I recomment keyboard shortcuts Ctrl+Insert and Ctrl+Delete to insert and delete records.
[Calc, Python] Expand/shrink list ranges is the “home page” of this popular OpenOffice macro. I removed the handling of merged cells from LibreOffice version because it interfered with a similar feature that had been added to LibreOffice.
Thanks! that sounds interesting, i’ll have a look at it.
I didn’t watch the video, but created a simplified solution based on my understanding of the question. See attached proof of concept.
copyFormulasIfDataComplete.ods (18.0 KB)
Thank you, I had a look at the macro, I think this will help me write my own custom macro to solve this.