Textpattern CMS

#1 2011-10-27 15:34:13

jpdupont

Member

Registered: 2004-10-01

Posts: 752

3 problems with rcb_excel

I want to load a simple Excel sheet with the plugin. All is fine, except 3 things :

1. A “0” in a cell becomes an empty td in the table, with a  
2. All time cells like 15:30 or 14:42 becomes 01:00 in the table
3. The dd/mm/yyyy Excel date becomes an mm/dd/yyyy date in html

Has anyone ever met and corrected one of these problems?
Are there some other library to replace the one used by the plugin?

#2 2011-11-07 13:59:01

jpdupont

Member

Registered: 2004-10-01

Posts: 752

Re: 3 problems with rcb_excel

Solutions :

I debug myself and found some workaround

1. If “0” found in a cell, replace “0” with a special string. Then replace the string with “0” when building the td in the table. Bad … but work.
2. Upgrade PHP from 5.2 to 5.3 and this part is OK.
3. Modify the formating schema in the library code from mm/dd/YY to dd/mm/YY