Hi Daniel, On Tue, 2007-08-21 at 08:12 +0200, Daniel Rentz wrote:
> The formula =A1 will return the > main text only, Correct. > and the formula =PHONETIC(A1) will return the phonetic > text only. This is incorrect. It will return the ruby text and the text that is raw Japanese alphabet (Hiragana's or Katakana's). This means that, if the main text contains the mixture of Kanji characters and the alphabets, it will return the main text with only the Kanji part translated into its ruby representation. > Formula cells with text results will never contain phonetic > text information, so if you have the formulas above in cell A2 and A3, > and call =PHONETIC(A2) and =PHONETIC(A3) in other cells, the result will > be an empty string in both cases. Also correct. This was not what I was talking about however. It seems that I mis-understood Niklas' question. My discussion was centered around the raw string class level, not at the high-level cell class level. > > >> That would be consistent with XHTML > >> ruby markup, but different from Excel. > > > > Is that really different from Excel? Because Excel is where the idea of > > embedding the ruby into the raw text string came from. > > As mentioned, only in text cells, not at all places where strings are > used, such as formula results. Yes, but I thought we were already talking about just the string cells in our discussion, not formula cells. Again, I think I've mis-understood Niklas' question. What I meant to say was that Excel embeds the ruby text directly into string data in the shared string table, instead of storing it as a cell attribute. Kohei --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
