Embeded excel - column width changes, and time displayed incorrectly

[Daniel Leaird]

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

[Gregory Sudderth]

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

[Daniel Leaird]

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.

[Daniel Leaird]

I tried removing the spaces from the macro, but it made no difference.

[Gregory Sudderth]

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.