Nick, Thank you for the fix. I will test with my files this week. Paul Spencer
On May 5, 2010, at 1:52 PM, Nick Burch wrote: > On Wed, 31 Mar 2010, Paul Spencer wrote: >>> For the long term, you should report a bug to Microsoft about this. They >>> either need to sanitise the user input and sort out the tags (eg <br> >>> becomes <br />), or they need to give up and escape the whole tag contents >>> for the bits where iffy data could get added (eg put this textbox within a >>> CDATA section) >> >> I will report the but to Microsoft, but that does not address existing files. > > Any luck getting them to agree with the fault? > >>> Medium term, we should get a list of the problem bits that Excel does wrong, >>> such as <br> (but perhaps others). Then, we need to write a XML Input >>> Wrapper >>> that cleans these up before they get passed to the XML Processor for >>> loading. >>> Something like this is quite nasty, though it's possible some other project >>> out >>> there has already done it, and we can just re-use what they do. >> >> I like this as a solution. > > Having just written code for this workaround, I really don't... It's > amazingly sick code! Seems to mostly work though, certainly for your test file > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
