Hey Allan, that's exactly the problem I've. Maybe the POI has some bugs?
2012/10/5 allan <[email protected]> > Hi Hans, > I took your block of code and created same worksheet under Ubuntu 10x, > opened it with Excel 2010 and got an error: "File error: data may have been > lost." > I have, at this location, several product Excel files which were created > on a similar machine, Ubuntu 10.x, that open fine on same windoz machine. > There seems to be a difference between these two laptops which I will > investigate. The only problem: one of them is many miles from my current > location so this may take some time. In the meantime, maybe someone has > input to this problem. > Peace, > > > > > On 10/04/2012 11:40 AM, Hans Maulwurf wrote: > >> Well yes, I used different Excel versions (2003 & 2010) and even different >> Windowz (XP & 7), always the same :/ >> I don't think it's an encoding problem, because I create an empty file >> (same if I fill some cells) so there are no special characters. Would it >> help if I send you the xls? >> >> >> >> 2012/10/4 allan <[email protected]> >> >> Would I be correct in assuming that in all cases, one version of MS Excel >>> has been used to elicit the problem? >>> Have you, by chance, used another windoz machine and/or another version >>> of >>> Excel for opening the "suspect" file? >>> Just a hunch, here... >>> BTW, what version of Excel are you using? >>> Peace, >>> >>> >>> On 10/04/2012 02:13 AM, Hans Maulwurf wrote: >>> >>> I don't understand it ... changing to java6 didn't solve it. I set up a >>>> new >>>> virtual machine Xubuntu and installed openjdk6 and netbeans from >>>> repository. I changed nothing, I'm only running these lines >>>> >>>> public static void main(String[] args) throws IOException { >>>> >>>> HSSFWorkbook wb = new HSSFWorkbook(); >>>> FileOutputStream fileOut = new >>>> FileOutputStream("/home/****muench/workbook_test.xls"); >>>> >>>> wb.write(fileOut); >>>> fileOut.close(); >>>> } >>>> >>>> But opening the xls under Windows with Microsoft Office it shows the >>>> same >>>> behaviour ... I don't know how to continue :/ >>>> >>>> >>>> 2012/10/4 Hans Maulwurf <[email protected]> >>>> >>>> Maybe the java6 and java7 lead to this behaviour? Under Windows I used >>>> >>>>> java6, I wanted to have an up-to-date-Ubuntu so I installed java7. I >>>>> will >>>>> try to switch to java6 and report here. >>>>> >>>>> >>>>> 2012/10/3 Hans Maulwurf <[email protected]> >>>>> >>>>> No, I used the same version of poi on windows, saved the files and >>>>> used >>>>> >>>>>> it on linux again. Replacing them with fresh downloaded doesn't change >>>>>> the >>>>>> situation. When compiling/debugging/creating there is no error, only >>>>>> opening with Microsoft Office shows this error (about 3 times) and >>>>>> then >>>>>> the >>>>>> sheets are shown correctly. >>>>>> >>>>>> >>>>>> 2012/10/3 Nick Burch <[email protected]> >>>>>> >>>>>> On Wed, 3 Oct 2012, Hans Maulwurf wrote: >>>>>> >>>>>>> >>>>>>> I'm using poi-3.8-20120326.jar and that's the same I used on >>>>>>> Windows. >>>>>>> >>>>>>>> I >>>>>>>> don't use a '/' in sheetnames, the same error comes when I only >>>>>>>> create a >>>>>>>> workbook and save it as xls, without cells or sheets, only the >>>>>>>> default >>>>>>>> sheets. >>>>>>>> >>>>>>>> >>>>>>>> Are you sure that there are no differences in POI versions? Could >>>>>>> there >>>>>>> perhaps be an older version of POI lurking somewhere on your >>>>>>> classpath? >>>>>>> (Check the FAQ for how to find them). >>>>>>> >>>>>>> I've had no ubuntu-specific POI problems that I can think of lately, >>>>>>> and >>>>>>> I've been using POI on ubuntu for a very long time now! >>>>>>> >>>>>>> Nick >>>>>>> >>>>>>> >>>>>>> ------------------------------******--------------------------** >>>>>>> --**--** >>>>>>> --------- >>>>>>> To unsubscribe, e-mail: [email protected].******org< >>>>>>> user-unsubscribe@poi.**apache.**org <http://apache.org> < >>>>>>> [email protected].**org <[email protected]> >>>>>>> >> >>>>>>> >>>>>>> >>>>>>> For additional commands, e-mail: [email protected] >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> ------------------------------****----------------------------** >>> --**--------- >>> >>> To unsubscribe, e-mail: [email protected].****org< >>> user-unsubscribe@poi.**apache.org <[email protected]>> >>> For additional commands, e-mail: [email protected] >>> >>> >>> >> > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > [email protected].**org<[email protected]> > For additional commands, e-mail: [email protected] > >
