Hangs on .save() when adding more than 3 worksheets

Aug 23, 2011 at 10:21 AM

I'm having a problem generating my xlsx file.

It's a file with 22 worksheets with the size 394 KB. I try to add 5 more worksheets to it but it hangs. I try to .save() after each worksheet but the hangs only happen after i save the 3rd one.

I use the following code for creating the worksheets  

string worksheet = "Presencas" + comeca.ToString("dd-MM-yyyy");
wb.Worksheet("Presenças").CopyTo(worksheet);

 I don't know whats wrong.

Coordinator
Aug 25, 2011 at 4:56 PM

btw, I haven't forgotten about you. I'll get to this soon...

Coordinator
Aug 26, 2011 at 4:05 AM

I can't reproduce this error on my own, can you post a piece of code that reproduces the error? If not can you send me the file you're using via email or as an attachment in an issue?

Thank you for your patience and help.

-Manuel

Aug 26, 2011 at 10:07 AM
Edited Aug 26, 2011 at 10:08 AM

I'll make an working example for you to test it. Got to make some changes since it connects to a DB to pickup values to fill.

I'll send you when its ready.

I'm the one to thank you for the help!

Do you have problems if it is a web application ?

Aug 26, 2011 at 11:28 AM
Edited Aug 26, 2011 at 11:39 AM

Send you a pm with an example application.

Thanks a lot.

P.S - Sended you a 2nd link with the correct version.

Coordinator
Aug 26, 2011 at 10:46 PM

I have no idea how nobody had complained about that bug before but it's fixed now. Please try the latest check-in and let me know if it works for you (it does for me).

Thanks again for your feedback,

Aug 29, 2011 at 9:14 AM
Edited Aug 29, 2011 at 9:18 AM

Yeah thanks. i used the last Check-ins and it worked perfectly.

You're support is great and i wish some services could be just fast and good as you people are. thanks again.

Aug 29, 2011 at 9:36 AM
Edited Aug 29, 2011 at 4:06 PM

I notice that i'm loosing the header and footer text and image.

I don't think this happened in the previous version ?

P.S - It happens on the example application i send you with your new dll.

Coordinator
Aug 30, 2011 at 5:26 PM

I'll work on it.

Coordinator
Aug 31, 2011 at 3:10 AM

I guess nobody opened and saved a file with an image in the header/footer before because this wasn't working.

It's fixed on the latest check-in. The way it works now is that it keeps the images as long as you don't change the sheet's header or footer.

Thanks for the feedback.

Aug 31, 2011 at 8:29 AM

Awesome work and response time!

Now it keep the headers and footers on the worksheets.

But if you create a worksheet from another one, using the CopyTo, the headers and footers disappear on the new one.

Can you check what's happening? thanks!

 

Sep 3, 2011 at 1:01 PM

I keep trying different solutions but the problem still exists.

Coordinator
Sep 3, 2011 at 6:04 PM

Images are not copied when you use .CopyTo because the library doesn't support images yet.

Sep 5, 2011 at 8:22 AM

Are you thinking of implementing this any soon ?

Thanks.

Coordinator
Sep 5, 2011 at 5:34 PM

Can't give you an ETA but I'll take a look at it soon.

Sep 15, 2011 at 3:20 PM

Greetings. Any progress on this subject? thanks!

Coordinator
Sep 15, 2011 at 4:25 PM

Allowing images on the header/footer seems simple enough but I can't give you an ETA. This is 3rd on my to-do-list though (first need to fix named ranges when cells are shifted and fully implement auto filters).

I know it's not the news you want to hear...