search

chokkarg / worktime

Automatically exported from code.google.com/p/worktime
0 stars 0 forks source link

Add export to Excel for reports #107

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
CSV export already exists and is quite easy to do, it would be nice to also be 
able to export to Excel.

There are two options:
1) JExcelAPI: http://jexcelapi.sourceforge.net/
    Should be very easy to use, but possible nullpointer exception: http://stackoverflow.com/questions/8006087/how-to-create-an-excel-file-in-android
    No longer developed since november 2009
    Library: 656KB (lightweight!)
2) Apache POI: http://poi.apache.org/
    Example: http://as400samplecode.blogspot.com/2011/10/android-read-write-excel-file-using.html
    Not so easy to use but should quality should be guaranteed (Apache project!)
    Core lib: 1,73 MB (extra libs 5,40 MB, but needed?)

Both options should be looked in to, features that are important:
1) write excel in 2000-format (xls)
2) Use formulas (to calculate with dates)
3) Format dates-times in [h]:mm:ss format (makes dates like 123:45:21)

Original issue reported on code.google.com by dirkvran...@gmail.com on 7 Apr 2012 at 8:19

GoogleCodeExporter commented 8 years ago

Original comment by dirkvran...@gmail.com on 16 Apr 2012 at 6:33

GoogleCodeExporter commented 8 years ago 
Sample of the export so far attached. So far without calculated columns and 
Excel date-time formating

Original comment by dirkvran...@gmail.com on 17 Apr 2012 at 1:37

Attachments:

GoogleCodeExporter commented 8 years ago

Original comment by dirkvran...@gmail.com on 23 Apr 2012 at 2:57

GoogleCodeExporter commented 8 years ago 
Some issues remain:
1) On the report-tab the calculated durations per task are one hour short 
everywhere!
2) Some durations (in my case always lower than one hour, and always for the 
last task on a day that has multiple tasks or projects) are not displayed 
correctly. They are not dates but a negative number (-0,0229166666649689 should 
be 0:27)

Original comment by dirkvran...@gmail.com on 2 May 2012 at 8:17

GoogleCodeExporter commented 8 years ago 
This has been fixed, the reason was that for calculating the excel-times the 
time zone was used from the device; this however needs to be the GMT+0 timezone 
to be Excel compatible.

Original comment by dirkvran...@gmail.com on 4 May 2012 at 9:39

GoogleCodeExporter commented 8 years ago

Original comment by dirkvran...@gmail.com on 15 May 2012 at 9:51

GoogleCodeExporter commented 8 years ago

Original comment by dirkvran...@gmail.com on 15 May 2012 at 9:56