[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

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

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:

[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

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:

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] 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/SO Calc

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 have

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

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 be

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 the