Embeded excel - column width changes, and time displayed incorrectly

Question

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

Daniel Leaird · Answer

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

Gregory Suddert · Answer

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 · Answer

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.