I have two issues with an embed excel file. 1) Th column width changes on display (in an inconsistent manner). Since I have jpg images in several cells this causes a significant issue. I can still see the original format when the sheet is opened for editing in excel. I have used the columnWidth tag in an attempt to force the formating.
{viewxls:name=EquipmentScheduling.xlsx | formatColumn = true | heading = 2}
2) Cells that have time values do not display correctly. For example, 7:00PM displays as 00.54166666671:00 PM
I bring in some Excel data for tables, but, I bring it in as a CSV, and attach it. The Confluence document refers to the attached CSV and makes a table out of it, and that is surrounded by a chart macro.
This:
{chart:type=timeSeries|timePeriod=minute|dateFormat=mm|dataOrientation=vertical} {csv:script=^501.csv} {chart}
Looks like this:
...from data that looks like this:
Minute,UserCPU,MemUse%,BsIN,BsOUT
54,2,87.00,0,41
55,3,87.00,0,19
56,2,87.00,0,21
57,3,87.00,0,22
58,3,87.00,0,26
59,3,87.00,0,14
00,8,87.00,0,28
01,2,87.00,0,27
I previously tried an older XLS format, but it only looked worse (the jpg's at least). I'll give removing the spaces in the macro a shot, and update here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I tried removing the spaces from the macro, but it made no difference.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try removing the spaces in your macro, make it like this:
{viewxls:name=EquipmentScheduling.xlsx|formatColumn=true|heading=2}
Barring that, try exporting into an older XLS format and importing that. Just an idea. (If I had a buck for every XML parsing error I've dealt with....hmm)
G.
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.