FET Forum

FET Support (English) => Get Help => Topic started by: dimzev on October 03, 2020, 07:27:02 PM

Title: XTML (teachers.time.horizontial) convert to libreoffice calc
Post by: dimzev on October 03, 2020, 07:27:02 PM
Congratulations for FET!!!!!
Is there a way to convert a file "teachers.time.horizontial.html" to a libreoffice calc ?
I use linux and i can use python3 if need it.
Thank you!!!

Title: Re: XTML (teachers.time.horizontial) convert to libreoffice calc
Post by: Volker Dirr on October 03, 2020, 09:23:54 PM
You can open it with LibreOffice calc. LibeOffice can convert html files.
Title: Re: XTML (teachers.time.horizontial) convert to libreoffice calc
Post by: Vangelis Karafillidis on October 04, 2020, 06:54:06 PM
Hello!
I think that generally speaking applications such as LibreOffice Calc should be able to import html files. Unfortunately, LibreOffice Calc seems to misinterpret the structure of the html files generated by FET. The result is not correct... Maybe, modifying the default settings for LibreOffice Calc (regarding html file importing) could be a solution. But, I think that since there is a default setting, there must be some reason, i.e. this default setting might work well in most cases. So, I don't think that changing the default settings of LibreOffice Calc is a good solution.
There is another much easier solution. Please install Gnumeric. This is another open source spreadsheet application. The default settings of Gnumeric interpret very accurately the structure of the html files generated by FET. Then, you can save the spreadsheet as an xls or ods file, open the xls or ods file with LibreOffice Calc and edit it (LibreOffice Calc seems to be more feature rich than Gnumeric!).
Vangelis.

Title: Re: XTML (teachers.time.horizontial) convert to libreoffice calc
Post by: dimzev on October 04, 2020, 07:58:14 PM
In the past (last try before 5-6 days) when I tried to open the html file with libreoffice  them it would place all the data of from a row html  in a cell libreoffice and this was problem .
After the answer from Volker Dirr i try again and all was perfect...in the sart give me a choice , i selct auto and all be perfect!!!!
I dont understand why this happen...
In the future if have problem again i will try the solution from Vangelis Karafillidis.
Now is so simple and fast...
Thank you !!!!
Title: Re: XTML (teachers.time.horizontial) convert to libreoffice calc
Post by: Vangelis Karafillidis on October 05, 2020, 01:13:20 PM
It seems that I use an older version of LibreOffice Calc! I had many problems with the version I used. Maybe, the latest version handles the html files correctly. Really good news!
Vangelis.