Merge Cell in xlsx. Gridlines are gone



  • 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



  • 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



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



  • 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


Log in to reply
 

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