Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can't split a word document on the headers that was created from an Excel spreadsheet

I have previously created multiple Confluence pages at the same time by importing an MSWord document that has standard Header 1s.  Confluence splits the document into pages by those headers.

This time I created an MSWord document by copying an Excel speadsheet and pasting the rows AS TEXT into the document.  Then I styled the words at the front of each row as a standard Header 1.  But when I import the document into Confluence, I get the "This document can't be split because it doesn't contain Headers" message.

I'm using a standard Header style.  I don't see any strange characters.  I've tried putting the header text on its own line.  Why can't Confluence see these Headings and allow me to split?

Thanks.

 

1 answer

1 accepted

0 votes
Answer accepted

Hi Nancy,

That's very strange, thank you for bringing this to us.

Could you tell me which version of Confluence you're using, and what your Microsoft Office version is? I'd like to test this out.

Regards,

Shannon

This is Confluence 6.15.2 on a server.

MS Office 365 ProPlus.

It's very odd.  

Hello Nancy,

Thank you for your patience. I've been working on replicating this in my environment, using Office 365 with Confluence 6.15.2. 

I copied a row in Excel (single column, single row), and pasted it and formatted it to the Heading 1 style. I can confirm that when I import this Word document into Confluence, the headings are split properly.

Would you be able to create a test document in Word using the same method and replicate the sane behavior? How does the heading row appear in the Document? Is this a full row with many columns? 

Looking forward to hearing from you.

Regards,

Shannon

Sure.  When you pasted, did you just use Ctrl-V?  Or did you Paste as Text?  Or something else?

Hi Nancy,

I am on a Mac, so I used ⌘V to paste the content of the column. 

If you're using the entire table, I am not sure this would work as well but I'd like to see exactly how the page looked in Word before you imported it. I don't want you to send your original if it's private information for your company, so if you can make a test document that does the same, it can also help.

Regards,

Shannon

So apparently the problem has something to do with pasting the Excel data as text into the page.  When I simply paste the Excel spreadsheet into the Word document, then make the first column all Headers 1, Confluence split each row into a page and put any additional information in the row as a table on the page.  Wonderful.  I was just over complicating it.  Thank you.

Like Shannon Spaniol likes this

Hi Nancy,

No worries, thank you for letting me know you were able to sort it out!

Take care, and have a pleasant rest of your week. :) 

Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

408 views 23 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you