3. Merge Cell in xlsx. Gridlines are gone

Merge Cell in xlsx. Gridlines are gone

  • A

    Hello ,

    I have an problem. If I add a row , gridlines are gone. What is the problem ? I added code below.

    {{!-- Sheet 1 --}}


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

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

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

{{#xlsxReplace "xl/worksheets/sheet2.xml" "worksheet.sheetData[0].row[2].c[1]"}}
    <c t="inlineStr"><is><t>{{period}}</t></is></c>
{{/xlsxReplace}}

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

{{#each data }}
{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 5}}
<row>
    <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is><t>{{companyName}}</t></is></c>
    <c s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{subscriptionType}}</t></is></c>
    <c s="{{@root.$removedItem.c.[2].$.s}}"><is><t>{{contractPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[3].$.s}}"><is><t>{{transformerPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[4].$.s}}"><is><t>{{meterSerialNumber}}</t></is></c>
    <c s="{{@root.$removedItem.c.[5].$.s}}"><is><t>{{meterMultiplier}}</t></is></c>
    <c s="{{@root.$removedItem.c.[6].$.s}}"><is><t>{{impactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[7].$.s}}"><is><t>{{impactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[8].$.s}}"><is><t>{{impactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[9].$.s}}"><is><t>{{impactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[10].$.s}}"><is><t>{{impactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[11].$.s}}"><is><t>{{impactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[12].$.s}}"><is><t>{{impactiveIndexDemand}}</t></is></c>
    <c s="{{@root.$removedItem.c.[13].$.s}}"><is><t>{{expactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[14].$.s}}"><is><t>{{expactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[15].$.s}}"><is><t>{{expactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[16].$.s}}"><is><t>{{expactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[17].$.s}}"><is><t>{{expactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[18].$.s}}"><is><t>{{expactiveCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[19].$.s}}"><is><t>{{expactiveDemand}}</t></is></c>
    
</row>
{{/xlsxAdd}}
{{/each}}

{{!-- Sheet 2 --}}

{{xlsxRemove "xl/worksheets/sheet2.xml" "worksheet.sheetData[0].row" 7}}
{{#each data }}
{{#xlsxAdd "xl/worksheets/sheet2.xml" "worksheet.sheetData[0].row" 7}}
<row>
    <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is><t>{{companyName}}</t></is></c>
    <c s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{installationNumber}}</t></is></c>
    <c s="{{@root.$removedItem.c.[2].$.s}}"><is><t>{{subscriptionType}}</t></is></c>
    <c s="{{@root.$removedItem.c.[3].$.s}}"><is><t>{{contractPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[4].$.s}}"><is><t>{{transformerPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[5].$.s}}"><is><t>{{meterSerialNumber}}</t></is></c>
    <c s="{{@root.$removedItem.c.[6].$.s}}"><is><t>{{meterMultiplier}}</t></is></c>
    <c s="{{@root.$removedItem.c.[7].$.s}}"><is><t>{{firstIndex.impactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[8].$.s}}"><is><t>{{firstIndex.impactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[9].$.s}}"><is><t>{{firstIndex.impactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[10].$.s}}"><is><t>{{firstIndex.impactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[11].$.s}}"><is><t>{{firstIndex.impactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[12].$.s}}"><is><t>{{firstIndex.impactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[13].$.s}}"><is><t>{{firstIndex.expactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[14].$.s}}"><is><t>{{firstIndex.expactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[15].$.s}}"><is><t>{{firstIndex.expactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[16].$.s}}"><is><t>{{firstIndex.expactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[17].$.s}}"><is><t>{{firstIndex.expactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[18].$.s}}"><is><t>{{firstIndex.expactiveCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[19].$.s}}"><is><t>{{lastIndex.impactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[20].$.s}}"><is><t>{{lastIndex.impactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[21].$.s}}"><is><t>{{lastIndex.impactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[22].$.s}}"><is><t>{{lastIndex.impactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[23].$.s}}"><is><t>{{lastIndex.impactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[24].$.s}}"><is><t>{{lastIndex.impactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[25].$.s}}"><is><t>{{lastIndex.expactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[26].$.s}}"><is><t>{{lastIndex.expactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[27].$.s}}"><is><t>{{lastIndex.expactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[28].$.s}}"><is><t>{{lastIndex.expactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[29].$.s}}"><is><t>{{lastIndex.expactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[30].$.s}}"><is><t>{{lastIndex.expactiveCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[31].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[32].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[33].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[34].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[35].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[36].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[37].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[38].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[39].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[40].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[41].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[42].$.s}}"><is><t>{{monthlyTotal.totalExpactiveCapacitive}}</t></is></c>

</row>
{{/xlsxAdd}}
{{/each}}

{{!-- Sheet 3 --}}


{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}

{{#xlsxAdd "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 2}}
<row>
        <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is>asda<t></t></is></c>
        <c t="inlineStr" s="{{@root.$removedItem.c.[1].$.s}}"><is><t>deneme</t></is></c>
        <c t="inlineStr" s="{{@root.$removedItem.c.[2].$.s}}"><is><t>deneme</t></is></c>

</row>
{{/xlsxAdd}}
{{{xlsxPrint}}}

    0_1644825781528_Screenshot at Feb 14 11-02-42.png

    0
  • A

    I have created on playground. I shared with you. I want to add data A17 and A18. (Merge cell). Please run BillReport(Clone).
    https://playground.jsreport.net/w/anon/9~DxUjVd

    0

  • Merged cells don't have the gridlines inside by design.. What am I missing?

    0
  • A

    Our template has gridlines. I added template and code url above also I said that I want to add data A17 and A18. (Merge cell). I didin't do it How can I do that ?
    Thanks

    0
Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.