ÇØ´ç »çÀÌÆ®¸¦ µÚÁ®º¸´Ï ¾Æ·¡¿Í °°Àº ¹ö±× ¸®Æ÷ÆÃÀÌ Àֳ׿ä.
2¹ÙÀÌÆ®ÄÚµå ¹®ÀÚ¿Àº ¾ÆÁ÷ Áö¿øÀ» ÇÏÁö ¾Ê´Â°Í °°½À´Ï´Ù.
Certain characters in text fields cause problems
If a text field contains certain characters, 'cells' returns
either a 1-character field or a 5-character field where
the first character is the first character of the Excel text
field and the remaining characters are 'alse'. For
example, if the Excel field started with 'The' then the
returned value would be 'Talse'.
I've identified the following characters as they've caused
me a problem. However, there may be others.
em dash —
en dash –
left single quote ¡®
right single quote ¡¯
left single angle quote ‹
right single angle quote ›
What I've had to do is to write an Excel macro that does
a search and replace for these characters before
uploading the spreadsheet to my web site.
I don't know enough about the logic of the class to even
guess where to look for a resolution of this problem.
2004-09-21 16:37:24 |
|