• Forums
• Home

Search Rate this topic:   Comments (optional) Sort Posts:  Oldest to newest Newest to oldest

03-17-2006, 12:28 PM klelder Joined on 11-18-2005 Posts 15 Excel export extra rows Why does the excel export add an extra row to every line in my report that uses backcolor?  I have noticed this in some reports that have the PageHeader.BackColor = LightGray and in another report that sets the backcolor of every other detail line to LightGray.  When I look at the excel output, I have two rows for the lines that are gray - one row with gray background and no data and another row with gray background and the detail data. I am using the following settings: xls.FileFormat = DataDynamics.ActiveReports.Export.Xls.FileFormat.Xls97Plus; xls.UseCellMerging = true; xls.AutoRowHeight = false; xls.RemoveVerticalSpace = true; xls.MinColumnWidth = (float).375;   thanks!    Report

03-20-2006, 10:58 AM Peter Power - DD Joined on 08-28-2004 Posts 1,217 Re: Excel export extra rows The first step is to make sure that you are using the latest build (1205). By default, the Active Reports assemblies should be installed at the following path on your machine: C:\Program Files\Common Files\Data Dynamics\ActiveReports for .NET 2.0. You can right click on the ActiveReports.dll, choose Properties, and then version, to check which version of the asseblies you are currently running. If you are not using the most recent build, you can download it here: http://www.datadynamics.com/forums/64/ShowForum.aspx. If this does not resolve the issue, please save your report output to the RDF format and attach it to this thread so that I can take a look at it. You can save the report to the RDF format by calling the .Document.Save method off of the report object after the report has been run. Ex. rpt.Document.Save(@"C:\Output.RDF");    Report

03-20-2006, 1:17 PM klelder Joined on 11-18-2005 Posts 15 Re: Excel export extra rows Attachment: dd.zip I am definitely using build 1205.  I have checked this a number of times. :-) I am attaching a zip file with the xls and the rdf of the report so you can see what is happening. thanks! Koren    Report

03-20-2006, 1:36 PM Peter Power - DD Joined on 08-28-2004 Posts 1,217 Re: Excel export extra rows The problem seems to be related to the UseCellMerging Property. Try setting this property to false.    Report

03-21-2006, 2:26 PM klelder Joined on 11-18-2005 Posts 15 Re: Excel export extra rows Attachment: dd-2.zip Well, that didn't work.  Now, all of my rows that expand on the other types of reports (e.g. PDF, HTML) create two rows in excel.  Any other ideas? thx, Koren    Report

04-28-2008, 12:37 PM bpb2221 Joined on 08-13-2007 Posts 8 Re: Excel export extra rows Did anyone ever figure this out?  I am having the same problem.  It adds extra rows.  I have 30 other Excel reports that do not do this.  They are all exactly the same. The only difference is this one report is really wide.    Report

04-29-2008, 12:23 PM ericc Joined on 03-01-2005 Posts 1,857 Re: Excel export extra rows Attachment: ExcelExport.zip Thank you for your post. Unfortunately, I have been unable to reproduce the described behavior using the latest build of ARN2.0. Please ensure you are using the latest build of ARN2.0 available (1261). You can find the update here: http://www.datadynamics.com/forums/64/ShowForum.aspx Also, the attached sample works well in my testing. Would it be possible for you to modify the attached sample to reproduce the behavior you are encountering if my testing approach does not accurately represent your situation? Thanks,     Eric    Report

10-28-2009, 8:53 AM ekos2001 Joined on 03-02-2009 Posts 6 Re: Excel export extra rows Attachment: Report.zip Hi We use ActiveReports 3 SP3 (5.3.1436.2) and have the similar problem during export to excel UseCellMerging must be set to true RemoveVerticalSpace also has some effect... Also, if field with non-empty background has some value, it works correctly, but if this field is empty - it doesn't RPX sample in attachment. Thanks, Yevgen    Report

10-28-2009, 1:36 PM AnkitN Joined on 03-03-2009 Posts 844 Re: Excel export extra rows I was able to replicate the issue at our end. I have opened a new Case 138023 to get this issue addressed. I have also added your E-mail address as an affected user to this case. You will be notified when the issue gets fixed. Regards, Ankit Nigam    Report

03-02-2010, 4:04 PM Sireesha Parvatham Joined on 08-02-2006 Posts 24 Re: Excel export extra rows Hi, Is this issue resolved? I am using AR 6 (version 6.0.2250.0) and getting similar issue for excel export. When I give backcolor to a text box and exported to excel, it creates extra row with no data and with back color. It works fine with pdf and excel export works fine when backcolor is removed. Please let me know. Thanks    Report

03-03-2010, 1:33 AM AnkitN Joined on 03-03-2009 Posts 844 Re: Excel export extra rows Hello, Currently the issue is assigned to our development team. I have attached your E-mail address to the list of affected users for this case. You will be notified when the issue gets fixed. Regards, Ankit Nigam    Report

07-11-2011, 12:49 AM chanfu Joined on 07-11-2011 Posts 1 Re: Excel export extra rows i also encountered this problem which the backolor will take more than 1 rows.Is this problem solved???    Report

07-11-2011, 5:11 AM subodh.sinha Joined on 10-06-2009 Posts 1,087 Re: Excel export extra rows Hello, The above mentioned case is yet not fixed. You will be notified when the issue gets fixed. Thanks, Subodh    Report

GrapeCity » Product Support » ActiveReports f... » Excel export extra rows

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Announcements |- ActiveBar Announcements |- ActiveReports Announcements |- ActiveReports for .NET Announcements |- ActiveSizer Announcements |- Data Dynamics WebSite Announcements |- DynamiCube Announcements |- SharpGraph for .NET Announcements |- SharpGrid Announcements |- SharpUI for .NET Announcements |- Data Dynamics Reports Announcements |- GrapeCity ActiveAnalysis Announcements Frequently Asked Questions |- ActiveReports 2.0 FAQ |- ActiveSizer FAQ |- DynamiCube FAQ |- SharpGrid FAQ |- ActiveReports for .NET FAQ |- ActiveBar FAQ |- SharpUI for .NET FAQ Product Support |- ActiveBar Support |- Data Dynamics Analysis Support |- ActiveReports 6 Support |- GrapeCity ActiveAnalysis Support |- ActiveReports for .NET 3.0 Support |- ActiveReports for .NET 2.0 Support |- ActiveReports for .NET Support |- ActiveReports 2.0 (Visual Basic 6.0) Support |- ActiveSizer Support |- DynamiCube Support |- SharpGraph for .NET Support |- SharpGrid Support |- SharpUI for .NET Support |- Data Dynamics Reports Support Knowledge Base |- KnowledgeBase for SharpUI for .NET |- KnowledgeBase for ActiveCube |- KnowledgeBase for ActiveReports |- KnowledgeBase for ActiveBar |- KnowledgeBase for ActiveReports for .NET |- KnowledgeBase for SharpGrid |- KnowledgeBase for ActiveSizer |- KnowledgeBase for DynamiCube |- KnowledgeBase for SharpGraph for .NET |- KnowledgeBase for Data Dynamics Reports Forum Archives |- ActiveReports for .NET 2.0 Visual Studio .NET 2005 Support |- ActiveBar 3.0 Beta Support |- support.activebar2.general |- support.activereports.general |- support.activereports.net |- support.activereports2.stdedition |- support.activereports2.proedition |- support.activesizer.general |- support.announcements |- support.dcube.c++ |- support.dcube.delphi |- support.dcube.ie |- support.dcube.misc |- support.dcube.vb |- support.dcube.vfp |- support.sharpgrid.general Product Downloads |- ActiveSizer Downloads |- SharpUI for .NET Downloads |- ActiveReports for .NET Downloads |- ActiveCube Downloads |- ActiveReports Downloads |- ActiveBar Downloads |- SharpGrid Downloads |- ActiveReports for .NET 2.0 Downloads |- SharpGraph for .NET Downloads |- DynamiCube Downloads |- ActiveReports for .NET 3.0 Downloads |- ActiveReports 6 Downloads |- Data Dynamics Reports Downloads Web Site Feedback |- Web Site Feedback Employment Opportunities |- Employment Opportunities