CSV and Excel content display issue using CSV Macro

The CSV macro needs to be fixed so that when the CSV file is associated to it it doesnot load in one horizontal line and if a excel file is associated with it, the mashup of text to junk display doesnot happen.

Issue with the CSV plugin implementation:-
1. Insert an attachment to a confluence page :




2. Select the CSV macro


3. Refer the attachment from the page (other options are also there)






4. Preview or save the page and have a check. The output is attached


5. If we repeat the same with CSV as we did with XLSX file above, we would get the entire mashed up content in a single line.

Please let me know if you have any questions.

3 answers

1 accepted

Hi Bob,

Thanks for your response. I have opened an issue : TBL-352.

As per my analysis, the problem might be with the negative currency field which is causing the issue. I have attached the faulty CSV file and it seems that the issue is happening with all the CSV files having negative currency field.

Regards,

Arya

Please open an issue and attach the specific files that are causing you problems. Note that in order to use the CSV Macro with Excel data, you need to export from Excel as CSV.

Hi Bob,

I would be opening an issue in the link provided by you. Before that, I just want to confirm one thing: Can Xlsx files be uploaded via CSV macro without changing the format to csv? Or is it mandatory to convert the excel files to csv first and then use the CSV macro for including the same in the team pages?

It is required to convert to csv. The csv macro ONLY does csv. If you want to view Excel files without conversion, then you need Excel for Confluence and the Excel Macro. However, for xlsx support you will need to wait for XL-58. An alternative is the Office Connector macro for excel.

Thanks a lot Bob. This answers my question. When would we be able to show xlsx data using Excel Macro? Do we need to follow XL-58?

Yes, just follow the issue.

Hi Bob,

Thanks for your response. Okay, I have been able to replicate the issue with the CSV inclusion within a Confluence page. We have purchased a 500-user commercial license, Enterprise, expires Jun 17, 2015 for our Confluence instance. But it seems that the CSV macro is displaying all the CSV files in an all - horizontal manner.

Do you want me to open an issue on this?

I tested and found that the CSV file is having no issues and is behaving normally in other Confluence instances. Please help us with this and let me know if you need any further information.

Regards,
Arya

Hi Bob,

If you want me to open an issue on this, I would be attaching the csv file also which is causing the problem.

Please confirm.

Regards,

Arya

Yes, open an issue if it appears not to be working as expected. Make sure it is a valid CSV file.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Confluence

Three common content challenges + how to manage them

An efficient enterprise content management system, or ECM, is a must-have for companies that create work online (cough   cough, all companies). If content calendars, marketing plans, and bu...

73 views 0 4
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