How to create indented decimal-numbered columns?

Discuss the spreadsheet application

How to create indented decimal-numbered columns?

Postby erichepperle » Fri Feb 15, 2019 10:56 pm


First-time poster. Been using OpenOffice Writer and Calc for about 2 years and I love it.

I'm trying to create a document from scratch to look like this:


The reference document is an Excel spreadsheet, but this is what it looks like in OpenOffice Calc. Notice these features of the "Page ID" column:

The numbering is decimal style, like in project management or SEO website content audit documents (1, 1.1, 1.1.1 ... etc.) But, also the numbers are left-indented, as with tab stops. In case the image is unavailable at some point, here is a text version (Note: the indentation is not preserved in the text version):

Page ID Category/section
1 About us
1.1 About us
1.2 About us
1.3 About us
1.4 About us
1.5 About us
2 Consultations
2.1 Broadband technology
2.2 Broadband policy
2.3 ISP licensing
3 Programs
4 Publications
4.1 Annual Reports
4.1.1 Annual Reports Annual Reports Annual Reports Annual Reports
4.1.2 Annual Reports
4.1.3 Annual Reports
4.2 Research papers
4.3 Brochures and fact sheets

How can I reproduce the sequential decimal numbering and the indentation without using multiple columns?

Eric L. Hepperle
OpenOffice version 4.1.5
Windows 10 64-Bit
Posts: 3
Joined: Fri Feb 15, 2019 10:37 pm

Re: How to create indented decimal-numbered columns?

Postby RusselB » Sat Feb 16, 2019 3:52 am

As your Page ID column is actually text, rather than numbers, you can just manually space the entries in that single column.
If you don't want to have to manually enter the spacing, then the only option I'm aware of is to use multiple columns.
Based on the information in the picture, it looks like you would need no more than 4 columns. If you don't want the extra columns due to how it would look, then going through and merging the columns might be an idea.
Alternatively don't use the automatic lines for the printed output, but use the options in the Borders tab Format -> Cells.
OpenOffice 4.1.7 and LibreOffice on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Posts: 5971
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests