Hi Radek, Sorry for the delay (I tried to reply your mail twice, last afternoon and night, but both of them are failed...)
This is a known issue, please reference https://issues.apache.org/jira/browse/ODFTOOLKIT-296. I supplied a patch there but can't add it to the master repository before the first release done. I suggest you download it from: https://issues.apache.org/jira/secure/attachment/12504717/ODFTOOLKIT-296.patch and import to the checked out code, then generate new binary to fix it. SVN address:https://svn.apache.org/repos/asf/incubator/odf/ Any problem please let me know. 2012/1/4 Radek Henyš <[email protected]> > Hi,**** > > ** ** > > thanks for your quick answer. There is a sample document in the > attachment, but I don't think it will be any usefull to you.**** > > ** ** > > My problem is, I am working on non-commercial program in Java for editing > logbook files from Flight Simulator. As one of its features, I made an > export to an ods spreadsheet using simple-odf API (which I found at your > site). There are several flight times in the logbook. Those may be more > than 24 hours. But when I try to set**** > > the value of the cell like:**** > > ** ** > > cell.setTimeValue(value)**** > > ** ** > > it gets cropped when more than 24 hours. Like 26 hours became 03 (because > of my timezone is GMT+1). Neither I can't cheat this using > "cell.setDateValue". The**** > > reason for this I think is that time values are stored as day fraction in > the spreadsheet file. **** > > ** ** > > I was just wondering if writing time value greater than 24 hour is > supported. It is when I write it by hand in the spreadsheet, so far not > able to do programatically.**** > > ** ** > > I can save these values as string values (as they are in the attachment), > but it would be good if they are time values, so the SUM and other function > may be used**** > > on them later.**** > > ** ** > > Radek Henys**** > > ** ** > > *From:* Devin Han [mailto:[email protected]] > *Sent:* Wednesday, January 04, 2012 2:08 PM > *To:* Radek Henyš > *Subject:* Re: Duration value in cell**** > > ** ** > > Hi, > > Could you give me a sample document?**** > > 2012/1/4 Radek Henyš <[email protected]>**** > > Hello,**** > > **** > > sorry for bugging you, you probably have to answer many email like this, > but I have just one question. Is it possible with simple odf to set > duration value in cell (time value that has more than 24 hours?). I was > googling, trying different code and can't figure this out. Thanks for any > reply and have a nice day.**** > > **** > > Radek Henys**** > > > > > -- > -Devin**** >
