Hi Daniel, On Tue, 2008-04-01 at 10:48 +0200, Daniel Rentz wrote: > Hello Kohei, Eike, all, > > > for public interest, I post my knowledge about formula separators in MS > Excel into the mailing list... > > After some testing with different Excel versions with different UI > languages (3.0 German, 4.0 German, 5.0 German, 2003 English and German, > 2007 English) in combination with different system locales (German, > English, French, Japanese), I think it works following the rules below.
[snip the detailed description of how Excel treats separators] Thanks for this detailed information. As always, your research is very thorough. I really appreciate this. :-) I'll probably put that in for the next iteration of this work (probably koheiformula02?). > Conclusion: This is a big mess, and I want to see fixed > separators... ;-) Yeah it is a mess, and is indeed bad news for us developers. :-) Having said that, it is doable and when done right, the mess of this intricate separator differentiation can be contained in one place. For the implementation that I did, I put a hook in ScOpCodeList to do the switching, and in client code we can query the separators via ScCompiler::GetStringFromOpCode( OpCode eOp ) call. Since that call is static, it can be called anywhere within sc. I've already replaced most of hard-coded separators that I could find with the above ScCompiler call. There may be more lurking somewhere, but we can replace them as we go. Also, with Eike's ScGrammar work, we can readily switch between fixed separators and localized separators, for people who want the conventional-style fixed separators. Kohei -- Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc. <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
