Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Im new toLibreoffice and I'm looking for something similar to a EXCEL TABLE, which allows you to autofill formulas in a column without having to do it yourself.

Any answer is appreciatted. Tx.

share|improve this question
You might be better off asking this on once it's online :/ – MiJyn Jan 8 '13 at 1:32
OP should still be able to ask here. – user25656 Jan 8 '13 at 2:49

LibreOffice Calc has a facility called Autofill.

Let's say you have a column with the header cell, A1, called Column A. Cell A2 has a001, cell A3 has a002, cell A4 has a003.

Select cells A2 downwards for as much as you need. Then Click on Edit, Fill, Series, to open a window which has the Autofill option.

Note that the filled cells you include in the selected area must have a pattern that Calc can recognize as some sort of pattern to autofill.

share|improve this answer

Tools For Calc Edit extension propagate cell content down until it meet non-empty cell.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.