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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sure. When you pasted, did you just use Ctrl-V? Or did you Paste as Text? Or something else?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.