Excel Import

[Bobby Wise]

I have Grades 5, 6 and 7 Home Class (Groups) a, b, c, d and e. After generating the timetable I open all_activities_timetable_time_vertical in excel to edit the printout.

It seems that excel automatically converts groups 5a, 6a and 7a as 05:00 AM, 06:00 AM and 07:00 AM

Thanks for an excellent program.

[Liviu Lalescu]

Maybe you could try to open with OpenOffice.org.

I don't know why this bug appears, maybe Volker will tell us more.

[Volker Dirr]

I can't check that currently, because i haven't excel at home. so i can check only in school.

i guess it is not a bug. i guess it is a feature of excel.

i think excel automaticly try to identify the datatype of the cell.
default datatype of a cell is a string, but execl try to identify if you wrote a "special" string and convert the datatyp.

please do a right mouse click on that cell and have a look about the datatype of the cell (sorry, i don't know the correct excel termns, because i can't check it here.) There should be a list where you can choose between "time", "number", "date", "text" ,... . please change from "time" to "text".

so if that work you can just click the emtpy grey cell, that is over line number 1 and left from row A. so you select all cells. do a right click with the mouse again and change datatype string /text to all cells.

if that is the bug, please try this:
open a new sheet and write "5a" into a cell and press enter. do excel also convert that string automaticly in a time?
if the answer is yes, then please check your global execl settinngs. there must be somewhere an option to disable automatic data type detection of a cell.

please try to reload a timetable and have a look if it is converted "incorrect" again.
if it is still converted "incorrect" (but you can change manualy), then you must report this bug to excel. ask them how to turn of automatic data type detection.
I can't write the datatype into the html file.

Addendum:
if you want to style the sheets, then use the css file.
you got less problems by that and it is much faster to do that work by css.

[Bobby Wise]

Thanks for the help.

It is not really a problem for me but you have asked us to report any bugs so I thought you might want to know.

[Volker Dirr]

ah. ok. please report every bug.

is my "solution" working?