Create indented decimal-numbered columns

Discuss the spreadsheet application
Locked
erichepperle
Posts: 5
Joined: Fri Feb 15, 2019 10:37 pm

Create indented decimal-numbered columns

Post by erichepperle »

Greetings,

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:

Image

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
4.1.1.1 Annual Reports
4.1.1.2 Annual Reports
4.1.1.3 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?

Thanks
Eric L. Hepperle
OpenOffice version 4.1.5
Windows 10 64-Bit
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: How to create indented decimal-numbered columns?

Post by RusselB »

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, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
Locked