Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • Please see the attached picture about what I mean. This only happens when exporting a boolean value. I have tried setting the PrintCellStyle and it still happens.

                                Untitled.png
                                0

                                I have also tried using a PrintCellStyle for one of my other columns and am getting the same effect. How can I stop this.

                                <Style x:Key="ColumnPrintCellStyle"
                                               BasedOn="{StaticResource CustomPrintCellStyle}"
                                               TargetType="Control">
                                            <Setter Property="Template">
                                                <Setter.Value>
                                                    <ControlTemplate>
                                                        <Border x:Name="PART_Editor">
                                                            <TextBlock dxp:TextExportSettings.TextValue="{Binding Value[0].Percent}"
                                                                       dxp:ExportSettings.TargetType="Text"
                                                                       VerticalAlignment="Center"/>
                                                        </Border>
                                                    </ControlTemplate>
                                                </Setter.Value>
                                            </Setter>
                                        </Style>

                                0

                                Hi,

                                Thank you for the screenshot and for providing the sample code.

                                I have looked at the screenshot, but I am afraid I do not quite understand the problem you ran into. To help us better understand the situation, can you please post here additional screenshots, illustrating how the data is displayed in the grid and how it is exported? If you can also provide us with a project, where the problem is reproduced, that would be appreciated.

                                Thanks,
                                Vito

                                0

                                Try running the sample code I sent you and clicking on the export button. You will notice that the 'Boolean' column is exported to excel but uses three rows and three columns to represent itself in excel. If you remove the 'Boolean' column everything is fine.

                                I have attempted to fix this by using a PrintCellStyle but have been unable to do so. I also want the column to show True/False rather than some strange check box in excel.

                                WpfApplication1.zip
                                0

                                Hello!

                                Thank you for the sample. Please assign the Boolean column EditSettings directly, this fixes the issue:

                                <dxg:GridColumn x:Name="Boolean"
                                                FieldName="Boolean">
                                    <dxg:GridColumn.EditSettings>
                                        <dxe:CheckEditSettings HorizontalContentAlignment="Center"/>
                                    </dxg:GridColumn.EditSettings>
                                </dxg:GridColumn>

                                Also, I have created a separate bug report: Exporting Boolean values causes three merged rows to appear for each data row

                                Thank you, Marina

                                0

                                I am using 2009. I just tried adding your code snippet to the xaml and it does not solve the problem. Can this be solved somehow by using a combo box. Can you please show how.

                                0

                                I tested this code snippet under v9.3.5 version. You sample works fine for me with using the EditSettings property. Please review the modified sample. I am looking forward to hearing from you.

                                Thank you, Marina

                                Q298262.zip

                                To start a chat you should create a support ticket


                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners