I have an excel file of a year to view calendar of events which I would like to display on a site. I don't really know how to do it but I saved it as an htm file and copied the source code into a "chunk" and then placed the {{name}} in my page. It seemed to work until I tried putting a link from one of the excel cells to another page or url (and I need to do that). Then all the formatting, colour etc was lost leaving only the bare text. It looks awful! There must be an easier way or would anyone know what I am doing wrong? I have spent days at this and would be most grateful for any ideas.
Thank you so much in grateful anticipation!
Eamonn
Did you create the html file with MS Excel?
How did you add the link - specifically did it involve a wysiwyg editor?
And the version of MODX you are using and other details?
Hello,
Thanks for getting back to me some time ago on this.
I created the file in MS Excel. I added the link using the TinyMCE editor.
I am using MODx version 1.0.5. I'm not sure what other info I can give or how to access it. I have looked under Reports and System Info.
Many thanks, Eamonn
This is an educated guess about what happened (I can't check because I do not have MS excel and I use MODX revolution not evo):
MS Excel will create html with inline styling and I am guessing tables (which in fact is reasonable for the usual content of a spreadsheet)
TinyMCE editor is very good at removing what it thinks is un-needed tags, comments etc (and also adding tags)
Since I do not have a suggestion for easily getting some spreadsheet data into a page - and the fact that 'it worked' I would suggest the easiest solution is to add links without TinyMCE.
Note that TinyMCE will alter some html just by viewing it - so when you click the 'toggle editor' button sometimes the damage is already done - my solution is to click the button and then reload the page.
