Chris-Tillis
New Member
- Joined
- Apr 7, 2005
- Messages
- 19
Hi all,
I hope someone can help with this.
Back Story:
I was involved in quite a severe road traffic accident a few years ago (nearly died), and now I can walk (fairly well), the solicitors have asked me to produce a complete diary of my recovery process, from crash to present day. I thought I would use a spreadsheet with a date column and description column. That way, if I forgot something, I could just add it conveniently to the bottom and then re-sort whenever I wanted. This is going to be nearly 3 years worth of notes, so it's going to become quite big.
The problem:
I created a spreadsheet in google docs, some cells have over 6000 characters (inc. spaces). While this displays OK in google docs, when I convert to XLS, it can't display all of the contents of the cell. I have used Alt-Enter to break it up a bit, but I can't find any fix beyond 'wrap text' to resolve it the display issue.
The other issue I'll have is cells printing over pages - the program will prefer to print whole cells on each page, but with my current (wrong) formatting, I don't think it'll print very nicely (when I convert to PDF).
The question:
What's best to do with this kind of data do you think? I don't want to use a Word Doc format, because when I add things that just pop into my head, I'd prefer to quickly add it to the bottom and then re-sort. I thought about adding a time column, but it's only relevant when I was having the 25 hours of surgery (spread over a month) that it's a relevant column, or when I had physio', the fun emotional breakdowns, etc.
All comments welcome and gratefully received.
Cheers,
Chris
I hope someone can help with this.
Back Story:
I was involved in quite a severe road traffic accident a few years ago (nearly died), and now I can walk (fairly well), the solicitors have asked me to produce a complete diary of my recovery process, from crash to present day. I thought I would use a spreadsheet with a date column and description column. That way, if I forgot something, I could just add it conveniently to the bottom and then re-sort whenever I wanted. This is going to be nearly 3 years worth of notes, so it's going to become quite big.
The problem:
I created a spreadsheet in google docs, some cells have over 6000 characters (inc. spaces). While this displays OK in google docs, when I convert to XLS, it can't display all of the contents of the cell. I have used Alt-Enter to break it up a bit, but I can't find any fix beyond 'wrap text' to resolve it the display issue.
The other issue I'll have is cells printing over pages - the program will prefer to print whole cells on each page, but with my current (wrong) formatting, I don't think it'll print very nicely (when I convert to PDF).
The question:
What's best to do with this kind of data do you think? I don't want to use a Word Doc format, because when I add things that just pop into my head, I'd prefer to quickly add it to the bottom and then re-sort. I thought about adding a time column, but it's only relevant when I was having the 25 hours of surgery (spread over a month) that it's a relevant column, or when I had physio', the fun emotional breakdowns, etc.
All comments welcome and gratefully received.
Cheers,
Chris