Excel export problem

[IT]

I have one particular report that, when I export to excel generates the following exception:

Attempting to get range {35,33}{1,4},Merged=False,Parent=Sheet1[0], that intersects with an already merged range.

[Rossen Hristov]

Hello Josh,

Can you please send us your report and we will investigate the cause for this exception.

Greetings,
Ross
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Aslak]

I had a similar problem, and I discovered that the export failed if the height of the textboxes in the detail block, and the height of the detail block both were exactly 0.6 cm. IF I changed the height to a be a little blit larger (0.63492cm) IT WORKED! Believe it if you can. But it seems to be a problem if the detail block and the textboxes have the same height. I increased the height of the detail block, and then it worked.

Regards from Norway!

[IT]

That was it! Thank you very much!!!

[Chavdar]

Hello guys,

It's great to hear that you managed to solve the problem and get things working. However, we would like to reproduce the problem as well. We have tried the described scenario, but it didn't work. If possible, could you send us a report definition which causes the issue? It will help us reproduce the issue and fix it internally. You can send your projects either in a new support ticket or to clientservice AT telerik DOT com (subject: REF: 117286).

Thanks in advance.


Greetings,
Chavdar
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Jon]

I have also this problem..

In a report with 4 subreports, one report have a report with height of apx. 80cm.
When I put a picturebox with position Y above ~20cm , it produces the error.

Setting it above works fine...(Also set the PicutreBox visible to false works :) )
Putting a Textbox anywhere also works fine..
The size of the PicutreBox doesnt seem to make any impact.

Could it be something with  "page break" ? .. (My report make 30-40 pages)

(btw, I use the trail version)

Error:
Attempting to get range {0,49}{23,7},Merged=False,Parent=Sheet1[0], that intersects with an already merged range.

[InvalidOperationException: Attempting to get range {0,49}{23,7},Merged=False,Parent=Sheet1[0], that intersects with an already merged range.] Telerik.Reporting.ExcelRendering.Biff.Worksheet.GetRange(Int32 col, Int32 row, Int32 colSpan, Int32 rowSpan) +172 Telerik.Reporting.ExcelRendering.RenderingItem.GetRange(IWorksheet worksheet, LayoutInfo layoutInfo) +324

---

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

[Aslak]

Maybe this has nothing to do with the case, but for me the problem only arises when Page = Landscape...

[Chavdar]

Hi Jon,

In order to find the problem as quickly as possible could you open a support ticket and send us a sample project which reproduces the issue? We will need to examine the exact configuration to find exactly what goes wrong.

Thanks in advance.
 

Greetings,
Chavdar
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[mei]

Hello,

We had the same error when export a report to excel.

"Attempting to get range {2,20}{38,219},Merged=False,Parent=Sheet1[0], that intersects with an already merged range."

This report contains one sub report. And I found the error only occurred when the data on sub report is 3 pages or more. Could you sort out this issue as soon as possible?

Thanks in advance.

Mei

[Chavdar]

Hi mei,

We have recently found a problem when using the SubReport item. It has been already fixed but the fix will not be available until the next release of Telerik Reporting due in April. Until then the only workaround is to make the subreport item with the same height as its report source.

We are sorry for the inconvenience.

Regards,
Chavdar
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Adeel]

I am facing the same problem, but I am unable to resolve the problem.
I am creating the report programmitically at runtime and I set the report page as custome page, means I have custom paper size for the report. The detail section height is greater the the textbox controls height, it is greater than the height of the textbox by 10 pixels. But I am unable to get the excel output.
Actually the excel report renders the Header and footer properly but the data in the detail section is not comming into the excel report format. How ever my reports are working on the PDF format properly. This issue is only raised in the XLS and CSV formats. I have searched out the whole forum but I am unable to get my issue resolved.

Kindly Help me, its urgent.

[Chavdar]

Hello Adeel,

We have recently released Q1 2008 version of Telerik Reporting. Please, upgrade to it and let us know if the problem still exists. In case you are still experiencing it, please open a support ticket and send us a sample report which replicates the issue.

Best wishes,
Chavdar
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center