It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42
×9

question asked: Sep 29 '14, 4:57 p.m.
question was seen: 3,117 times
last updated: Sep 29 '14, 5:06 p.m.

Related questions

Why doesn't the JTSMon Visualizer handle bigger data sets even when I use Excel 2010 and above ?

0
Dave Schlegel (331●1●6●7) | asked Sep 29 '14, 4:57 p.m.
JAZZ DEVELOPER
edited Sep 29 '14, 5:06 p.m.
I get an "Runtime Error 1004 Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns" when I have JTSMon data with more than 255 samples (about a week and a half of hourly data). This happens even when I am using Microsoft Excel 2007 or above which can handle more columns of data.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Dave Schlegel (331●1●6●7) | answered Sep 29 '14, 5:05 p.m.
JAZZ DEVELOPER
The problem is that the JTSMon Visualizer is packaged as an "xls" file that is compatible with Excel 2003 and above so by default it creates a new output spreadsheet with the 255-column limit.

This has been fixed under workitem 326340 "JTSMon: Runtime error 1004 on creating workbook with Excel 2010 and above" by saving the new file out and rereading it back with the larger data limit.

The modified JTSMon VIsualizer is included in an updated version of the main JTSMon package on the deployment wiki. Just redownload the main zip package ( https://jazz.net/wiki/pub/Deployment/JTSMonFAQ/JTSMon_5.0.0_RTC4.0.2GA.zip) and the updated version of the Visualizer is included. The new Visualizer is labeled with a September 29 2014 version even though the main package has not been updated otherwise.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.