Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Takashi Nakamoto
On Tue, 21 Aug 2007 13:39:36 +0200 Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Takashi, > > On Tuesday, 2007-08-21 13:34:18 +0900, Takashi Nakamoto wrote: > > > > > Switching routine that choose one class from the four > > > > classes for creating an instance of a cell would be complex. > > > >

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Takashi Nakamoto
On Tue, 21 Aug 2007 14:50:15 +0200 Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Kohei, > > On Tuesday, 2007-08-21 08:35:41 -0400, Kohei Yoshida wrote: > > > IIRC, if the text cell doesn't contain any phonetic text, it will > > back-translate it into ruby using the IME if the main text contains an

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread tora - Takamichi Akiyama
Hi Eike, Your idea, a factory pattern and Run-Time Type Information (RTTI), will certainly work well. Another idea, a phonetic guide text included in OUString, may be one of the possible ideas. Kohei gave us a practical, experimental way of implementation at http://sc.openoffice.org/servlets/Read

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread tora - Takamichi Akiyama
Hi, Thanks to the Kohei's good example, I have made a similar example of Excel 2003 binary format. See an example of i80764. A base text is followed by a phonetic guide text. When a user fills a cell with a text, Excel Japanese version seems to always append a phonetic guide text even though a t

[sc-dev] Sort-Dialog and Print-Dialog

2007-08-21 Thread Leonard Mada
Hi, I have filed 2 issues describing two reworked/refactored Spreadsheet-Dialogs: - *Sort*-Dialog: see issue 80661 (http://www.openoffice.org/issues/show_bug.cgi?id=80661) - *Print*-Dialog: see issue 80588 (http://www.openoffice.org/issues/show_bug.cgi?id=80588) I miss the '*Range contains c

Re: [sc-dev] i20496 : Enhanced formula input

2007-08-21 Thread Leonard Mada
Hi Thomas, Nice specification. I think it covers all major use-cases and most important it covers them well. [One can argue about phone-numbers (+nn-nnn-nn...nn) but I have no single idea how to handle them consistently. Maybe IF the cell-type (from 'Format cells' -> 'Numbers' -> 'Category'

Re: [sc-dev] i20496 : Enhanced formula input

2007-08-21 Thread Thomas Benisch
Please note, that I updated the specification at http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt Although the question which user input is converted into a formula is quite controversial, I tried to include the most important comments into the specification. In a nutshel

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Daniel Rentz
Eike Rathke schrieb: 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?

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Kohei Yoshida
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.

Re: [sc-dev] Our plan to improve Calc functionality related tophonetictext

2007-08-21 Thread Kohei Yoshida
On Tue, 2007-08-21 at 14:53 +0200, Niklas Nebel wrote: > 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. > > Just like text formats within the cell. :-) I have

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Kohei Yoshida
On Tue, 2007-08-21 at 14:50 +0200, Eike Rathke wrote: > Hi Kohei, > > On Tuesday, 2007-08-21 08:35:41 -0400, Kohei Yoshida wrote: > > > IIRC, if the text cell doesn't contain any phonetic text, it will > > back-translate it into ruby using the IME if the main text contains any > > Kanji character

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
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? Eike -- OOo/S

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Niklas Nebel
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. Just like text formats within the cell. :-) Niklas

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
Hi Kohei, On Tuesday, 2007-08-21 08:35:41 -0400, Kohei Yoshida wrote: > IIRC, if the text cell doesn't contain any phonetic text, it will > back-translate it into ruby using the IME if the main text contains any > Kanji characters, then return that ruby text to replace the Kanji > characters in t

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Kohei Yoshida
On Tue, 2007-08-21 at 08:22 +0200, Daniel Rentz wrote: > While I am playing with that... If a text cell does not contain phonetic > text, the PHONETIC function call returns the main text instead of an > empty string. IIRC, if the text cell doesn't contain any phonetic text, it will back-transl

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Kohei Yoshida
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 (

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
Hi Takashi, On Tuesday, 2007-08-21 13:45:53 +0900, Takashi Nakamoto wrote: > > > 3) Store that as a cell attribute. If I understand correctly, Writer > > > uses this approach. > > > > That sounds easiest from a first glance, but it dissects content into > > attribution, which sooner or later wi

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
Hi Takashi, On Tuesday, 2007-08-21 13:34:18 +0900, Takashi Nakamoto wrote: > > > Switching routine that choose one class from the four > > > classes for creating an instance of a cell would be complex. > > > > I don't think so. You need to distinguish anyway, and subclassing may > > actually eas

Re: [sc-dev] cursor problem

2007-08-21 Thread yunjingtao
Hi, Kazunari Hirano I have checked the attachment(47646 and 47649).In the 47649,I tried in the cell and in the box on the formular bar but I found something different. In the cell(C5, C6, C7,C8, C12, C13, C14, C15, C16and C17) I can locate the cursor by mouse .But in the box on the formular bar t