Re: Our plan to improve Calc functionality related tophonetic text

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/2
006/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: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org