Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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
2  
You might be better off asking this on ask.libreoffice.org... 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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.