Colors in Pasted Cells from Open Office

An engineer pasted a table from Open Office Excel sheet that had colors, the colors got reproduced correctly and he could save the page. However, after some time when he tried pasting another table with colors from the same sheet, it did not work.

My question: Editor does not support Copy/Paste of cells with colors from Excel sheet (Table gets created without cell colors), how come it worked this time?? Attached is the snapshot of the table.


3 answers

If you attach the excel file to the document, it will render the settings. Pasting the excel table as a new table in Confluence won't work as Confluence supports only simple wiki tables.


You can also accomplish this with raw HTML but that's a poor way of working with Confluence.

Rendering the excel is ok...however this was just a copy and paste from excel. I am also not sure how colours got populated exactly the same in confluence.

Steven Behnke Community Champion Dec 06, 2015

I don't understand how that's possible. Show me it in edit mode. Do you have the page source editor installed?

That's Strange. No, we do not have page source editor installed. Attached is the snapshot of the edit mode.

image2015-12-7 9:33:44.png

@Steven Behnke...Have a look at the snapshot here.

I'll play around with Excel later. What that means is valid format was pasted into the confluence editor. Since the editor is based on Web standards, valid styles and structure just render in a browser. Confluence doesn't stop it, it doesn't strip out formatting unless it's specifically looking for it (via Javascript and also during the save page operation) I'm not sure what version of Excel apparently works but something produced acceptable xml formatting and it looks like that. ;)

Shouldn't Atlassian look into it if this is happening? @Support Dashboard This is for you.

Steven Behnke Community Champion Dec 07, 2015

There is no "bug" here, possibly some behavior improvements. It's strange but really to be expected. I'm just wondering what improvement could be made. Still not sure what version of excel does this. Any chance you could upload a sanitized version of the xls file or specify the versions/os of your excel clients? I'm morbidly curious which spreadsheet editor uses compatible formatting.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Tuesday in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

206 views 2 10
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you