Re: [sc-dev] issue10755

2008-01-17 Thread Daniel Rentz
Hello, > This morning seeing the status and resolution of Issue3866 were changed to > resolved > and wontfix, I read them as it needn't fix now, so today I begin to fix the > issu10755. > So simple the description of the issue10755 is that it is difficult for me > to reproduce > the wrong

Re: [sc-dev] issue10755

2008-01-21 Thread Daniel Rentz
YunJingtao schrieb: > hi, Daniel > Do you mean that I should use ListBox instead of ComboBox? Sorry, ComboBox is correct, no need to change this (I didn't check what class is used in the dialog). Daniel - To unsubscribe, e-mail

Re: [sc-dev] another problem related i10755

2008-01-25 Thread Daniel Rentz
YunJingtao schrieb: > hi, Daniel > Same phenomenon happens when Define Range(Data->Define Range). They > are all related to ScrollBar. What should we do next? Hello the dialog should behave correctly for all functions (Add, Remove, Modify). Are there other places where the name list is cleared a

Re: [sc-dev] another problem related i10755

2008-01-29 Thread Daniel Rentz
YunJingtao schrieb: > > Yes.Following these steps Data-Define Range, you can find that the dialog > are the same and the same mistakes. > According to your advice, I try to fix the function UpdateNames() and add > some code. > at the begining: > //aEdName.Clear(); > String aNewEntry = aEdN

Re: [sc-dev] RATE function; issue 15090

2008-02-11 Thread Daniel Rentz
ents with link for gperf http://gnuwin32.sourceforge.net/packages/gperf.htm That is the version 3.0.1. Daniel Rentz told me that gperf is needed for the module oox and writerfilter. Yes, unfortunately (for Windows users) that had been introduced as a new requirement. configure stops with a err

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

2008-04-01 Thread Daniel Rentz
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 combina

Re: [sc-dev] purpose of scaddins gamma function

2008-04-08 Thread Daniel Rentz
Regina Henschel schrieb: Hi, there exist methods double ScInterpreter::GammaHelp(double& x, BOOL& bReflect) and double ScInterpreter::GetGamma(double x) in sc/source/core/tool/interpr3.cxx The same code exists as functions double GammaHelp( double& x, sal_Bool& bReflect ) and do

Re: [sc-dev] three issues

2008-04-21 Thread Daniel Rentz
Eike Rathke schrieb: Hi YunJingtao, On Tuesday, 2008-04-15 09:43:32 +0800, YunJingtao wrote: hi, Daniel As you Cc'ed Daniel's personal account I assume that he answered directly, as usual. However, for transparency I'd prefer if people didn't Cc personal accounts if the receiver reads the ma

Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer <> OOO

2008-04-25 Thread Daniel Rentz
Eike Rathke schrieb: Hi Cor, On Thursday, 2008-04-17 10:10:19 +0200, Cor Nouws wrote: Easy to fix as you suggested. Only saving as xls and re-opening, again shows #NA ... Saving as ods does save the results. It seems that interim results of external references aren't saved to Excel file for

[sc-dev] Vacation

2008-04-25 Thread Daniel Rentz
Hello all please note that I am on vacation for the next 3 weeks. I will be back on May 19th. Daniel -- Sun Microsystems GmbH Nagelsweg 55 20097 Hamburg Germany Sitz der Gesellschaft: Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schro

Re: [sc-dev] issue 57772: some function are exported with German names

2008-05-21 Thread Daniel Rentz
sophie schrieb: Hi Daniel, This issue is targeted for 3.0 http://www.openoffice.org/issues/show_bug.cgi?id=57772 Could you please confirm that the target milestone is still 3.0 (this is an important issue for several customers ;) as there has not been much activity on it since almost two year

Re: [sc-dev] about issue86945

2008-06-30 Thread Daniel Rentz
yunjingtao schrieb: > hi, Daniel > the code below is based on DEV300_M20. I made some changes like this : > ScScenarioWindow::ScScenarioWindow( Window* pParent,const String& aQH_List, > const String& aQH_Comment) > :Window( pParent , WB_DIAL

Re: [sc-dev] about issue86945

2008-07-01 Thread Daniel Rentz
yunjingtao schrieb: > Daniel wrote: >> The aEdComment gets the focus though you do not pass WB_TABSTOP to >> its c'tor? > > hi, Daniel Thank you for you reply. Yes, exactly. The aEdComment gets > the focus, I think the reason is because of WB_DIALOGCONTROL | > WB_TABSTOP in ScScenarioWindow constr

Re: [sc-dev] About issue25018

2008-07-14 Thread Daniel Rentz
yunjingtao schrieb: > hi, Daniel > I submitted a patch to issue25018. Using some test cases, I checked > it, and it's ok. Hope you review it, and if possible,give me some > advice. If there is no problem with it, assign me issues please. > I have one question and wish you answer it at your conven

Re: [sc-dev] About issue25018

2008-07-17 Thread Daniel Rentz
yunjingtao schrieb: > Daniel schrieb: >> Please do not rely on the item state only, but test the contents of the >> item too. See the example for the FID_MERGE_TOGGLE item in the same >> file: the test " ... >= SFX_ITEM_DEFAULT " >> makes sure that the item exists (it has state "DEFAULT" or "SET")

Re: [sc-dev] macro fails with oo 3.0 - returns byte instead of string array !

2008-07-17 Thread Daniel Rentz
Oliver Brinzing schrieb: Hi, are there any known issues with the basic engine in oo 3.0 ? i tried m23/m25 with same results ... i have code *similar* to the snippet below, which will filter Named Ranges of a calc document, for example all Named Ranges starting with "X_XXX" ... it will return an

Re: [sc-dev] macro fails with oo 3.0 - returns byte instead of string array !

2008-07-21 Thread Daniel Rentz
Oliver Brinzing schrieb: Hi Daniel, But I'm not an expert, and as the code below is not specific to the Calc API, you probably should ask on the [EMAIL PROTECTED] or [EMAIL PROTECTED] mailing list. i found out what is going wrong, just run the new example ... i think this is a bug ... can yo

Re: [sc-dev] How to use erfc() or getErfc() from scaddins in sc ?

2008-08-04 Thread Daniel Rentz
Kohei Yoshida schrieb: Hi Regina, On Sun, 2008-08-03 at 18:53 +0200, Regina Henschel wrote: Hello, I'm writing a function, which is local in interpr3.cxx. For this function I need erfc() or getErfc() from scaddins. How to get it? Looks to me like the easiest way to get there is via UNO call

Re: [sc-dev] How to use erfc() or getErfc() from scaddins in sc ?

2008-08-05 Thread Daniel Rentz
Hi Regina, Regina Henschel schrieb: Hi Daniel, hi Kohei, I've learned now, that I can get erfc(z) by GetUpRegIGamma(0.5,z^2), so I need no copy&paste. GetUpRegIGamma is a private function of ScInterpreter, in file interpr6.cxx. But now I have the next problem: The structure now is: We have

Re: [sc-dev] start issue92313

2008-08-06 Thread Daniel Rentz
yunjingtao schrieb: > hi, Daniel > can you explain these > SFX_STYLE_FAMILY_CHAR > SFX_STYLE_FAMILY_PARA > SFX_STYLE_FAMILY_FRAME > SFX_STYLE_FAMILY_PAGE > to me? Open a Writer document and the Stylist (Format->Styles or key F11). On top you see different buttons for different types of styles for

Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-07 Thread Daniel Rentz
Cor Nouws schrieb: Hi Eike, Solution would be to always generate an error in such case. You mean an error if an formula holds an non numeric argument. This is the same as Excel does, 'only' with this difference that Excel in some formulas uses text that can be interpreted as number, and in

Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-07 Thread Daniel Rentz
Cor Nouws schrieb: Hi Daniel, Also there seems little reason to think that other Excel-versions (7/95, 8/97, 9/2000, 10/XP) behave different. Exactly :-) Daniel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional com

Re: [sc-dev] Multiline formulae support

2008-08-08 Thread Daniel Rentz
Hi, Eike Rathke schrieb: Some potential issues: - Compatibility with Excel possibly needs discussing. We've not been compatible with Excel in the past and this patch does not make it 100% compatible, rather it improves compatibility, and improves further where Excel gets it wrong IMHO. I

Re: [sc-dev] Multiline formulae support

2008-08-08 Thread Daniel Rentz
Eike Rathke schrieb: Hi Daniel, On Friday, 2008-08-08 09:29:23 +0200, Daniel Rentz wrote: As Excel does not support multiline formula results, chances are low that there are many Excel documents really using '\n' in formula results. Excel does support multiline formula results

Re: [sc-dev] Calc Autoformatting Error

2008-08-11 Thread Daniel Rentz
Leonard Mada schrieb: Hello everyone, I try to enter in a Calc cell: Diabetes mellitus Typ IIb but the last part gets converted automatically to "Typ Iib". How do I undo this? This is obvious a serious bug. Why does Calc autoformat something it is NOT supposed to do? try to uncheck Tools

Re: [sc-dev] Calc Autoformatting Error

2008-08-11 Thread Daniel Rentz
Leonard Mada schrieb: Hi Daniel, Thank you. Indeed, this did it. [I must say I did search up and down through the Options Dialog for a suitable option at no success.] Though I still miss an UNDO option in the context menu. I don't miss it, for me ALT+BS is much faster ;-) Daniel ---

Re: [sc-dev] Calc Autoformatting Error

2008-08-13 Thread Daniel Rentz
Hi Leonard, Leonard Mada schrieb: The ALT+BS did not UNDO the auto-FORMATTING! Did I miss something? I just figured out that it does not undo the auto correction if you leave the cell, e.g. by typing ABc + ENTER + Undo. It works only if you continue to type in the cell, e.g. ABc + SPACE + U

Re: [sc-dev] xy-chart

2008-08-13 Thread Daniel Rentz
Niklas Nebel schrieb: On 08/12/08 16:49, Erich Neuwirth wrote: I just imported an xls sheet with an xy-chart and notices that the chart treats the data differently. In Excel, empty lines in columns for xy-charts have the effect of penup, so you can draw multiple unconnected sequeces of lines w

Re: [sc-dev] About issue40679

2008-08-13 Thread Daniel Rentz
yunjingtao schrieb: > hi,Daniel I know that KEY_MOD1 is related to key CTRL, KEY_MOD2 is to > ALT, but I don't know KEY_MOD3, KEY_MODTYPE, and KEY_ALLMODTYPE, can > you tell me? Don't know KEY_MOD3, there may be operating systems supporting more modifiers. KEY_MODTYPE and KEY_ALLMODTYPE are equal

[sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-08-29 Thread Daniel Rentz
Hi Kohei some thoughts about the new ExternalDocLinks API in CWS mooxlsc... First, there is no documentation in the IDL files, please consider to add some ;-) I think, a cleaner way to implement the service ExternalDocLinks is to make it a container, i.e. to support the interfaces XNameAcce

Re: [sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-08-29 Thread Daniel Rentz
Kohei Yoshida schrieb: Hey Daniel, On Fri, 2008-08-29 at 09:29 +0200, Daniel Rentz wrote: Hi Kohei some thoughts about the new ExternalDocLinks API in CWS mooxlsc... First, there is no documentation in the IDL files, please consider to add some ;-) Well, real men use code as the

Re: [sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-08-29 Thread Daniel Rentz
Kohei Yoshida schrieb: On Fri, 2008-08-29 at 09:29 +0200, Daniel Rentz wrote: To do: do we need API to remove something from the cache, or an entire cache, or even an entire external linked document? I don't think it makes sense to add API to remove individual cell cache from a table, si

Re: [sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-09-03 Thread Daniel Rentz
Hello Kohei looking at XExternalSheetCache::[sg]etCellValue(), I suggest to swap the parameters nRow and nColumn, because cell addresses are passed around in the entire sc module that way, and it is the member order in com::sun::star::table::CellAddress. Daniel

Re: [sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-09-03 Thread Daniel Rentz
Daniel Rentz schrieb: Hello Kohei looking at XExternalSheetCache::[sg]etCellValue(), I suggest to swap the parameters nRow and nColumn, because cell addresses are passed around in the entire sc module that way, and it is the member order in com::sun::star::table::CellAddress. ... see also

Re: [sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-09-03 Thread Daniel Rentz
Hi Kohei, some more thoughts... :-) Do we really need the "SheetName" string member in the "ExternalReference" struct? How about transporting the index of the cache in the "Sheet" member of the SingleReference/ComplexReference? The index should be available as attribute in XExternalSheetCache

Re: [sc-dev] About the ExternalDocLinks API in CWS mooxlsc

2008-09-03 Thread Daniel Rentz
Hi Kohei, for the XExternalDocLink::TokenIndex attribute, we should assure in the documentation and implementation that the returned index can be used to access that cache via the XIndexAcess interface of the ExternalDocLink container. That would be needed if sometimes an export filter for fo

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-09-25 Thread Daniel Rentz
Lvyue schrieb: > Hi, Daniel > I'm working on the new function EUROCONVERT(), > and now I come to the Excel import/export part. > because Excel has this function already, > so I want to add it to the corresponding XclFunctionInfo table in > xlformula.cxx. > but I don't know much about that, can y

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-10-17 Thread Daniel Rentz
Lvyue schrieb: > Hi, Daniel > I have add what you advised in sc/source/filter, > a new book type in xllink.hxx, > in xilink.cxx, XclImpSupbook::XclImpSupbook(), > a new type in enum XclImpExtNameType (and set it in > XclImpExtName::XclImpExtName() ), > and I also add a case for the new xlExt***

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-10-21 Thread Daniel Rentz
lvyue schrieb: Hi, Daniel Thanks for your reply, and sorry I did not reply on time, there is something wrong with my mail box. and I have attached a diff in issue 93789, http://www.openoffice.org/issues/show_bug.cgi?id=93789 can you check it and tell me where is wrong? Found the problem... See

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-10-21 Thread Daniel Rentz
Daniel Rentz schrieb: case T_Ext: { UINT16 n = pElement[ nId ]; EXTCONT* p = ( n < nP_Ext )? ppP_Ext[ n ] : NULL; if( p ) + { + if( p->eId == ocExternal ) Oh no, there is a typo, it has to be: + if( p->eId == ocEuroConv

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-10-31 Thread Daniel Rentz
Lvyue schrieb: Hi, Daniel I have been struggling with the export part for several days, but I can not make it work nicely. I studied the codes, I think a document with this formula is very similar to a document with external files, the difference is that we don't have anything to do with conten

[sc-dev] Application modules become dependent from module oox?

2008-11-21 Thread Daniel Rentz
Hello, with some surprise I have seen hundrets of check ins in the CWS ooxml02 with the goal to implement OOXML export filters. For Calc this seems to be done by extending the binary BIFF export filter. As it looks this makes it necessary to export headers from and linking against oox thus ma

Re: [sc-dev] Application modules become dependent from module oox?

2008-11-21 Thread Daniel Rentz
Jonathan Pryor schrieb: On Fri, 2008-11-21 at 11:57 +0100, Daniel Rentz wrote: with some surprise I have seen hundrets of check ins in the CWS ooxml02 with the goal to implement OOXML export filters. For Calc this seems to be done by extending the binary BIFF export filter. As it looks this

Re: [sc-dev] Application modules become dependent from module oox?

2008-11-21 Thread Daniel Rentz
Daniel Rentz schrieb: Jonathan Pryor schrieb: On Fri, 2008-11-21 at 11:57 +0100, Daniel Rentz wrote: with some surprise I have seen hundrets of check ins in the CWS ooxml02 with the goal to implement OOXML export filters. For Calc this seems to be done by extending the binary BIFF export

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-11-24 Thread Daniel Rentz
lvyue schrieb: hi Daniel, Sorry to disturb you again. I have added some functions in the classes you mentioned in last mail( you can see them in the patch 4 of issue 93789 ). http://www.openoffice.org/issues/show_bug.cgi?id=93789 but it works stranger, now, after export, and when open again, th

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-11-25 Thread Daniel Rentz
Daniel Rentz schrieb: lvyue schrieb: Hi Daniel, I made the changes you suggested, but it doesn't work. it is still "=NA()" I'm tracing the code, but I didn't get any clue yet. If you have findings, please tell me, thank you. Try to find where compiling the formula

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-11-25 Thread Daniel Rentz
lvyue schrieb: Hi Daniel, I made the changes you suggested, but it doesn't work. it is still "=NA()" I'm tracing the code, but I didn't get any clue yet. If you have findings, please tell me, thank you. Try to find where compiling the formula breaks. The N/A error is an indicator for an err

Re: [sc-dev] *.xls import: formula =Cell("Zeile") is broken

2008-11-26 Thread Daniel Rentz
Oliver Brinzing schrieb: Hi, just recieved an excel file with a formula like this: =DATUM($G$1;MONAT(A$3);((ZELLE("ZEILE";A4))-3)) OO displays Err:502, cause the argument "Zeile" should be "row" ... is it possible to fix the import or localize the arguments ? Instead of using ZELLE("ZEILE";

Re: [sc-dev] Rebasing CWS odff05

2008-11-26 Thread Daniel Rentz
Eike Rathke schrieb: Hi, On Tuesday, 2008-11-18 17:31:03 +0100, Eike Rathke wrote: I started migrating CWS odff05 from CVS (currently resynced to m31 there) to SVN, and then will rebase it to m36 when available. I'll give you a heads up when the CWS will be ready for further development. m36

Re: [sc-dev] module dep fix & code shrink ...

2008-11-27 Thread Daniel Rentz
Hi, Michael Meeks schrieb: I just committed a chunk of code to the ooxml02 CWS. This extends the visibility markup to the classes we use during import and export: which turned out to be fewer symbols than I had feared (10k vs. 9k symbols), and splits out all of the calc filters (except

[sc-dev] CWS ooxml02: some comments

2008-11-27 Thread Daniel Rentz
Hello all some thoughts and questions about CWS ooxml02: 1) I noticed that you changed filter names and file type names in the configuration (module filter). This is not a good idea as these names can be considered public API. These strings may be used in macros and other programs to use a sp

Re: [sc-dev] Re: [allsvn] r265030 - cws/ooxml02/offapi/com/sun/star/sheet

2008-12-10 Thread Daniel Rentz
Kohei Yoshida schrieb: Hi Eike, On Tue, 2008-12-09 at 20:41 +0100, Eike Rathke wrote: If there isn't any, wouldn't it be "natural" to share the filter's name mapping with VBA? Absolutely, and that's what I envisioned too. What we seem to disagree is where to keep the shared filter name mappi

Re: [sc-dev] percentage

2009-02-17 Thread Daniel Rentz
Douwe SCHAAP schrieb: Dear -- I do like open office very much, am in live with this software. But... with a notebook 17 " a page is rather small. In Microsoft Word, we can zoom. I can not find this utility in OO. Is it hidden or not there?? Please note that you have written to the sc-dev mail

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-12 Thread Daniel Rentz
Regina Henschel schrieb: Hi, I'm expanding LOGNORMDIST to the form it has in ODF spec. There it is LOGNORMDIST( Number x [ ; Number m = 0 [ ; Number s = 1 [ ; Logical Cumulative = TRUE() ] ] ] ) Inside OOo it is no problem. But how to export it to Excel? Excel has 3 Parameters, no one option

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-12 Thread Daniel Rentz
Hi again, Daniel Rentz schrieb: To delete the 4th parameter, you can change the function info of this function. Go to xlformula.cxx and look for ocLogNormDist, change the line from { ocLogNormDist,290,3, 3, V, { V }, 0, 0 }, to { ocLogNormDist,290,3, 3

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-16 Thread Daniel Rentz
Regina Henschel schrieb: Hi Daniel, That works. When exporting to xls, I get the correct function structure, if there are one, two or three parameters in OOo. If there are four parameters in OOo, I get a =#NV entry in German Excel 2007. I think, the error message is correct, because the user

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Daniel Rentz
Eike Rathke schrieb: Hi Regina, On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote: But export to "Microsoft Excel 2003 XML (.xml) is problematic. If OOo is set to save in "odf1.2", the file opens with errors in Excel. All formulae are stripped. The error log says for example GRUN

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Daniel Rentz
Regina Henschel schrieb: Hi Eike, hi Daniel, Regina Henschel schrieb: No more questions for now, I'll continue my tests. Thanks for your help. Now all works as it should and I'm going to create patches. And have got the next problem. For the file token.cxx in formula/source/core/api I get

Re: [sc-dev] The Excel import/export part of i35579.

2009-03-23 Thread Daniel Rentz
maoyg schrieb: > Hi,Daniel > I am working the issue 35579 with lvyue, and now I come to the Excel > import/export part. > the Excel has some options,I have added some change,for example, excdefs.hxx > added comparison operands, > the XclImpAutoFilterData::ReadAutoFilter() method in excimp8.cxx ad

Re: [sc-dev] Re: MS Excel file encryption feature contribution to OO.o

2009-04-07 Thread Daniel Rentz
Hello, Kohei Yoshida schrieb: Great! BTW, the new security framework would probably affect the password input UI part, but should not affect anything else IMO. Btw, I am interested in the pw input UI stuff to add it to the ooxml filter. Do you have a pointer for me? Regards Daniel --

Re: [sc-dev] about DataPilot

2009-06-10 Thread Daniel Rentz
Kohei Yoshida schrieb: On Wed, 2009-06-10 at 14:51 +, Michael Meeks wrote: I've asked Kohei to create a CWS and whack the patches in there There is one problem. I can't seem to create a CWS. I've tried: $ cws create DEV300 kohei03 -m m49 .. check cws path: 'svn +ssh://s...@svn.services

Re: [sc-dev] Request on some issues

2009-06-18 Thread Daniel Rentz
Niklas Nebel schrieb: On 06/18/09 16:36, Cor Nouws wrote: Yesterday I came across some issues, that might need a new owner: - 102022 Data validity using cells area don't work after export to xls Anything xls-related can be dumped on Daniel (dr). :-) I took over that issue, see comments the

Re: [sc-dev] Problems with BESSELJ

2009-07-08 Thread Daniel Rentz
Eike Rathke schrieb: Hi Regina, On Saturday, 2009-07-04 23:52:18 +0200, Regina Henschel wrote: Or return an error, if neither asymptotic formula results at least 2 digits (How tell the user, that the result is not accurate?) A few functions set errNoConvergence if a function can't determine

Re: [sc-dev] Missing second parameter in CEILING

2009-08-06 Thread Daniel Rentz
Moin, Regina Henschel schrieb: Ah, IsMissing() is new to me. I can now set the missing second parameter to +1 or -1 depending on N. That works at least for CEILING on which I'm currently working. But Excel Import and Export is confusing. (1) Import: In cases CEILING(value;) and CEILING(;val

Re: [sc-dev] Missing second parameter in CEILING

2009-08-12 Thread Daniel Rentz
Regina Henschel schrieb: Hi Daniel, I do not answer directly, because it seems that I described my concern not good enough. Next try: == Import == Importing an Excel-file with =CEILING(-3.4;) for example gives the cellcontent =CEILING(-3.4;;1), because in the current import filter the thir

Re: [sc-dev] 65,000 lines on calc

2010-03-24 Thread Daniel Rentz
Alexandro Colorado schrieb: when did OOo Calc (what version #) get past the 65,000 limit on spreadsheets? It was the 32,000 row limit (now there are 65,536 rows available), and the feature announcement was in May 2004: http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=157 (hmm, th

Re: [sc-dev] Functions in Excel 2010

2010-04-08 Thread Daniel Rentz
Regina Henschel schrieb: I have started a new Wiki page http://wiki.services.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions Note that the functions are not renamed (as one may read on th Wiki), but that the old functions with the old names still exist. Daniel

Re: [sc-dev] Debug the Calc Source Code

2010-04-13 Thread Daniel Rentz
rashi dhing schrieb: I started building the sc module with debug=true but now I am getting the following error: ../wntmsci12.pro/bin/scuimi.dll : fatal error LNK1169 : one or more multiply defined symbols found. dmake: Error code 2, while making ' ../wntmsci12.pro/bin/scuimi.dll I came acros

Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

2010-05-16 Thread Daniel Rentz
Hi regina, Regina Henschel schrieb: the file oox/source/xls/formulabase.cxx has a section /** Functions defined by OpenFormula, but not supported by Calc or by Excel. */ Does this refer to the draft ODF 1.2 formula spec? No. I just scanned the function op-codes defined by sc (nowadays for

Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

2010-05-16 Thread Daniel Rentz
Regina Henschel schrieb: Hi Daniel, Daniel Rentz schrieb: Hi regina, Regina Henschel schrieb: the file oox/source/xls/formulabase.cxx has a section /** Functions defined by OpenFormula, but not supported by Calc or by Excel. */ Does this refer to the draft ODF 1.2 formula spec? No. I

Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

2010-05-17 Thread Daniel Rentz
Regina Henschel schrieb: Hi Daniel, Daniel Rentz schrieb: Same for the equivalent table "saFuncTable_Odf" in sc/source/filter/excel/xlformula.cxx. It seems, that I have to wait till m78, because m76 does not contain saFuncTable_Odf and m77 does not build for me. Right, fi

Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

2010-05-31 Thread Daniel Rentz
Hello, Regina Henschel schrieb: Daniel Rentz schrieb: Right, fix has been integrated into m77 http://qa.openoffice.org/issues/show_bug.cgi?id=79854 Now I have a build based on m78. I made some import/export tests. Excel2003 xml is totally broken (issue 94261) and not mentioned below

Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

2010-06-01 Thread Daniel Rentz
Hi Regina, Regina Henschel schrieb: If I use ocExternal the prefix is set, but the functions are not distinct, only one name is written and on import the whole function name is stripped, so only =(z) remains from =_xlfnodf.IMSECH(z). I see no way to add the imaginary functions to list saFunc

Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

2010-06-04 Thread Daniel Rentz
Hi, Regina Henschel schrieb: I have now used in analysis_deffuncnames.src an entry: StringArray ANALYSIS_DEFFUNCNAME_Imcot { ItemList = { < "_xlfnodf.IMCOT"; >; < "_xlfnodf.IMCOT"; >; }; }; And for comparison an entry StringArray A

Re: [sc-dev] character set is not UTF-8 in analysis_deffuncnames.src

2010-06-17 Thread Daniel Rentz
Regina Henschel schrieb: Hi all, I see ANSI character set and not UTF-8 in scaddins/source/analysis/analysis_deffuncnames.src. Is that an error or purpose? I see. I have no idea how to tell rsc which encoding to use, or if that is fixed to ANSI (which would be a bug of course). Will try if

Re: [sc-dev] Include file error

2010-07-06 Thread Daniel Rentz
rashi dhing schrieb: This is probably a very basic question but I am getting a compile error while trying to include the "interpre.hxx" in my module which happens to be located in a new directory in the sc/source/ui path. How can I resolve this ? There are several existing locations for heade

Re: [sc-dev] DEV300m84 hangs when saving from Calc

2010-08-09 Thread Daniel Rentz
Hi Regina, Am 08.08.2010 19:12, schrieb Regina Henschel: I have build DEV300m84 on WinXP. That works so far, but saving a spreadsheet document from Calc gives always the Debug Output: Error: wrong NameAccess From File C:/DEV300m84my/xmloff/source/core/SettingsExportHelper.cxx at Line 406 If

Re: [sc-dev] DEV300m84 hangs when saving from Calc

2010-08-09 Thread Daniel Rentz
Am 09.08.2010 11:26, schrieb Regina Henschel: Hi David, see http://qa.openoffice.org/issues/show_bug.cgi?id=113737 for the assertion. I have applied the patch. Now I get no longer a Debug Output, but OOo still hangs after saving. No problem in DEV300m86. Did you try it in a debugger? Rega

Re: [sc-dev] View Settings was: Dispatching AutoComplete for cell values

2010-10-28 Thread Daniel Rentz
Hi Peter, Am 28.10.2010 15:23, schrieb Peter Eberlein: Hi Niklas, Am 28.10.2010 11:02, schrieb Niklas Nebel: Value highlighting is a view setting that can be enabled for each view individually. It's the property "IsValueHighlightingEnabled" in service SpreadsheetViewSettings, part of Spreadshe

Re: [sc-dev] View Settings was: Dispatching AutoComplete for cell values

2010-10-28 Thread Daniel Rentz
Am 28.10.2010 15:58, schrieb Daniel Rentz: Hi Peter, Am 28.10.2010 15:23, schrieb Peter Eberlein: Hi Niklas, Am 28.10.2010 11:02, schrieb Niklas Nebel: Value highlighting is a view setting that can be enabled for each view individually. It's the property "IsValueHighlightingE

Re: [sc-dev] View Settings was: Dispatching AutoComplete for cell values

2010-10-28 Thread Daniel Rentz
Am 28.10.2010 15:23, schrieb Peter Eberlein: Hi Niklas, Am 28.10.2010 11:02, schrieb Niklas Nebel: Value highlighting is a view setting that can be enabled for each view individually. It's the property "IsValueHighlightingEnabled" in service SpreadsheetViewSettings, part of SpreadsheetView. T

[sc-dev] WIKI: Extended description about Excel import/export of spreadsheet functions

2010-12-14 Thread Daniel Rentz
Hello, I have added the WIKI page http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions with a chapter "Microsoft Excel import and export" about how to extend the Excel import/export filters for new sheet functions. Direct link to the chapter: http://wiki.services.

Re: [sc-dev] WIKI: Extended description about Excel import/export of spreadsheet functions

2010-12-14 Thread Daniel Rentz
Am 14.12.2010 16:31, schrieb Marina Plakalovic: Tnx, Daniel. I needed that one. :) If there are questions, if you find mistakes, etc... please just write here. Daniel - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.

[sc-dev] Re: Issues with some formulas conversions in OOo VARP, QUATRILE

2011-03-07 Thread Daniel Rentz
Hi, Am 04.03.2011 20:33, schrieb Alexandro Colorado: On Fri, Mar 4, 2011 at 1:31 PM, Alexandro Colorado mailto:j...@openoffice.org>> wrote: I filed a bug with some issues I identified on a conversion of formulas. So far one of the issues is sovled, the other however still need aten

Re: [sc-dev] Functions needed?

2005-05-17 Thread Daniel Rentz
on which is available at http://sc.openoffice.org/ (look under the Documentation). Chapter 5.11 contains a list of sheet function names that may appear in a Excel file. Currently (rev. 1.39) it is chapter 4.11. Now, I don't know whether this list is exhaustive since I'm not the author (Dani

Re: [sc-dev] Functions needed?

2005-05-17 Thread Daniel Rentz
Hi, Kohei Yoshida schrieb: On 5/17/05, Daniel Rentz <[EMAIL PROTECTED]> wrote: Yes, it is. It also includes information about differences between the varios versions of Excel, e.g. available functions and different parameter counts. Cool. That's even better. Thanks for the clarifi

Re: [sc-dev] Excel Controls do not work in OpenOffice CALC

2005-06-08 Thread Daniel Rentz
Hi, [EMAIL PROTECTED] schrieb: Create a worksheet in Excel with some controls such as lists and combo boxes save the worksheet. Open the worksheet in CALC. The controls do not work. What does "do not work" mean? Best is to open a new issue in IssueZilla and to attach a sample file there.

Re: [sc-dev] open office calc question.

2005-10-10 Thread Daniel Rentz
Hi, Askanthea wrote: I dont know if you can help but i got your email from the -to do page. If I have a long column of variables for example numbers 1-100 in cells a1-a100 when i try to print it comes out on 2 or 3 pages - i want the finished result to appear on one page but in 2 or 3 column

Re: [sc-dev] Maybe im using the wrong version 2.0RC

2005-10-10 Thread Daniel Rentz
Hi, Askanthea wrote: http://www.novell.com/connectionmagazine/2005/09/fine_print.html this pages says check the auto linebreak box - im using version 2.0 RC - sould i be using a differnt download to access this feature? Has been renamed to "Wrap text automatically". These announcements con

Re: [sc-dev] Re: [webmasters] minor problem in calc functions

2005-10-28 Thread Daniel Rentz
Hi, Louis Suarez-Potts wrote: Thanks for the heads up. Am cc'ing the Calc list for their attention. On Sep 7, 2005, at 9:39 PM, Ian Mason wrote: Hi webmasters. I'm using OpenOffice 2.0 beta under Windows XP. In general I'm very happy. Everything I've tried works as advertised. However I thin

Re: [sc-dev] Spreadsheet functions' issues

2006-01-04 Thread Daniel Rentz
Hi, Eike Rathke schrieb: Last year ;) Muthu Subramanian sent me a mail in which he asked whether we're already working on specific issues he picked to work on. I asked him to repeat the question on the mailing list because I want to keep discussion public, but he didn't show up since. Neverthel

Re: [sc-dev] Metadata section of XLS files

2006-12-15 Thread Daniel Rentz
René Peinl wrote: Hi guys, I'm sorry to bother you with this, but you seem to be the only people reachable outside Microsoft that know about the XLS file format. I've dealt myself a lot with the XML versions and also did some minor enhancements to the OO XSLTs that convert WordML to OO, but now I

Re: [sc-dev] Re: Microsoft Compound Document File Format

2007-01-08 Thread Daniel Rentz
Greg Hoover wrote: The documents provided on the Microsoft Compound Document file format and Excel file format have proven an invaluable resource, I appreciate their availability. I'd like to submit a correction or addition to the compound document header (section 4.1) in regards to the "Minim

[sc-dev] OOXML: Updated WIKI page

2007-03-16 Thread Daniel Rentz
Hi I have added an overview of all features that have to be implemented for the OOXML spreadsheet filter, see http://wiki.services.openoffice.org/wiki/SpreadsheetML the table at the end of the page. Feel free to extend and change it. Daniel

Re: [sc-dev] sheetViews context handling strategy

2007-03-21 Thread Daniel Rentz
Kohei Yoshida schrieb: Hi all, So, element has a child element called , which contains a group of elements. It contains view data such as the cursor position, active sheet etc. Here is a problem with importing these view settings. For us to set such view data, we have to gain access to the cu

Re: [sc-dev] Some simple tasks

2007-06-15 Thread Daniel Rentz
gaozm schrieb: > Hello Daniel: Thank you for your suggestions, now, I would like to do > something on OpenOffice, because I am a new member, could you give me > some simple tasks? Thank you! As you told me that you are interested in improving data filter functionality: Did you take a look in Issu

Re: [sc-dev] Rubber/Pencil function for Calc

2007-06-21 Thread Daniel Rentz
Max Giesbert schrieb: Thx again. feels like i am already there. i got the XCell now from the Target but how can i get the location of the cell on the screen. i read about XAccessibleComponent but XCell doesn't seem to implement it... I have written a tiny test script in Basic recently, that get

Re: [sc-dev] Increasing maximum worksheet size

2007-06-21 Thread Daniel Rentz
Niklas Nebel schrieb: Alan Yaniger wrote: A number of our users have asked if there's a way we could increase the maximum worksheet size. One said that for this reason alone he's planning to move to Excel 2007, which allows over a million rows. What is involved in implementing this feature in

Re: [sc-dev] Rubber/Pencil function for Calc

2007-06-22 Thread Daniel Rentz
Max Giesbert schrieb: actually i have problems with the very first line of code you sent: acc = ThisComponent.CurrentController.Frame.ComponentWindow.AccessibleContext i am doing development right now using java. so i do get the ComponentWindow by: XWindow window = xController.getFrame().getCo

Re: [sc-dev] Formula import for OOXML

2007-08-03 Thread Daniel Rentz
Kohei Yoshida schrieb: Hi there, I was just wondering where we are on the formula import for our OOXML importer work. Is it complete, or good enough to be used for other features that require formula parsing? OOX: Work is in progress, especially the mapping of built-in function names, add-in

  1   2   >