Ask Your Question

In Calc failing to delete 'Increment' value

asked 2020-01-14 14:26:58 +0100

jeffers20 gravatar image

I have a spreadsheet imported to Libre from MS Office and cannot speed up spreadsheet entry as each cell increases by '1' every time. I access sheet>Fill Cells>Series but the fig 109 on page 137 does not show. All I get is a box with directions i.e. left to right etc but the 'series' option is grey and not accessible. I therefor cannot delete the increment value. It has not happened before with this worksheet. Can you help please?

edit retag flag offensive close merge delete


fig 109 on page 137

Which reference are you talking about? Please provide a link to the document and some information about your operating system and LibreOffice version may be useful.

Opaque gravatar imageOpaque ( 2020-01-14 19:27:57 +0100 )edit

I am refering to the book Libre Office 5 Getting Started guide 5.2. Using version Operating Windows 10. Am using a one page spread sheet for 12 months as a monthly household account and wish to drag a cell across the sheet. Hope this clears my problem.

jeffers20 gravatar imagejeffers20 ( 2020-01-15 12:14:46 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-01-15 16:13:51 +0100

pierre-yves samyn gravatar image


The increment zone is greyed when the current cell contains some text, a value entered as text (with a ' visible at the beginning of the cell in the formula bar, or in a cell formatted as text).

Are you sure that's not the case?


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-14 14:26:58 +0100

Seen: 18 times

Last updated: yesterday