Hi Cynthia, I'vwe modified my code to demonstrate my issue more clearly. I have no expectation of summarised values "moving up" to the wrong week, but do expect the rows for a paticular week to start on the same row. As you see in the table below, Tuesdays records always begin on the last record for Monday.        DAY           Monday      Tuesday      THEATRE      WEEK      SESSION      REVENUE      SESSION      REVENUE    TH7   3   SESSION1   4000     .       SESSION2   4000     .       SESSION7   4000   SESSION3   2000         .   SESSION4   2000   I would have expected SESSION3 on Tuesday to the on the same row as SESSION1 on Monday as shown below.        DAY           Monday      Tuesday      THEATRE      WEEK      SESSION      REVENUE      SESSION      REVENUE    TH7   3   SESSION1   4000   SESSION3   2000       SESSION2   4000   SESSION4   2000       SESSION7   4000       Is there any way to achieve my desired output? thanks John ... View more

Hi All, To update you (in case you were wondering :-)), you can get past this by using using the escapechar to reformat the title text. You may need to tweak the style to match your template again, but the superscript is effively changing the style of the title. ^S={font_weight=bold} e.g - title "^S={font_weight=bold}Title with superscript^{super 1} - normal format. Why?"; However, the superscript has another negative affect, as it makes the row height for the title way too large (with versions of ExcelXP 1.116 and above). I had to use the ROW_HEIGHTS option to speicify the title height to stop the unexpected behaviour caused by the superscript. The ROW_HEIGHTS options had a further negative affect, because the height of the title for subseqeunt reports wasn't high enough (it diables auto fit), so I had to repeat this statement and tweak the heights before and after any time a superscript was used. So it's workaround city, but hopefully later versions of the tagset will sort this. John ... View more

Just quick bump... I've raised this with support, as I guess it's a bug. However, maybe's come across it and knows a workaournd? thanks John ... View more

Wow, thanks a million for your comprehensive response Cynthia. I had been going down the wrong route, and was using attempting to use the "rules=" option without success and with much frustration. (9.2 btw). It seems ods to tagsets.excelxp does indeed behave differently to say rtf, and with trial and error, and a large degree of patience, it is possible to get close to ye-olde journal style. Many thanks again John ... View more

Hi Cynthia, Thanks for the response. Actually, I had already downloaded Eric's example code that produce the screenshots he used in the paper you've linked to. I spent a lot of time playing around with the various options, but am unable to produce the results I want. Indeed you are on the money with regards to the Journal style, as this is pretty much exactly what I want to produce in Excel. I find you statement "In Excel the only thing that can have borders is an individual cell" worrying, because from my code 2nd sample all cells in the crosstab are treated as header cells (e.g. I'm getting the borders at the side, which look ugly). I think it comes down to being able to figure out what tags relate to what cells, and if indeed what I am looking for is actually possible through ExcelXP. I tried the MSOffice2k destination, and in the html page all looks good, but the formatting changes when I open it in excel. The documentation on line seems a bit patchy in relation to identifying exactly what tags I need to look at specifically for ExcelXP. The standard docs say they are valid in markup destinations, but this does not translate into reality (given the same template will produce different results in ExcelXP versus say MSOfficeXP). Other than papers such as Eric's which give good examples of some of the tags, I can't resolve this without knowing if there are other sub tags that will allow me to remove the underlining at the side. My gut says it must be possible. thanks again John ... View more