Ask Your Question

LibreOffice spreadsheet autoformat

asked 2019-02-26 15:55:42 +0200

tga5843 gravatar image

how does libreoffice spreadsheet autofill work for months? I can only get it to autofill days, not months example: I want 02/18 03/18

it gives me 02/01/18 02/02/18

I have input the formula I want in format cells. It's like it doesn't understand it. Thanks in advance 8)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-26 16:25:17 +0200

pierre-yves samyn gravatar image


  • Select the range (including source cell and target cells)
  • Use SheetFill CellsSeriesTime unitMonth


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-26 15:55:42 +0200

Seen: 52 times

Last updated: Feb 26 '19