On Tue, Aug 21, 2007 at 09:20:18AM -0400, Kohei Yoshida wrote: > On Tue, 2007-08-21 at 14:56 +0200, Eike Rathke wrote: > > Hi Kohei, > > > > On Tuesday, 2007-08-21 08:12:13 -0400, Kohei Yoshida wrote: > > > > > 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. > > > > As part of the string? How is it distinguished? > > It is tagged, of course. I'm not sure how it's distinguished in the > BIFF format, but talking with Jody a while back, he seems to have said > that there is always extra blobs appended to the normal string data when > importing a Japanese XLS file. > > As for the OOXML file, the texts with ruby are represented as follows. > > <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"; > count="2" uniqueCount="2"> > <si> > <t>????????????</t> > <rPh sb="0" eb="2"> > <t>?????????</t> > </rPh> > <rPh sb="2" eb="4"> > <t>????????????</t> > </rPh> > <phoneticPr fontId="1"/> > </si> > > And this appears inside the sharedStrings.xml fragment. > > So, the ruby text is clearly distinguished from the main text, but it is > still within the same string entry.
Unsuprisingly, the BIFF format uses almost exactly the same arrangement as OOX. All strings have some header bits that allow the addition of trailing phonetic data and richtext markup. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
