Home Forums Get Help for Klok Excel export in html format?

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #965
    nidiapaschke9nidiapaschke9
    Participant

    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/201007/02/201007/03/201007/04/201007/05/201007/06/201007/07/201007/08/201007/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?

    #1761
    Anonymous
    Inactive

    Hi,

    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.

    #1762
    Anonymous
    Inactive

    I ended up using vi and :%s/

    /^M/g to put in carriage returns an replaces

    with commas to get it basically into Numbers.
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.