- This topic is empty.
- July 15, 2010 at 11:36 pm #965nidiapaschke9Participant
Running Klok 2.1 on linux.
Prior to Klok 2.0 when I exported the monthly time sheet to excel it created an actual excel spreadsheet that opened nicely in openoffice. Now when I export the .xls file has what looks like html table notation instead. And openoffice gets confused.
For example, here is what an saved timesheet looks like a plain text editor
Timesheet for 07/01/2010 – 07/31/2010 07/01/2010 07/02/2010 07/03/2010 07/04/2010 07/05/2010 07/06/2010 07/07/2010 07/08/2010 07/09/2010
renaming it .html allow firefox to display it with a decent formatting.
But I really need it in excel format so it can be manipulated. Is this a feature or a bug?August 4, 2010 at 8:31 pm #1761AnonymousInactive
I have the same issue. I have taken the copy of the text in the link, renamed it to .html to view it in FFX. Numbers imports each item as a single row with html formatting tags in it. A simple tab (or comma) delimited file might be more convenient – or maybe there’s a way of doing this already…?
Thank you in advance for any ideas.August 5, 2010 at 12:49 am #1762AnonymousInactive
I ended up using vi and :%s/
/^M/g to put in carriage returns an replaces with commas to get it basically into Numbers.
- You must be logged in to reply to this topic.