Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01

2008-03-18 Thread Kohei Yoshida
On Tue, 2008-03-18 at 22:28 +0100, Eike Rathke wrote: > Hi Kohei, > > On Monday, 2008-03-17 21:23:11 -0400, Kohei Yoshida wrote: > > > > [... separators at ScAddress::Convention ...] > > Well, that code was implemented before ScGrammar arrived in DEV300_m2. > > So, I couldn't have used ScGrammar

Re: Re: [sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Lvyue
Hi Eike, Thanks for your fast reply. :) For i86643, I restrict the precondition to errNoName, because I found if there is an illegal param in the list and not the last one, and also empty cell or range in the list. the result will be 1 more than the right number. For example, COUNTA( ; F5 )=

Re: [sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Eike Rathke
Hi Yue, On Tuesday, 2008-03-18 15:07:56 +0800, Lvyue wrote: > I began to work on issue78781 yesterday. Fine, thanks. > Compared with Excel, I found there are two things I should modify. > > 1. while input: =INDEX($D$27:$P$27;2) > the result should be value of E27. Correct. For a row vector th

Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01

2008-03-18 Thread Kohei Yoshida
On Tue, 2008-03-18 at 22:37 +0100, Eike Rathke wrote: > Hi Kohei, > > On Tuesday, 2008-03-18 14:13:43 -0400, Kohei Yoshida wrote: > > > I'd like to make sure one thing before I go with this. It seems to me > > that, if we tie the separators to ScCompiler::mxSymbolsNative, then it > > will not b

Re: [sc-dev] Spec. for Solver?

2008-03-18 Thread Eike Rathke
Hi Stefan, On Tuesday, 2008-03-18 17:15:29 +0100, Stefan Weigel wrote: > Niklas, can you join this thread? :-) Niklas is on vacation. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8

Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01

2008-03-18 Thread Eike Rathke
Hi Kohei, On Tuesday, 2008-03-18 14:13:43 -0400, Kohei Yoshida wrote: > I'd like to make sure one thing before I go with this. It seems to me > that, if we tie the separators to ScCompiler::mxSymbolsNative, then it > will not be possible to switch between the Excel style separators and > the con

Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01

2008-03-18 Thread Eike Rathke
Hi Kohei, On Monday, 2008-03-17 21:23:11 -0400, Kohei Yoshida wrote: > > [... separators at ScAddress::Convention ...] > Well, that code was implemented before ScGrammar arrived in DEV300_m2. > So, I couldn't have used ScGrammar at the time I implemented. Understood. > Of course now that we hav

Re: [sc-dev] OFFSET in array formulae

2008-03-18 Thread Eike Rathke
Hi David, On Monday, 2008-03-17 21:23:07 +, David King wrote: > On the other hand ;) in Calc {=ISLOGICAL({TRUE;"cat";"dog"})} > returns {FALSE;TRUE;TRUE} > > Can I raise that one as an issue? Can't be right, can it? That indeed is a bug, please file an issue. Thanks Eike -- OOo/

[sc-dev] XFrameActionListener - COMPONENT_REATTACHED event has no current sheet ?

2008-03-18 Thread Oliver Brinzing
Hi, I added a XFrameActionListener to a spreadsheet document. If a user changes for example from "Tabelle3" to the print preview (in german: "Seitenansicht") and back the last frameAction(FrameActionEvent evt) i get is: "COMPONENT_REATTACHED" At this point it seems not to be possible to get t

Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01

2008-03-18 Thread Kohei Yoshida
Hi Eike, On Mon, 2008-03-17 at 12:29 +0100, Eike Rathke wrote: > They should be merged into the SymbolsNative map > instead. I'd like to make sure one thing before I go with this. It seems to me that, if we tie the separators to ScCompiler::mxSymbolsNative, then it will not be possible to switch

Re: [sc-dev] Spec. for Solver?

2008-03-18 Thread Stefan Weigel
Thanks again, Frank. Frank Loehmann schrieb: The item is defined in section 1.4.2 (Item #3). I think Niklas (NN) could describe the functional behavior behind this setting if needed. Niklas, can you join this thread? :-) specification here: http://specs.openoffice.org/calc/features/Solver.

[sc-dev] label and array formula

2008-03-18 Thread Mathias Röllig
Hello! Should using labels work also in a array formula? Today it doesn't. E. g. having a column labelled 'Result'. =SUM('Result') works. But {=SUM('Result'>0)} doesn't work. The results (error or 0) differs, if i insert label ranges (Insert\Names\Labels...) or not. Should i file a issue? I ha

Re: [sc-dev] Spec. for Solver?

2008-03-18 Thread Frank Loehmann
Hi Stefan, The item is defined in section 1.4.2 (Item #3). I think Niklas (NN) could describe the functional behavior behind this setting if needed. Best regards, Frank Stefan Weigel wrote: Hi Frank, Frank Loehmann schrieb: specification here: http://specs.openoffice.org/calc/features/S

Re: [sc-dev] Spec. for Solver?

2008-03-18 Thread Stefan Weigel
Hi Frank, Frank Loehmann schrieb: specification here: http://specs.openoffice.org/calc/features/Solver.odt Thank you, for your help. Unfortunately the Sepc does not define "Epsilon Level" used by the implemented algorithm. Can you point me to a definition? Gruß Stefan -

[sc-dev] 'TAB' key

2008-03-18 Thread YunJingtao
hi, all Can someone tell me how 'TAB' key works? Bug phenomenon can be described as follows: 1.open one new Calc 2.create more than one scenario 3.invoke navigator 4.click Scenarios button 5.click 'TAB' key continuously, you can find that the cursor skips the scenario na

Re: [sc-dev] Spec. for Solver?

2008-03-18 Thread Frank Loehmann
Hi, The solver will be introduced with OOo 3.0. You can find the specification here: http://specs.openoffice.org/calc/features/Solver.odt Best regards, Frank Stefan Weigel wrote: Gruess Gott, where can I find the Specification for the Solver, that is coming up in OOo 3.0? TIA Stefan :

[sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Lvyue
Hi Eike, I began to work on issue78781 yesterday. Compared with Excel, I found there are two things I should modify. 1. while input: =INDEX($D$27:$P$27;2) the result should be value of E27. 2. while input: =INDEX(($D$27:$P$27;$D$29:$P$29);2) the result also should be value of E27. so I made so