I encountered a problem, when writing a chenged Excel-Sheet and then opening it again, for doing manually (or via macro) copy and paste. If I press Ctrl-C Excel is crashing with an application exception (if i delete the macro, the error also appears!). We are using the german version of Excel 2000. I tested it with 2.5.1 and 2.0-RC1 versions of POI.
Created attachment 13457 [details] excel to be filled
Created attachment 13458 [details] excel after writing
Created attachment 13459 [details] Test class which generates test1.xls
Created attachment 13460 [details] Test class which generates test1.xls
Comment on attachment 13460 [details] Test class which generates test1.xls sorry, hit the refresh button.....:-)
It's not clear that there is anything wrong with attachment (id=13458). It seems to work OK in my Excel (2007). The instructions are too vague. Ctrl-c worked (on whatever was initially selected. Copy paste seemed to work with every sheet. I couldn't find 'the macro' to delete. There was a little bit of VBA code, but nothing was obviously 'the macro'. There is a high chance that whatever bug you originally observed has been fixed between 2.5 and 3.1.