A follow-up - how to show tooltips or the value at the end of bar.

Thanks,
Rashmi

Thank you - that does the trick.

Hi,
I am trying to show a gantt chart in jsreports. The bars are not right. The span should be more. Please take a look at the playground sample - https://playground.jsreport.net/w/rashmim00/n4SNYVK3
Same code if I run on jsfiddle - the bars show properly.
Not sure what's going on.

Thanks for helping me,
Rashmi

What a dumb thing. Just defining styles doesn't matter until they are used in the sheet.
If i create a row with rubbish data and apply these styles and then use the template in jsreport then it works.

Hi,
I am trying to put in styles for amounts and percentage columns. Here is playground with the xlsxTemplate I am using which defines styles for amtCol and percCol.

https://playground.jsreport.net/w/rashmim00/~suTCrBX

I have tried all s="2" to s="4" and my sheet fails and needs repair.

Pl help me identify the style or create a new xlsxtemplate with good styling,
I have already spend lot of time on it,
pl help,
Rashmi

Styles.xml extracted by making it rar file etc

-<numFmts count="1">
<numFmt formatCode=""$"#,##0.00" numFmtId="164"/>
</numFmts>
-<cellStyleXfs count="5">
<xf numFmtId="0" borderId="0" fillId="0" fontId="0"/>
<xf numFmtId="0" borderId="0" fillId="0" fontId="2"/>
<xf numFmtId="1" borderId="0" fillId="0" fontId="1"/>
<xf numFmtId="10" borderId="0" fillId="0" fontId="1"/>
<xf numFmtId="164" borderId="0" fillId="0" fontId="1"/>
</cellStyleXfs>

-<cellXfs count="4">
<xf numFmtId="0" borderId="0" fillId="0" fontId="0" xfId="0"/>
<xf numFmtId="0" borderId="0" fillId="0" fontId="2" xfId="1"/>
<xf numFmtId="164" borderId="0" fillId="0" fontId="1" xfId="4"/>
<xf numFmtId="10" borderId="0" fillId="0" fontId="1" xfId="3"/>
</cellXfs>

-<cellStyles count="5">
<cellStyle xfId="4" name="AmtCol"/>
<cellStyle xfId="0" name="Normal" builtinId="0"/>
<cellStyle xfId="2" name="NumberCol"/>
<cellStyle xfId="3" name="percCol"/>
<cellStyle xfId="1" name="rptHeading"/>

</cellStyles>

My bad. I have to pick a column before which had the title. so c[0] worked.

Hello,
Is there a different way to put data for a cell which has dropdown list. This doesn't work.

{{#xlsxReplace "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[1].c[1]"}}
        <c t="inlineStr" s="129"><is><t>{{PRJ_TYPE}}</t></is></c>
    {{/xlsxReplace}}

Thank you

I have cleaned up the folder by removing folderId from config files

hmmm.... my theory is that same information provided twice broke it.
Earlier I was sending arrays as part of data and fetching the same in the script too in beforeRender()
and now as it was oversight at my part (twice fetching) and things were broken :-) , I don't send them as part of data and let script fetch it then it works

OR data property doesn't like array.
Template is simple, loops on transactions and add rows.

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 1}}

{{#each transactions}}
{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
<row>
    <c t="n" s="{{@root.$removedItem.c.[0].$.s}}"><v>{{PRJ_ID}}</v></c>
    <c t="inlineStr" s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{PRJ_NAME}}</t></is></c>
    <c t="inlineStr" s="{{@root.$removedItem.c.[2].$.s}}"><is><t>{{IMPL_DEPT}}</t></is></c>
    <c t="inlineStr" s="{{@root.$removedItem.c.[3].$.s}}"><is><t>{{PROJ_MGR}}</t></is></c>
    <c t="inlineStr" s="{{@root.$removedItem.c.[4].$.s}}"><is><t>{{intRvw}}</t></is></c>
    <c t="inlineStr" s="{{@root.$removedItem.c.[5].$.s}}"><is><t>{{LAST_PUSH}}</t></is></c>
    <c t="inlineStr" s="{{@root.$removedItem.c.[6].$.s}}"><is><t>{{map}}</t></is></c>
</row>
{{/xlsxAdd}}
{{/each}}

Somehow dataObj made the difference..
let dataObj = { 'template': {'shortid' : 'rJlrkXrcE'},'data':{}} //worked

let dataObj = { 'template': {'shortid' : 'rJlrkXrcE'},
'data':{'aaaa': array1, 'bbbb': array2 }
} //broken