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.

Colors.png

3 answers

This widget could not be displayed.

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.

This widget could not be displayed.

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.

This widget could not be displayed.

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
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

468 views 6 6
Join discussion

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