>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 :
>* 문의할 Component명 및 버전 :
>* DataSet 버전 :
>* Tr 버전 :
>* 문의 유형(질문/요청/참조) :
>* 내용 :
>
>
>Mgrid를 사용하여 Grid를 구성하고 있으며 조회시
>데이터1
>데이터2
>.
>.
>'
>부분합계
>'
>'
>'
>부분합계
>
>전체합계
>가 Grid에 표현이 됩니다.
>그런데 이를 GridToExcel 로 하여 Excel표현 시 부분합계의 값이 (그리드에 표현된값이 아닌)
>이상한 값(부분합 이하 첫번째의 데이터값)이 나옵니다. GridToExcel이 그리드에 있는 내용을 그대로 가져오는 것으로 알고 있는데... 여기서의 문제인지, 아니면 Mgrid에서 설정을 해줘야 하는 부분이 있는지 궁금합니다.
>
>소스는 아래의 내용입니다.
>답변 부탁드립니다.
>
><comment id="__NSID__">
><object id="tbds_2" classid="<%=tbDataSetCID%>">
>        <param Name=SyncLoad     value="">
>        <param name=SubsumExpr    value="10:DeptNm1">        
></object>
></comment><script> __ws__(__NSID__); </script>
>
>
><Div ID="Dtbgd_2" STYLE="">
>        <table cellspacing="1" cellpadding="0" border="0" width="800" bgcolor="#A1A0A0" height="151px">
>                <tr>
>                        <td bgcolor="#FFFFFF">
>                                                <comment id="__NSID__">
>                                                                <object id="MGrid" classid="<%=tbMGrid%>" style="width:800px; height:410px;">
>                                                                        <Param Name="DataID"                value="tbds_2">
>                                                                        <Param Name="ViewSummary"                value="1">
>                                                                        <Param Name="ColumnInfo"                value='
>                                                                                <COLUMNINFO>
>                                                                            <COLUMN id="ID_DeptNm1" refcolid="DeptNm1">
>                                                                                    <HEADER left="0" top="0" right="100" bottom="80" text="본부"        />
>                                                                                    <SUPPRESS>
>                                                                                      <REFCOLID>DeptNm1</REFCOLID>
>                                                                                    </SUPPRESS>                                                                                                                                    
>                                                                                    <VIEW left="0" top="0" right="100" bottom="20"/>
>                                                                                    <VIEWSUMMARY text="전체합계" color="red" bgcolor="#99ffff"/>        
>                                                                            </COLUMN>
>
>                                                                            <COLUMN id="ID_DeptNm3" refcolid="DeptNm3" >        
>                                                                                    <HEADER left="100" top="0" right="200" bottom="80" text="충전소"/>
>                                                                                    <VIEW left="100" top="0" right="200" bottom="20"/>
>                                                                                    <GROUP level="10" bgcolor="#bb9999" />
>                                                                                    <VIEWSUMMARY bgcolor="#99ffff" />        
>                                                                            </COLUMN>
>
>                                                                            <COLUMN id="ID_01000" view="false">
>                                                                                                        <REFCOLID>DeptNm1</REFCOLID>
>                                                                                    <HEADER left="200" top="0" right="600" bottom="20" text="판매량"        align="centerleft"/>
>                                                                            </COLUMN>
>
>                                                                            <COLUMN id="ID_01000" refcolid="Rent_01000">
>                                                                                    <HEADER left="200" top="20" right="280" bottom="80" text=""/>
>                                                                                    <VIEW left="200" top="0" right="280" bottom="20"        text="@ROUND(Rent_01000/1000,0)"                align="Topright"        displayformat="#,##0"/>
>                                                                                    <GROUP level="10" bgcolor="#bb9999"        text="@GFSUBSUM(Rent_01000) /1000" align="Topright"        displayformat="#,##0"/>
>                                                                                    <VIEWSUMMARY text="@GFSUM(Rent_01000)/1000" color="red" bgcolor="#99ffff" align="Topright"        displayformat="#,##0"/>                                                                                                                                    
>                                                                            </COLUMN>
>                                                             </COLUMNINFO>'>
>                                                                        '>
>                                                                </object></comment><script>__ws__(__NSID__);</script>
>                        </td>                
>                </tr>                    
>        </table>                    
></Div>
>


DataSet 에 담기는 데이터를 csv 파일로 다운받아서.. 첨부 바랍니다.

소스만으로는 정확한 파악이 되지 않습니다.