I have a sign in LibreOffice Calc.
If the value of the cell coincides with the value of the cell above it, then this cell remains empty.
Now I suddenly needed to sort this sign. Sorting does not understand what is meant by an empty cell and it turns out nonsense.

Is there some way to spread the contents of a cell to empty cells below it (until the next non-empty cell)?

    1 answer 1

    This makes the Tools For Calc Edit extension.

    • Are you, by any chance, the author or developer of this extension? - Nick Volynkin ♦
    • @Nick Volynkin, No chance :) I spent a few days searching for a solution, found a macro, but could not get it to work, and already thought of writing a solution myself. I was happy when I found this extension. Therefore, I decided to share with the people, maybe someone else will come in handy. - user244413
    • @Nick Volynkin, Is there any restrictions or a special format for questions about your programs? - user244413
    • Yes, in this case, it would be necessary to clearly indicate that you are the author and offer exactly your product. ) - Nick Volynkin ♦