[sc-dev] Re: oo 3.x: hiding columns in large spreadsheets sometimes very slow
On 23.06.2011 11:37, Oliver Brinzing wrote: i noticed hiding columns in large spreadsheets (~3MB) can be very slow compared to oo 2.x, for example: For i = 0 To uBound(mRanges()) oRange = oSheet.getCellRangeByName(mRanges(i)) oRange.getColumns().IsVisible = bVisible Next i will take about 3 seconds for each range in my spreadsheet - why ? Are there many comments (notes) in the file? Then it might be related to issue 102716. adding oDoc.addActionLock() / oDoc.removeActionLock() will solve the problem, but i am not sure if i have to use a oDoc.calculateAll() after removing the lock to be sure, all formulas are calculated correctly ? No, addActionLock for the document doesn't interfere with formula calculation. It mainly affects the drawing layer. Niklas -- - To unsubscribe send email to dev-unsubscr...@sc.openoffice.org For additional commands send email to sy...@sc.openoffice.org with Subject: help
[sc-dev] Re: Insert Sheet - Before or After?
On 08.04.2011 07:15, tora - Takamichi Akiyama wrote: Could it be better if the default choice is ( )After current sheet, instead of (x)Before current sheet? Could it be better if Calc will remember what a user chose? That might be something for the better defaults list at http://wiki.services.openoffice.org/wiki/User_Experience/Improving_OOo_Default_Settings. Niklas -- - To unsubscribe send email to dev-unsubscr...@sc.openoffice.org For additional commands send email to sy...@sc.openoffice.org with Subject: help
[sc-dev] Re: Calc Watch Window
On 29.03.2011 18:53, Federico Capoani wrote: Hi, my name is Federico Capoani and I am writing some code in order to implement the Watch Window in OpenOffice Calc. I created two dialogs, the first one contains the watchlist, the second one is used for adding new cells to the watchlist. I am writing a module with OpenOffice Basic and I think the work could be finished in a few days or a week (depending on my school agenda). This is my first OpenOffice project, so I don't know some things. Whom can I ask help to? How do I have to send you the final work? I wish I hear from you soon. There are already two Watch Window extensions in the repository now, http://extensions.services.openoffice.org/en/project/watchwindow and http://extensions.services.openoffice.org/en/project/watchingwindow. If you still want to do an implementation in Basic, the best places to ask for help are this list or d...@api.openoffice.org. You should subscribe to any mailing list before posting, to make sure you get all replies. Niklas -- - To unsubscribe send email to dev-unsubscr...@sc.openoffice.org For additional commands send email to sy...@sc.openoffice.org with Subject: help
[sc-dev] Re: Internship 2010: Statistical Data Analysis Tool
On 28.03.2011 10:50, Niklas Nebel wrote: It's in the download section of sc.openoffice.org, the URL is now http://openoffice.org/projects/sc/downloads/directory/Data%20Analysis. But apparently, some of the files were truncated in the Kenai transition. I'll try to get that fixed. I re-uploaded it. final evaluation version is the latest version. Niklas -- - To unsubscribe send email to dev-unsubscr...@sc.openoffice.org For additional commands send email to sy...@sc.openoffice.org with Subject: help
[sc-dev] Re: c.s.s.XDataPilotFieldGrouping - how does createNameGroup() work ?
On 08.03.2011 18:26, Oliver Brinzing wrote: can someone give me an example how to use createNameGroup() from c.s.s.XDataPilotFieldGrouping according to http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XDataPilotFieldGrouping.html it take a sequence: createNameGroup( [in] sequence string aItems ) Parameter aItems a sequence containing the names of the items (members) which will be part of the new group. Must be names of items contained in the current field. but all i get is a IllegalArgumentExecption if i use for example: Dim mGroup(1) mGroup(0) = category mGroup(1) = region oField.createNameGroup(mGroup()) Are category and region items of the field oField? They sound more like field names. Niklas -- - To unsubscribe send email to dev-unsubscr...@sc.openoffice.org For additional commands send email to sy...@sc.openoffice.org with Subject: help
[sc-dev] Re: type logical in Excel
On 28.02.2011 00:37, Regina Henschel wrote: I just noticed, that Excel 2007 and Excel 2010 distinguish between type Logical and type Number. Is this new in Excel 2007/2010 or did Excel had a separate type Logical before? (I haven't got an older version of Excel and therefore cannot examine it by myself.) That's older. There are already related issues 58572 and 84266. Niklas -- To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: sy...@sc.openoffice.org with Subject: help
Re: [sc-dev] Help with SC wiki template
On 12/04/10 16:46, Alexandro Colorado wrote:
Hi I did some templates for the wiki on the different modules, I would
want to ask for help to review it and also improve it. I would also want
to call for structuring the sub-categories and maybe share some ideas
with the other modules.
you can check it here:
http://wiki.services.openoffice.org/wiki/Template:Calc_Project
Looks good.
Also suggest to have a language table (with the option
{{Calc/Lang|Spreadsheet}} ). See it in action here:
http://wiki.services.openoffice.org/wiki/Base
Do we have suitable Calc pages in other languages?
Niklas
-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 83783
On 11/02/10 10:31, Peter Eberlein wrote: Am 02.11.2010 10:00, schrieb Niklas Nebel: On 11/02/10 08:58, Peter Eberlein wrote: The dialog you get on Windows if you select Insert/Object/OLE Object, and then Further objects. That's an OLE dialog, not part of OOo. It has a check box Display As Icon. Ah, yes. But this system dialog only appears in MS Office, not in OpenOffice. No, I'm talking about OOo of course. It has to be compiled with OLE support, but the downloads from the website are compiled that way. I always use that downloads for ages, but never got this system dialog, only the oo-OLE-Dialog. And yes, Tools/Options/%productname%/General/Use OpenOffice.org dialogs is unchecked. What do you get if you select Further objects in the Insert OLE Object dialog? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 83783
On 11/01/10 08:34, Peter Eberlein wrote: Are you sure Display As Icon in the system dialog (Further objects) isn't what you're looking for? Sorry, maybe I overlooked something :-\ , but what do you mean with system dialog ? The dialog you get on Windows if you select Insert/Object/OLE Object, and then Further objects. That's an OLE dialog, not part of OOo. It has a check box Display As Icon. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 83783
On 10/28/10 16:11, Peter Eberlein wrote: can someone of the spreadsheet team confirm http://qa.openoffice.org/issues/show_bug.cgi?id=83783 ? The issue is assigned (ul) and has a target, but status unconfirmed. BTW, I consider this a framework issue for all applications. Are you sure Display As Icon in the system dialog (Further objects) isn't what you're looking for? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Dispatching AutoComplete for cell values
On 10/28/10 08:14, Peter Eberlein wrote: Service com.sun.star.sheet.GlobalSheetSettings has a property DoAutoComplete. It can be read and modified, so you don't need the dispatch stuff for that. Shouldn't this service contain a property ViewValueHighlighting too? Here I need the dispatch stuff. These differences are sometimes not clear. 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. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Dispatching AutoComplete for cell values
On 10/27/10 16:30, Peter Eberlein wrote: how can I turn AutoComplete off? I tried: Object helper = Mcf.createInstanceWithContext(com.sun.star.frame.DispatchHelper, xComponentContext); XDispatchHelper xDispatchHelper = (XDispatchHelper) UnoRuntime.queryInterface(XDispatchHelper.class, helper); PropertyValue[] args = new PropertyValue[1]; args[0] = new PropertyValue(); args[0].Name = AutoComplete; args[0].Value = false; XDispatchProvider xDispatchProvider = (XDispatchProvider) UnoRuntime.queryInterface(XDispatchProvider.class, xModel.getCurrentController().getFrame()); xDispatchHelper.executeDispatch(xDispatchProvider, .uno:AutoComplete, , 0, args); This doesn't work. Seem there is only a Toggling without args possible. If this is true: How can I detect, if AutoComplete is On or Off? Service com.sun.star.sheet.GlobalSheetSettings has a property DoAutoComplete. It can be read and modified, so you don't need the dispatch stuff for that. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] How to access cell values in a cell range in Calc add-ins?
On 10/18/10 07:51, Pivithuru Wijegunawardana wrote:
You can use com.sun.star.sheet.XCellRangeAddressable interface and
CellRangeAddress.
com.sun.star.sheet.XCellRangeAddressable xRangeAddr =
(com.sun.star.sheet.XCellRangeAddressable)
UnoRuntime.queryInterface(com.sun.star.sheet.XCellRangeAddressable.class,
xCellRange);
CellRangeAddress aRangeAddress = xRangeAddr.getRangeAddress();
From aRangeAddress you can get details about range start column,start row
and range end column,end row. Then you can get the no of columns and rows
you have in the range
int noOfColums = aRangeAddress.EndColumn - aRangeAddress.StartColumn + 1;
int noOfRows = aRangeAddress.EndRow - aRangeAddress.StartRow + 1;
Then traverse through the range using this and you can get all the cells
inside the given range.
for (int i = 0; i noOfColums; i++) {
for (int j = 0; j noOfRows; j++) {
XCell cell = xCellRange.getCellByPosition(i, j);
}
Or if the parameter has a type like sequence sequence double in
IDL, which is double[][] in Java, you can just use length to access
the array's length.
Niklas
-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] vlookup issues ...
On 09/28/10 13:39, Oliver Brinzing wrote: had a look at some vlookup issues: seems: 16786 ENHANC P4 Other requirementsSTARTE Need better control of regexp in vlookup 44295 DEFECT P3 PC spreadsheet NEW Vlookup with / character 99472 DEFECT P3 Macintos spreadsheet UNCONF VLookup breaks if a PIPE '|' character is used in matching c have same root cause. and issue http://www.openoffice.org/issues/show_bug.cgi?id=89690 (error in VLOOKUP when importing from Office2007) seems to be fixed with oo 3.2. can someone mark as dup/close ? Yes, thanks for pointing this out. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Range selection and UNO awt
On 07/22/10 19:13, Pivithuru Wijegunawardana wrote: I have created a simple GUI using UNO awt for statistical data analysis tool in summer internship program. Now I want to get the user input data from the spreadsheet from clac range selection. I hope to do this after user has opened the dialog. Functionality I need is something alike the cell function data input method. I wanted to know whether this is possible in using UNO awt and cell range selection. There is the XRangeSelection interface of the SpreadsheetView service, but it doesn't allow the same level of integration as Calc's own dialogs. With this interface, you can do something like the Data Range page of the Chart Wizard dialog, where you have a button in a modal dialog and start the range selection if that button is pressed. It doesn't allow selecting a range in the sheet with just the focus in a range edit, like it's possible in the Calc dialogs. Sooner or later we'll have to extend the API here, so extensions can have dialogs that work like our own. So we shouldn't put much effort into implementing something with XRangeSelection now. Instead I suggest to just use simple Edit controls into which the range address has to be typed, like Copy sort results to in the Sort dialog. The component then has to parse that input. If we later extend the API, we can have the new API read and write from these Edit controls. One thing you should prepare is the possibility to change your dialogs to modeless dialogs, because that's how Calc's reference dialogs work. A modeless dialog doesn't have an execute method that returns when the dialog is closed. Instead it performs its actions from event handlers, so you can't keep information in local variables across the execute call. To simulate this, you can just add a method like dialogClosed to your component, and call it directly after execute, with no additional parameters. If that method reads the settings from the dialog and does the processing, it can later be called from a listener when the dialog is changed to modeless. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Validator for Calc
On 06/16/10 15:34, Kálmán „KAMI” Szalai wrote: Here it is an updated WatchWindow ftp://ftp.devall.hu/kami/go-oo/WatchWindow_1.1.2.1.oxt Please test it and let's discuss it. Have you seen http://extensions.services.openoffice.org/en/project/watchingwindow, which integrates nicely with the task pane? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Include file error
On 07/19/10 20:28, rashi dhing wrote: How it works is that the formula contains the range that will be populated with the result and only those cells of the range are filled with the result. So the issue of overwriting previous content does not apply here as only empty ranges are selected !! It still seems unusual. Are these formulas supposed to be static, or should they be updated when other cells change? Anyway, if you modify cell content from UI code, you have to take care of repaint, undo, formula updates, and possibly row heights. There's a method ScDocFunc::SetCellText for a single cell, which handles this, or you might do something similar to lcl_PutDataArray in cellsuno.cxx. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Include file error
On 07/19/10 11:54, rashi dhing wrote: Thanks Niklas Eike. So if I have understood correctly, I need to add my operation to the list of functions (add,max etc.) so that when I call the ScFormulaCell::Interpret, the formula gets evaluated according to my function. But that requires an opcode, which I will have to generate ? Also, my formula follows a different grammar !! What If I evalute my formula in a separate function rather than call interpret and just return the answer in a matrix. How do I then print the matrix ? This is tough work. Appreciate all your help !! If you don't want to add an OpCode and have your function called by formula evaluation, ScInterpreter is the wrong place for the function. Returning a ScMatrix might still be useful, but not necessarily so. What are you really trying to do? It would help to know that. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Include file error
On 07/19/10 12:26, rashi dhing wrote: Hi Niklas, I have defined a formula that contains deductive clauses which follow a different grammar and I have already written the evaluation function, the result of which is a matrix. I was thinking I could just call ScInterpreter::PushMatrix which would print the result but again, my function resides in the ui module which limits access to ScInterpreter. I could define a function in ScFormulaCell that calls the pushmatrix function and call that function from my class. I hope i am making sense. If opcode is a better option, where do I go and add it ? When and from where is that function called, and what do you want to do with the results? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Include file error
On 07/19/10 15:24, rashi dhing wrote: I've defined a class which I call the ScDeductive in sc/source/ui/deductive. I have defined a function StartEval which evaluates the clause( formula ) and returns an array as a result. This function is called from ScInputHandler::DataChanged . I enter the formula in a cell but I would like to display the result in a range on the spreadsheet as the result is an array / matrix. Can you tell me the right approach to do this ! Does that mean while a user is editing a cell, you want to put results into other cells, overwriting the previous content of the cells? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] crashes in m84
On 07/12/10 11:20, Cor Nouws wrote: While working with m84, I had several crashes last days. The work flow was like this: - two calc files open (and some more) - select a range in one spreadsheet - ctrl-C - alt-tab to change window (to other spreadsheet) - and so forth and at a certain moment .. crash It was in moments of repeated, swift editing. I tried to reproduce with some random files and editing, but of course was not able to reproduce. Sorry. Nevertheless, it is behaviour that I do not know from OOo 321 - I would have had troubles with that more often then. Do you have some other tools running that interact with the clipboard? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] queryColumnDifferences working wrongly ?
On 07/09/10 13:08, Rony G. Flatscher wrote: Using the interface http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery; the range A1:C4 is compared with the value in cell B5 (4,1) (value 1) using the queryColumnDifferences method of the range, supplying the address of the cell 4,1 as an argument. The resulting XSheetCellRanges is then used to colorize the cells in red, and also its method getRangeAsAddresses is used to display the cell ranges in a human readable form in A7 Each column of the range is compared to a cell in the same column and the row of the parameter. They are not all compared to the same value. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Include file error
On 07/07/10 10:50, rashi dhing wrote: Thanks Niklas and Daniel. I was trying to call interpre.hxx (sc/source/core/inc) from a cxx file in sc/source/ui/newFolder . Wanted to use a certain function of the ScInterpreter class ! Can I give the whole path sc/source/core/interpre.hxx and use it ? I wouldn't recommend that. If you have a function that can be used without ScInterpreter, you should move it out of interpre.hxx. If you're creating an ScInterpreter instance to call your function, better use ScFormulaCell instead. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Optimization NLPSolver
On 06/28/10 09:26, Martina Fares wrote: I want to optimize the NLPSolver and read the data from the spreadsheet. But, I do not know on what variables should I save the generated solutions so they are shown. Respectively. I get the window no solutions this is always generated automatically, how can I delete the window? The No solution dialog is shown by Calc if getSuccess returns false after the solve call (ScSolverNoSolutionDialog in optsolver.cxx). Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] XViewFreezable
On 06/28/10 11:30, Peter Eberlein wrote: just stumbled over the 7 years old issue http://www.openoffice.org/issues/show_bug.cgi?id=19896 Is there a way to remove the freezing using the dispatch API? You don't have to use the dispatch API. Freezing is a special mode of splitting. You can reset the view to un-split, un-frozen with splitAtPosition(0,0) from the XViewSplitable interface. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Component to check spreadsheet documents for potential errors for the OpenOffice.org Summer 2010 Internship - Oren Zeev-Ben-Mordehai
On 06/24/10 14:22, Oren Zeev Ben Mordehai wrote: I'm interested in the Component to check spreadsheet documents for potential errors for the OpenOffice.org Summer 2010 Internship. Is it still available? There are already some applications for that project, but no final decision yet. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Absurd behaviour while displaying values in a range of cells
On 06/08/10 09:43, rashi dhing wrote: Thanks Niklas, will take a look at how array formulas work ! Can you tell me which modules to look at tho ? It depends on what you're really doing. Assuming that you're adding a function to ScInterpreter, take a look at GetNewMat/PushMatrix, and how they are used in the other functions. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Conditional Formatting with newly inserted cellstyle (Java)
On 06/08/10 16:37, Peter Eberlein wrote: after inserting a new cellstyle I cleared all conditional format entries and inserted a new one with the new cellstyle. It seems, the new conditional format doesn't reflect the new style in the sheet. Only if the style exists yet, it is visible via GUI. Nevertheless the entry in Format/Conditional Formatting.. is correct. How can I force an update of the style? Are you sure the style contains any format attributes? Remember you have to insert a new style before setting format properties (generally for cell styles, not only for conditional formatting). Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Validator for Calc
On 06/04/10 10:59, Kálmán „KAMI” Szalai wrote: We started this out of OpenOffice.org Intership program. I am thinking about the possible other checkt (the current version of Validator extension implements these checks, so we are looking more. For example excluded cells from sum, for example. Excel has this functionality. Oh, I see. Yes, excluded cells would be a possible check. Or a set of repeated formulas where one is different from the others. I don't have a list of possible errors, it's still open to define them. Because this extension is not production quality we are still working on it, but we hit a problem that we can't avoid. If you interested I can send two version of it, one that works well with A1 reference modell another (patched by Kohei) works well with A1 and R1C1 notation but drops mystery reference errors. So that is why we did not uploaded to the extension repo. It would be best to have it available for everyone to take a look. But if that isn't possible, you can send it to me. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Validator for Calc
On 06/04/10 16:21, Kálmán „KAMI” Szalai wrote: I uploaded the extensions here: ftp://ftp.devall.hu/kami/calc/ Validator.oxt - validator for calc watchwindow_1.1.2.1_kohei.oxt - watchwindow Kohei version (A1 and R1C1 noatation reference problem) watchwindow_1.1.2.1_original.oxt - watchwindow original version (only A1 notation) Please test it and share your opinion wit us! Oh, that's very cool. The formulas in watchwindow_1.1.2.1_kohei.oxt are wrong because you call the printFormula method with a wrong reference position. You have to pass the position of the formula cell. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx
On 05/16/10 21:31, Regina Henschel wrote: Daniel Rentz schrieb: scadddins/analysis should contain only these functions that Excel offers in its Analysis add-in. New functions should go into the Calc core IMHO. (Anyway, starting from Excel 2007, all Analysis functions are built-in in Excel.) I'm not sure if the filters are prepared to handle functions from the Calc Analysis add-in that do not exist in Excel. Will think about that tomorrow :) I have collected the function names including the used categories [1]. This might help to decide, whether those functions, which are part of ODFF, should be moved to somewhere else. [1] http://wiki.services.openoffice.org/wiki/File:Compare_Function_Category_Excel_ODF_OOo.ods Simply moving a function will cause some changes in behavior (like the API getFormula method). For consistency, let's add the new complex-number functions to the analysis add-in, so their behavior is as similar as possible to the existing functions. There are already add-in functions that have no Excel equivalent (like ROT13 in the date add-in), probably the new functions can be handled the same way. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx
On 05/17/10 00:21, Regina Henschel wrote: When reloading into my patched DEV300m76 I get this up to now, without any entry in the files formulabase.cxx: save in .sxc: All addin functions, including the existing ones, result in #Name?, but the cell content contains the correct formula. That part is due to issue 95312. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] HelpID for imaginary trigonometric functions
On 05/15/10 15:12, Regina Henschel wrote: next question with my imaginary functions task: I have found helpid definitions for imaginary functions in sc/inc/sc.hrc. Shall I add definitions for the new imaginary functions there? And then in sc/source/core/tool/addinhelpid.cxx and sc/util/hidother.src too? Yes, these help IDs are needed so help for a function can be shown if the Help button in the Function Wizard is pressed after selecting the function. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] constraint of x in sin(x) in scaddins
On 05/11/10 00:32, Regina Henschel wrote: to avoid breaking any existing usage is a good argument to not change anything in IMSIN or IMCOS. But what limit shall I use in the other complex trigonometric functions? (IMTAN, IMCOT, IMCSC, IMSEC, IMCOSH, IMSINH, IMCSCH, IMSECH). I personally think, that huge arguments are not needed. For those, who really need them, a spreadsheet application is likely the wrong program. On the other hand this is the only place, where there is such a limit to sin(), afaik. Please decide. To keep at least some consistency, I think these should also use the SinOverflow function, so all the complex-number functions have the same limit. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] constraint of x in sin(x) in scaddins
On 05/08/10 21:02, Regina Henschel wrote: I have notice a constraint SinOverflow (which is x=134217728) in analysishelper.cxx in scaddins. What is the special reason for it? In other places with sin() the version ::rt::math::sin() is used to get a guard for overflow. That would result in constraint x=9,22337203685478E+018, which is much larger. If there is no special reason, should I replace it, while I work on the missing complex trigonometric functions? The 2^63 limit is there to prevent invalid results (outside of the range from -1 to 1). The 2^27 limit also prevents inaccurate results, like Leonard described. Both can be justified. The pragmatic solution, to avoid breaking any existing usage, might be to keep the separate limit for the scaddins complex number functions, at least for now. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] optional (soft) hyphen in spreadsheets ...
On 04/15/10 08:49, Oliver Brinzing wrote: If i don't want the [x] Hyphenation active i can insert an Optional hyphen with Insert - Formating Mark - Optional hyphen This will insert a SOFT HYPHEN (0xC2AD). But now the - is displayed and printed even if the text is not wrapped ... This is different from writer application ... Full handling of optional hyphens is only in Writer, see issue 90566. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 109940
On 04/14/10 08:35, Cor Nouws wrote: I see a request to handle #109940 as blocker for 3.2.1 But as far as the issue shows, there has not yet been shed much light on it from the sc team. Maybe someone has a possibility for that? There have been some changes on the DEV300 code line after 3.2, including the introduction of class ScDPTableDataCache, which uses an stl::vector and a second vector for the order and no longer has that limitation. But it's not a small change, and the OOO320 and DEV300 code is quite different already, so we can't easily use it for 3.2.1. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Debug the Calc Source Code
On 04/11/10 15:37, rashi dhing wrote: I am getting the error The breakpoint will not currently be hit. No symbols have been loaded for this document after adding a breakpoint to a line in the source file. I have been doing the following: 1) Running Calc by clicking in scalc.exe from the programs dir of the installation set. 2) Opening VS2008 and attaching the process soffice.bin 3)Opening the source files that I need to debug. 4)Adding the breakpoint. But that is when the error arises. I did everything on Calc to hit the breakpoint but nothing happens.Do I have to build the calc source in debug mode ? Has anyone had a similar situation ? Yes, build the affected code with debug=true. You can mix debug and non-debug code, so you don't have to build the whole module with debug information. In fact, until CWS dr73 is integrated, building the complete sc module with debug info will fail, see issue 100534. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Reading and writing to cells
On 04/05/10 08:37, rashi dhing wrote: Hi ! I wanted to name of the module in the sc project that handles reading and writing to cells and also formula calculations . Had a look at sc/source/core/data/cell.cxx but didn't find anything substantial. cell.cxx and cell2.cxx has the implementation of the different types of cell content, ScBaseCell and its subclasses. Formulas are handled by ScFormulaCell. ScDocument has methods like GetCell/PutCell to access cells in a document. ScDocFunc has methods that modify a document and handle things like repaint and undo. Does that help? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Functions in Excel 2010
On 04/02/10 21:49, Regina Henschel wrote: Excel 2010 has some significant changes for statistical functions, see [1][2]. Are there any plans to adapt the import filter and to implement further functions? Has work on this already started? At the moment there are no plans to add the new functions to Calc. They can probably be handled in the import filter, but nothing has been started yet. A good first step would be to make an overview which new Excel functions have to be mapped to which existing functions. If someone wants to do this step, that would be great. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Reading and writing to cells
On 04/06/10 10:40, rashi dhing wrote: Hi Niklas ! I came across SetValue / SetString and GetValue / GetString functions in the document.cxx which work at the cell level . I was actually looking for something at the range level (i.e) which can give me the values/contents of the entire range in some array so that I don't have to iterate over each cell of the range . ScRangeToSequence has helper methods to fill UNO sequences, but these methods just iterate over the cells, too. Could you also shed some light on the following : - Which file handles the calculations and recalculations in the spreadsheet. Is it ScDocument again ? Calculation of a formula is done by ScFormulaCell::Interpret, which uses ScInterpreter. After modifications to a document, cells are notified using broadcasters which call ScFormulaCell::Notify. - Where exactly is ScRange (class / struct ?) defined ? Can't seem to locate it. OpenGrok answers such questions (http://svn.services.openoffice.org/opengrok/). ScRange is in address.hxx. - What exactly is tableview ? Does it refer to all the cells on the spreadsheet ? I know that Topview = Input line view. In the input handler, that's the EditView in the cell in the table, as opposed to the input line. - ScInputHandler has a function StartTable. What is it really doing ? It basically checks if editing is possible at the cell cursor position, and puts the cell content into the EditEngine. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] Re: [dev] 65,000 lines on calc
On 03/24/10 22:30, Camillem wrote: If you mean the 65536 lines limit, I hasn't yet (at least not in Dev75) http://www.openoffice.org/issues/show_bug.cgi?id=30215 Interesting details on Kohei Yoshida's blog : http://kohei.us/2010/02/20/increasing-calcs-row-limit-to-1-million/ Right. Fixes for the remaining problems are still in progress. We don't want to cause performance problems for those who don't use the larger number of rows. See issue 110116 for an extreme example. The quick dirty solution of enlarging the broadcast slot sizes would slow down recalculation a bit. We'll try to avoid that. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] improvements to openoffice calc
On 02/13/10 17:50, Ruth Aldred wrote: I am a keen user of OpenOffice, especially of Writer and Calc. As a student studying physics I need to draw a lot of graphs. One thing that Excel has over Calc in this is that it allows graphs to be inserted in new sheets, rather than being inserted next to the original data. When there is a lot of data this is a very helpful feature for quick reference for trends etc. Also, as I am using a netbook, it means that the graph easily fills the screen without having to scroll through columns to find the graph. It would be great if you could incorporate this into Calc! Separate chart sheets have been suggested before (issue 5736) and would be useful. They haven't been added because it would require larger changes. But you can already cut paste a chart to a normal empty sheet in your file and manually resize it to the window size. That way, you have it available without scrolling, too. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] improvements to openoffice calc
On 02/15/10 10:04, Laurent Godard wrote: an extension automizing this would be usefull i think ;) and would require few modifications of the core is there a dispatcher that can be intercepted to add, at the end of the graph generation, the creation of a new sheet and a cut/past operation ? The slot to insert a chart is .uno:InsertObjectChart. Note that after executing it, the chart remains activated. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Please help with bug 108720
On 01/28/10 16:42, Per Eriksson wrote: I am trying to leave Excel altogether, and the new year was a good moment. Daily, I fill out spreadsheet about my interpretation jobs and other issues, but several times I have noticed that some sheets suddenly appear duplicated, with an added 2 in the name. I use version 3.0.0 OOO300m9(Build:9358) in Swedish. (I don't understand the data at the top of this page under Found in version and Subcomponent... Sorry!) Is this a known behaviour according to design? Any reference in the manual that might help this customer? If the mouse is moved some pixels while selecting a sheet, dragdrop is started. In 3.0 on Mac, dragdrop defaulted to copy instead of move, see issue 96413. This was fixed in 3.0.1. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Data - Refresh range - deletes formatting
On 01/20/10 12:35, Peter Eberlein wrote: I've linked a range against a registered datasource/table and did some formatting (e.g. wrap text automatically). After refreshing the range all formatting is set to default. Is this behavior intended? Individual cell formats are always removed, because we don't know if the same data row ends up in a cell. But if you set the Keep formatting flag at the database range, formats from the first data row will be extended to the other rows on refreshing. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Creating a run-time dialog
On 12/08/09 06:01, Madhur Kashyap wrote: I am developing a small application using in Calc. The application is heavy on the number of user inputs required. So, far I have been able to satisfy my needs by pre-defining the columns and rows in the sheet with what data it would contain to make it work for me. There is a situation when the user inputs are dependent in a linear fashion where I am thinking of implementing them as dialog. Although, I am not sure if that is the best way. If dialogs are the best way to implement these, then I am failing to find the right tutorial on how a dialog should be implemented which is created during run-time from scratch. I need immediate help on where to locate APIs which could enable me implement a run-time dialog as mentioned in the post script. You can create a dialog from scratch, adding one control after another, but why don't you just create it with the dialog editor (see http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/Working_With_Dialogs)? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Microsoft testing Excel for supercomputers
On 11/19/09 16:00, Kohei Yoshida wrote: On Thu, 2009-11-19 at 09:25 +0100, Erich Neuwirth wrote: Hello, Excel 2007 already does parallel computing. A spreadsheet program internally creates a dependency graph of the cells. A dependency graph also knows which parts of a complex calculation are not dependent on each other, and therefore can be run in parallel. Gotcha. So Excel's formula calculation is already multi-threaded. This is an area we should still work on to improve with Calc. The idea has of course come up before (see http://wiki.services.openoffice.org/wiki/Calc/Performance/misc), but it hasn't been evaluated in much detail yet. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Automatic URL Recognition
On 11/01/09 19:21, Leonard Mada wrote: I stumbled recently open an issue with automatic URL recognition [see http://www.openoffice.org/issues/show_bug.cgi?id=106464]. [I had some frustrations with URLs in the past, too.] I wonder however, how useful this feature is. It is my believe that most people opening a spreadsheet will never have heard of db: or slot:, and therefore this feature will be a very bad experience. Note that there is no separate implementation of URL recognition in Calc. Via the EditEngine we use the svtools implementation, which mostly allows all schemes that INetURLObject supports. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] API for Calc Input Line
On 10/09/09 17:47, rashi dhing wrote: If I were to extend the source code to make the input line properties accessible through the API , how will I able to make this change available to other users ? Since the source code is constantly updated and the API extended, how will I be able to ensure this change would not conflict with the extended API. Once you have a working implementation, you can contribute it as a patch, to be included in future releases. See http://wiki.services.openoffice.org/wiki/Contributing_Patches. Would an extension solve the problem ? No, an extension can only use what is available via the API. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Create an Extension for the Solver
On 09/29/09 11:42, Martina Fares wrote: I solved the problem because of the target uno-run. But now I have another question: I want to create a new extension for the nlpsolver with the levenberg marquardt algorithm. But I don't know how should I write a new extension, I know how can I write an new calc addin, but I don't know, how to write an extension. I developed the algorithm in Java but now I want to intigrate it in openoffice. If I intigrate it, how should the user choose between the two algoritms? The extension I want to develope should be similar to the actual extension for the NLPSolver. Or is it better if I work with the actual extension? You can use the NetBeans plugin to create a new Component project and implement the com.sun.star.sheet.Solver service, or use NLPSolver as an example. But it's better to make a new extension, so both can be updated independently. If you provide a new implementation of the Solver service, it can be selected as a new solver engine in the solver Options dialog. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] [Issue 47600] Patch
On 09/25/09 11:43, Patrick Guiran wrote: I am new to this mailing list, and it is the first time I made a patch for an OpenOffice project. I propose a patch for the Issue 47600, which is about Print Range problem. Welcome, and thanks for your contribution. I would like to know if a push all needed information, and if my correction is correct. There is a problem: The patch changes more than the issue describes. See the comment in the issue. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] What are valid arguments for INDIRECT
On 09/19/09 22:15, Regina Henschel wrote: the submitter of issue 105182 closed the issue, because he find a way to solve his problem. But for me the situation is not clear. =ISREF(D1:D3!C2:E2) returns TRUE but =ISREF(INDIRECT(D1:D3!C2:E2)) returns FALSE =ISREF(A1~B1) returns TRUE but =ISREF(INDIRECT(A1~B1)) returns FALSE And INDIRECT((A1:C3):(B2:D4)) fails too. Are expressions as text not allowed for INDIRECT or are they allowed but not implemented yet? INDIRECT is supposed to parse a reference, not any more complex expression. And same with issue 104969, References to external sheets not allowed or allowed but still need to be implemented? INDIRECT with external references works (works again, see issue 101645). The problem in issue 104969 seems to be the use of OFFSET together with external references. And what about all type of names? INDIRECT(name) will fail. I know, that is mentioned in the help. But must it fail? The help is outdated here. Support for named ranges was added some time ago (issue 4695). Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Accessing the Calc Formula Bar Input Line
On 09/15/09 08:32, rashi dhing wrote: Hi Niklas, Thanks for your response. I just need to know how to trace and locate the right file to inspect and modify from the pool of cpp files in the source code. I know it's a very daunting task and if you can tell me the best way to go about it, I would be extremely grateful ! The existing range highlighting might be a good start. It's initialized in method ScInputHandler::InitRangeFinder in sc/source/ui/app/inputhdl.cxx. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Accessing the Calc Formula Bar Input Line
On 09/12/09 14:34, rashi dhing wrote: In excel, when you select different ranges in a formula (arguments that are range objects) , the formula bar highlights the range names as well as the actual cell ranges present on the sheet in different colors. We have something similar, but it's for direct references only (no names), and it's only highlighted in the cell, not in the input line (formula bar). Someone suggested using a text cursor but i believe that it only for text objects. How can I modify and format the text in the formula bar and not the cell. The text cursor API also works for cell content. But that's the content after editing, not what is currently edited. For currently edited text, there's only special-purpose API like XTransferableSupplier, so I think what you describe can't be done without modifying OOo code. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] How to test a patch?
On 09/14/09 17:31, Giovanni wrote: I wish to start with development project. I know that I have to watch the issue tracker. Once I have selected an issue I can solve, and once I wrote the relative patch, how can I test it? Have you done your own build yet? If not, see http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide. Then, after modifying something you can just build a single module again and copy the binaries into your installation. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/24/09 18:16, Niklas Nebel wrote: On 06/24/09 05:00, Xu Ming Wang wrote: - Data Source buffer sounds interesting. Now it would of course be helpful to see the actual code changes for it. It is something like Excel's PivotCache, and better to save it in the document file. If that, we need the approval of the ODF format proposal relate it. OOo 3.x has a cache (ScDPCacheTable), but it isn't saved, and the results are still created using ScDPItemData. We'll have to see how we can put these things together. Also, you're right, we'll have to clarify the file format handling. A little update on the file format part: The current plan is to extend the ODF format version list box in the options dialog with an additional entry, to select between 1.2 and extended 1.2 (extended in the ODF 1.2 sense). If 1.2 is selected, nothing is saved that is not in ODF 1.2. If 1.2 extended is selected (the default), extensions are saved as foreign elements/attributes (this means, in a different namespace - but accept both namespaces when loading). Also, we want to use extensions sparingly, and generally only if a new feature is really used. This is difficult with the cache table, where the obvious approach is to always write it. File format extensions are also needed for shapes in charts and notes in Impress, so the UI and configuration change will probably be implemented for one of these features (details will be sorted out next week, but then I will be on vacation). Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 08/03/09 17:32, Kohei Yoshida wrote: Any chance we can integrate this feature without accessibility, by leaving the accessibility a known issue for future work? :-) No, accessibility is considered an acceptance criteria by QA. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 07/31/09 16:28, Kohei Yoshida wrote: - Extensions to the DataPilotSource API must be done in a compatible way (see the handling of the Filter property). I've reviewed my change against the baseline, and my only addition to the UNO API is two new constant values to MemberResultFlags. It's my understanding that adding new constant values to the existing constant set is considered binary compatible. Having said that, it's entirely possible that I'm misunderstanding the intent of your comment here, so could you please clarify on this point? An extension can supply its own implementation of the DataPilotSource service, which can then be used with the External source/interface option (see http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/DataPilot_Sources). To maintain compatibility with such extensions, Calc must not rely on the presence of new, added properties. This is different from services which are only implemented in Calc. Also, I'd like to see how the Filter property was handled in a compatible way. Could you point me to the place to look for? I did my own search, but I couldn't find what may look like the code you are referring to. For the Filter property, ScDPSaveDimension::WriteToSource just has to be prepared for an exception from setPropertyValue, because it's not an error if that property isn't supported. I've switched to using SvxCheckListBox for the member list control. So, that should take care of that part of the accessibility, I assume. Also, I'd like to know more about the accessibility function requirements. Could you give me some pointers, please? I'm not that familiar with accessibility requirements, as that subject always sounded too abstract to me... Any details would be great. It has to work. :-) See http://wiki.services.openoffice.org/wiki/Accessibility for some more information and which tools can be used. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Re: [qa-cvs] Maitanance of Bug #326914
On 07/17/09 17:19, Joost Andrae wrote: Tshepiso Rantho schrieb: As part of my final year project assignment, i have been assigned to create a patch for Bug #326914:table border color doesn't work correctly. How do i get hold of the code and how do i cooperate with you to successfully complete my assignment. It works as intended, although that's probably not what you wanted to hear. :-) Seriously, the Format Cells dialog modifies only the selected cells. Sounds obvious thus far, but it means the adjacent cells keep their black borders. Where adjacent cells have different borders, the thicker border is drawn. In your example, the width is the same, so that rule doesn't help, and the border from the bottom or right cell is used. If you want to experiment anyway, see http://wiki.services.openoffice.org/wiki/Development/OpenOffice.org_Building_Guide about how to get the source and build it. Then, ScOutputData::DrawFrame (sc/source/ui/view/output.cxx) for drawing and ScViewFunc::ApplyPatternLines (sc/source/ui/view/viewfunc.cxx) for applying the borders are good starting points. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Problems with BESSELJ
On 07/09/09 12:17, Regina Henschel wrote:
(2) I have tried the following too. Instead of my provisional
return 888.88;
I write
throw ::com::sun::star::uno::RuntimeException();
Now the spreadsheet shows
#VALUE!
in cell and
Error: Wrong data type
in status bar in that cases.
But it shows this, whatever I write in
ScUnoAddInCall::ExecuteCallWithArgs(). I have tried it there with
catch(uno::RuntimeException)
{
nErrCode = errNoConvergence;
}
and (only for testing) with
catch(uno::Exception)
{
//nErrCode = errNoValue;
nErrCode = errDivisionByZero;
}
Where comes the #VALUE! from?
XIdlMethod::invoke wraps exceptions from the add-in in an
InvocationTargetException. You have to extend the handling of that one.
Niklas
-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
Kohei Yoshida wrote: On Fri, 2009-06-26 at 17:19 +0200, Niklas Nebel wrote: In addition to the visual comments on the ux-discuss list Which I assume is this one: http://ux.openoffice.org/servlets/ReadMsg?list=discussmsgNo=3658 Yes, that's what I meant. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/20/09 02:38, Kohei Yoshida wrote: Ok. All my changes related to DataPilot are now in koheidatapilot03 cws. I'm also working on specs on the wiki. They are at: http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_enhanced_field_popup_window http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_custom_display_names The first spec is pretty much complete, while the second one is still being worked on. Also, FYI, I'll be on vacation for the entire next week. So, whatever change still needs to be done will be done after I get back. In addition to the visual comments on the ux-discuss list, some technical remarks (I haven't looked through all of it yet, expect more to come): - Extensions to the DataPilotSource API must be done in a compatible way (see the handling of the Filter property). - We have to pay attention to keyboard accessibility (obvious key choice: Ctrl-D, as for page fields). - The popup window has to implement accessibility API. Generally the easiest way for that is to use existing controls, like SvxCheckListBox for the item selection. For the menu entries a new control would have to be implemented, including the accessibility functions. Perhaps it's also possible to extend the VCL popup menu with an extra window, but I can't guarantee that's even possible without running into new problems. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/25/09 10:17, Xu Ming Wang wrote: We are migrating our work to 3.x code base now. If need, we can extract these parts. Data buffer may need some refactoring work with the class ScDPCacheTable. Extracting smaller parts from your changes would make it much easier to integrate the changes. Especially the performance improvements don't need any User Experience discussion and could be integrated quickly. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/24/09 05:00, Xu Ming Wang wrote: - The data in the Quantify screenshot looks strange. For any larger calculation, screen output (OutputDevice::DrawLine) shouldn't play a significant role. It maybe relate to Quantify environment - drawing is very slow. Actually, ScAttrArray::ApplyBlockFrame is a low performance function. If the output table about 1 rows, ScDPOutput::Output() used 8-10 seconds in our test environment. Current solution, to data area in the table: Case 1: all cells need set border, then setting block frame border only once is ok. Case 2: otherwise, set block frame border like this Applying the frames takes some time in a large output table, that's right. - Data Source buffer sounds interesting. Now it would of course be helpful to see the actual code changes for it. It is something like Excel's PivotCache, and better to save it in the document file. If that, we need the approval of the ODF format proposal relate it. OOo 3.x has a cache (ScDPCacheTable), but it isn't saved, and the results are still created using ScDPItemData. We'll have to see how we can put these things together. Also, you're right, we'll have to clarify the file format handling. - The allocation for all members (B1,B2,B3) is what issue 55266 is about. In the Solution Description section, there's only the heading. Do you have a solution for that? I have a solution in LateInitFrom. To row data, only new ScDPResultMember when find it. Excellent. I had something like that in mind for issue 55266, but never found the time to actually try it. All three changes you mention still seem to be valid and useful for 3.x. How big are the individual changes, is it possible to extract them, so we can try to update them to the 3.x code base? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/23/09 17:24, Zhi Yu Yue wrote: Struggled a little with the wiki editing, and here is the performance part. Thanks, Xu Ming!http://wiki.services.openoffice.org/wiki/Calc/Proposal_DataPilot_byIBM Great, thanks. Some comments: - The data in the Quantify screenshot looks strange. For any larger calculation, screen output (OutputDevice::DrawLine) shouldn't play a significant role. - Data Source buffer sounds interesting. Now it would of course be helpful to see the actual code changes for it. - The allocation for all members (B1,B2,B3) is what issue 55266 is about. In the Solution Description section, there's only the heading. Do you have a solution for that? Not completed, but should be OK to start some discussion. We will then turn to the UX spec. For the UI features, note that Kohei's changes are now available, with a description at http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_enhanced_field_popup_window and http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_custom_display_names. You should take a look at that and see where your proposed changes are different. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?
On 06/21/09 22:57, Regina Henschel wrote: In ODF1.2 draft spec I read, MULTIPLE.OPERATIONS executes the formula expression pointed to by FormulaCell and _all_ formula expressions it depends on while replacing _all_ references to RowCell with references to RowReplacement respectively all references to ColumnCell with references to ColumnReplacement. I think that the terms execute formula expression and while replacing is not exact enough. (1) I interpret it in the way, that I first replace all references, generating intermediate, temp sheets, and then evaluate that sheet. I get the following: The references are replaced dynamically during calculation, not in a separate step up front. The implementation uses a list of active replacements in the document (aTableOpList), no modified copies of the formulas are made. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?
On 06/22/09 17:10, Regina Henschel wrote: Right. A1+A2 is calculated as A1+A6, which is 2+700, or 702. So OOo drops =MULTIPLE.OPERATIONS(A3;A6;A4)? OOo acts as if the formula in A5 is =A3. All references to A6 in A3's formula are replaced with A4. There are none, so the result is A3, unchanged. OFFSET doesn't mix well with MULTIPLE.OPERATIONS because it's one of the functions that cause the cell to be recalculated on any change, like RAND or NOW. So the changed formula depends on the special ALWAYS range, not on A2. That's a matter of implementation, and could probably be changed, but it doesn't look like a high-priority issue. That means, that it is another problem and a real bug and the result should be 18 in both cases? [18= 11 (content of one position after A4)+7 (content of A4)] OOo Later would be OK for me. A bug or a limitation, whatever one might call it, but certainly different from the other case. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/19/09 10:58, Zhi Yu Yue wrote: It spent a little more time than I thought to organize it. Where should I post it? should I create a new wiki page? Thanks. Yes, a wiki page would be good. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] NLP Solver program Levenberg Marquardt
On 06/19/09 14:59, Martina Fares wrote: I'm new here, and I don't know a lot about `to program in OpenOffice`. I want to develope the Levenberg marquardt algorithm in the NLP Solver. I get the source code of the NLP, but now I want to know what I should do if I want to include the source code to netbeans. The NLPSolver extension is a NetBeans project, you should be able to open it directly. Is there some place where I should tell that I want to program the algorithm, so that nobody else look for this algorithm. You just did. :-) You could also create a new page in the wiki (wiki.services.openoffice.org), and describe what you're doing. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Request on some issues
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). :-) - 3007 Hatching fill within a cell Honestly, it doesn't matter. It's well known that this feature is missing, and if we get around to implementing it, we'll find the issue, regardless if it's assigned to requirements or any individual person. Also, I checked other issues that IMO are fixed in the mean time :-) 57298, 27057, 81178, 4880 So I set to fixed. Is it seen as responsible behaviour if I close those myself? Yes. Normally, an issue is closed when the fix was seen in a milestone build. This is done in case a fix gets lost during CWS integration (merge conflicts, etc). If you found them fixed in a milestone already, there's no need for the separate step. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/11/09 10:37, Zhi Yu Yue wrote: I need to check my colleague (Xu Ming Wang) if we can separate the code out. It is possibly a little difficult, but I'm not quite sure. I will update you later once I get the result. However I think the least we can do is to post some of our idea/or code here so that we can start some discussion. How do you think? Are there any updates on this yet? Like you say, it would already help to have a rough overview about your performance changes. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/11/09 05:41, Zhi Yu Yue wrote: I'm new here, so I list my ToDos as below. Please help to advise. 1. Send our UX spec on user experience community for review. - I compared Kohei's list with mine. Most are different and should be fine. One may have some overlap. Kohei, I would appreciate if you can also review the UX spec after I post it. We can solve the conflict at the UX level. 2. Check in the code after UX spec is agreed. I may have more questions at that time. That's a good plan for the UI changes. One thing that doesn't need UX review is the performance improvements. Can you separate the performance changes from the rest? Then we could work to integrate them already in parallel with UX discussion. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] about DataPilot
On 06/11/09 10:37, Zhi Yu Yue wrote: I need to check my colleague (Xu Ming Wang) if we can separate the code out. It is possibly a little difficult, but I'm not quite sure. I will update you later once I get the result. However I think the least we can do is to post some of our idea/or code here so that we can start some discussion. How do you think? Yes, sure, that would help. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] specifications
On 06/05/09 11:03, Ain Vagula wrote: Where can I find specifications about new features in oo.o calc 3.0 and later? http://specs.openoffice.org/calc/index.html shows specifications only for 2.0 and in wiki and documents sections I dont find anything too. Where specifications exist, they are mostly attached to the issues. For smaller or more obvious changes, it's often just a discussion thread on the ux-discuss list, or some comments in the issue. Some are also in the wiki at http://wiki.services.openoffice.org/wiki/Calc/Drafts. Are you looking for anything in particular? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Generating calc spreadsheet from c#
On 05/20/09 09:54, Wayne Douglas wrote: I'm creating a reporting tool using c#, nhibernate, castle monorail and sql server. I'd like to be able to generate spreadsheets on the server which have some grouping, outlining and basic formatting. My questions is this: do I firstly need to have oo installed on the server or can I just pull in the dlls I need and if I can get away with only pulling in the dlls i need - where do i start? :) The OpenOffice.org code works only when installed properly. But you could take a look at the ODF Toolkit Project, http://odftoolkit.org/. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Hi, could some developer answer some questions?
On 05/10/09 10:15, Isaac M. Marcos wrote: I need to solve some bugs in OOfice. I am willing to code if you could point me in the right direction. Great, welcome. Let's assume I am a complete *newb*, Could you guide me to start? The first step is building OpenOffice.org, see http://wiki.services.openoffice.org/wiki/Building_OpenOffice.org. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] About issue 60401#'s behavior.
On 03/27/09 10:09, maoyg wrote: I have a small problem about issue 60401's behavior. for example, the data ranges is from B4 to D8, I select data range from C2 to C5, the cursor's position locate C5, according to cursor's position,I will extend the data range to B4:D8,this behavior is right, then when I select data range from C2 to C5, the cursor's position locate C2, according to cursor's position, it will not extend the data range, the both data range is same,only the direction is different,but the result is different, what do you think of that? I think that's fine. If the detection is based on the cursor position, that's easy to describe and explain. But if the whole column is selected, the range should still be found. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Excel 2003 XML export
On 03/18/09 13:48, Eike Rathke wrote: That's http://qa.openoffice.org/issues/show_bug.cgi?id=96018 We should consider to drop that filter completely... +1 Objections, anyone? We'd still have the same kind of issues with any user-defined XSLT filters. We just wouldn't know it. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Multiline formulae support
On 03/06/09 00:47, William S Fulton wrote: Well, I finally found some time to get back to this, sorry for delays. Tabs and newlines are now replaced with spaces for DDE linking. Please see latest patch: http://www.openoffice.org/issues/show_bug.cgi?id=35913. Is now the right time to set up a CWS as mentioned above or are there any more suggestions for improvement? Great! This looks good now, ready to make a CWS. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] About issue 8302#.
On 03/02/09 08:38, maoyg wrote: I submit the second patch about issue 8302 today, I find a problem when I test it. For example,the merged cells are B2:D2,B3:D3,B4:D4,B5:D5...B40:D40, I selected C column, click Insert Columns,the inserting merged cell is right, I click Undo command,the calc is very slow, because it will mark range from B40:D40,B39:D39... to B3:D3,B2:D2. if the merged cells are B2:D2,B3:D3... to B20:D20,click Undo command,the calc is very quick. this problem is very important, if the user use this feature,he/she will feel the calc is slow. I think this problem is related to the UnmergeCells/MergeCells, can we solve this problem? Do you mean the scrolling of the view, if some of the merged ranges are outside of the currently visible area? That is done by the undo actions for merge/unmerge. To get rid of it, the undo actions would have to know they are part of insert cells, and then not change the view. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Bug with named ranges and validation
On 02/25/09 16:54, Cor Nouws wrote: I experience a bug, must be related to OOO310mx, bug can't pin it down exactly. And what I find in IssueTracker (#97857, #89014, #98174) does not look related. I did some tests with test documents. But cannot (yet) reproduce. However, I can't send the document involved. I'll try to get it clear of course. But just to be on the safe side, here what I have seen so far: It is an .ods (long history) - named ranges on sheet3 - columns with Date|Validity Criteria Allow .. Cell range Name ... - I use the document both in 3.0.1 and OOO310mx - Problem: Sometimes it is impossible to enter data in the columns with validation. Ctr-D shows (iirc) err520 in OOO310mx and #name in 3.0.1 The same appears in the field Source from the dialog, where I can correct the error by re-entering the range name. I can see that in OOO310m1 (in fact caused by issue 98174, the error is in saving the file), but not in OOO310m2. Which is the OOO310mx that you used? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] About Issue 8302#.
On 02/24/09 17:14, maoyg wrote: Last friday, I tested some questions about issue 8302# when inserting cells. For example, the merged cells are from B1:D1,B2:D2,B3:D3 etc... when I selected C column,inserting cell,the merged cells can't be inserted rightly, this problem have been solved on monday.I encounted the other problem again, the merged cells are from B2:D2,B3:D4,B5:D5,B6:D7,B8:D8,B9:D9 etc..., the merged cells can't be inserted from B8:D8,B9:D9 etc... so far,this problem haven't been solved. I debug the program, I find the class ScDocAttrIterator exist some questions, when the merged cell B6:D7 have been unmerged, the data member pArray-pData[nPos].nRow will be changed in ScAttrIterator::Next(...). for example,firstly before inserting, pArray-pData[0].nRow = 0,pArray-pData[1].nRow = 2,pArray-pData[2].nRow = 3, pArray-pData[3].nRow = 5,pArray-pData[4].nRow = 6,pArray-pData[5].nRow = 8,pArray-pData[6].nRow = 65535... when the merged cell B6:D7 have been unmerged, pArray-pData[0].nRow = 0,pArray-pData[1].nRow = 6, pArray-pData[2].nRow = 8,pArray-pData[3].nRow = 65535... I don't know how to solve this problem, Have you any good idea? I assume the data is for column C. Then it looks right. The AttrArray collects ranges of equal attributes in a column, not necessarily each merged range separately. The cells that are covered by a merged cell have a ScMergeFlagAttr that stores if the cells are overlapped horizontally or vertically. In the example before inserting, row 0 (C1) is not overlapped. Row 1 (C2, part of B2:D2) and row 2 (C3, first row of B3:D4) are both overlapped horizontally, so they have the same attribute and only one entry in the AttrArray. Row 3 (C4, second row of B3:D4) is overlapped both horizontally and vertically. The remaining rows are treated similarly. After unmerging B6:D7 (and the cells above that, I assume), the rows up to 6 (C7) are not overlapped, 7 and 8 (C8 and C9) are overlapped horizontally. Row 0 is different because it still has the empty attribute ItemSet, and 1 to 6 contain an Item with the value no overlap. If there is a problem, it's probably in how you use these values. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] color of tabs
On 02/22/09 15:23, Mathias Röllig wrote: Actually selected Tabs are white. But IMO these should have the same color as selected row/column headers resp. unselected tabs should have the same color as like as unselected row/column headers. For consistence. And for a better difference. And these colors come from the theme of the OS. The current colors are from the system, too. The background for the selected tabs is the window background color, not necessarily white (the patch in issue 94452 would break this, but it was fixed before integration). This makes sense for best readability of the sheet name. A different look of the tabs could be imagined, but keep in mind: - The same tab bar is also used in Draw and the Basic IDE. - A more distinct selection background might interfere with the changeable tab backgrounds (issue 5560). So a new look should really be discussed on the ux-discuss list, not here. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] date serial number conversion
On 02/12/09 17:58, Ain Vagula wrote: date serial number 11274306 gives result 31.12.32767, when cell is formatted as date next number, 11274307 gives result 01.01.-32768, year is negative? More interesting results: number date=day() function 123456789027.01.-25840 31 12345678916.03.1223331 12345678 25.04.-29835 31 11274307 01.01.-32768 31 11274306 31.12.3276731 11274303 28.12.3276731 123456 03.01.2238 3 1234518.10.1933 18 Why some years turn to negative? See issue 75335, but note that it's prio 4. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Python on Windows
On 02/04/09 15:53, Erich Neuwirth wrote: I plan to do some development work with Python in OOCalc. I could not find consistent instruction on how to make it work, and the examples in my installation do not work. I also could not find recent official statements about the state of things (probably my fault). Can somebody tell me where to find the information I need, and some examples, i.e. how to make a function defined in Python a worksheet function in OOCalc? The udk-dev list is better suited for Python questions. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] color of tabs
On 02/05/09 11:31, Mathias Röllig wrote: I know that there is work to have tabs with different colors in calc. But i don't know if with this the big problem will be solved that it is difficult to see the difference between marked and unmarked sheets. In my opinion a marked tab should have the same colouring then the heads of marked columns and rows have. There's a wiki page at http://wiki.services.openoffice.org/wiki/User:Danielbw, and currently some discussion (mainly about the dialog) on the ux-discuss list. Let's keep the discussion at one place (ux-discuss), not split it between two lists. Could this be a (easy?) change for OOo 3.1? No, it's too late for 3.1. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 85133
On 01/30/09 10:13, sophie wrote: A patch is provided for this issue and this is a real blocker for a lot of users: http://www.openoffice.org/issues/show_bug.cgi?id=85133 Could you explain me what is needed, and may be enhance the test case so that we can work on this basis? That's a Writer issue. Wrong list or wrong issue number? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] [almost] Crasher is alive for 3 years - issue 55266
On 01/28/09 20:38, Kohei Yoshida wrote: That may be fixed with http://qa.openoffice.org/issues/show_bug.cgi?id=93998 in CWS koheidatapilot02 integrated to DEV300_m37, please check. m39 still tries to allocate 1GB of RAM. Well, the fix in koheidatapiot02 deals with an entire different issue than i55266. So, I'm not at all surprised. That's right. Opposite ends of the calculation, in a way. Fixing i55266 (and probably i97886) needs a non-trivial refactoring since the reason for such large memory footprint may be a design issue. Current data pilot's result computation code uses a recursive algorithm, and each recursion instantiates a new set of objects. Unfortunately, when the number of unique field member values becomes large, which is certainly the case for the above referenced issues, the size of instantiated objects grows, and the memory usage spikes. Note that this algorithm is *not* weak against the total size of a source data, but is weak against the large number of unique field member values. We could first try to minimize memory use without changing the algorithm itself (by reusing some of the same tricks I used to reduce memory usage in the cache table). But if that turns out to be insufficient, then we may have to re-write the algorithm itself, in which case the required effort becomes pretty significant. I don't think this really needs fundamental changes. The recursive structure isn't wrong. To avoid the excessive memory usage, the ScDPResultMember objects in a ScDPResultDimension have to be created on-demand, instead of all in advance. This would require changes to the inter-item calculations (Displayed value) and sorting, so it's not a trivial change, but it seems possible. Speaking of issue 93998, the case of pressing Ctrl-A and starting the data pilot, which took seconds in 2.4, doesn't crash anymore, but the time (and memory) it takes can still be considered a regression. Comparing the problems and benefits of the cache table so far, a rewrite of the results calculation doesn't seem like something we should do. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Re: [allsvn] r265030 - cws/ooxml02/offapi/com/sun/star/sheet
On 12/08/08 21:20, Kohei Yoshida wrote: On Mon, 2008-12-08 at 20:43 +0100, Niklas Nebel wrote: Again, modularization. We want to separate the Excel filter from the sc module, and opcode mapping is part of it. But VBA is not part of the filter, and we need that for VBA. The filter is merely re-using it. There is a fine line between modularization and reusability. To share something between the filter and VBA, it doesn't have to become part of the Calc core. This is now the second change surfacing from ooxml02 which runs contrary to the separation of filter and core. I hope this doesn't become a trend. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Re: [allsvn] r265030 - cws/ooxml02/offapi/com/sun/star/sheet
On 12/08/08 19:34, [EMAIL PROTECTED] wrote: Modified: cws/ooxml02/offapi/com/sun/star/sheet/FormulaLanguage.idl == --- cws/ooxml02/offapi/com/sun/star/sheet/FormulaLanguage.idl Mon Dec 8 18:33:06 2008(r265029) +++ cws/ooxml02/offapi/com/sun/star/sheet/FormulaLanguage.idl Mon Dec 8 18:33:13 2008(r265030) @@ -63,6 +63,11 @@ */ const long NATIVE = 3; +/** Function names and operators as used in the English version of +Excel. This formula language is also used in VBA formulas and +OOXML import/export. + */ +const long XL_ENGLISH = 4; }; No, the map of Excel function names is supposed to be part of the Excel filter, and that's how the import already works. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Re: [allsvn] r265030 - cws/ooxml02/offapi/com/sun/star/sheet
On 12/08/08 20:17, Kohei Yoshida wrote: On Mon, 2008-12-08 at 20:05 +0100, Niklas Nebel wrote: No, the map of Excel function names is supposed to be part of the Excel filter, and that's how the import already works. But what's the drawback? Defining a formula language here makes it easier to use in the filters as well as VBA formula parsing since it fits nicely in the current grammar framework. To me, not doing this would be a kludge. Again, modularization. We want to separate the Excel filter from the sc module, and opcode mapping is part of it. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Application modules become dependent from module oox?
On 11/21/08 18:01, Michael Meeks wrote: That sounds great; just to give a quick rational as to why this approach. While clearly a separate UNO component, or things living in oox is the end-goal, I'm a fan of step-wise re-factoring - such that we can prove that nothing broke during the process, and such that there is only one copy of the code to maintain and develop at any time. My hope is that by adding OOX export here, then going on to re-factor the existing combined filter to use the UNO interfaces to build it's model, we can incrementally move to the point that chipping that whole export chunk off into it's own component (or into oox) becomes easy - while still being to prove that nothing broke. That way, hopefully we get where we want to go, while keeping everything working in the meantime; that is the thinking anyway - does it make sense ? The problem is, we have spent a lot of effort already to keep the filter implementation in oox separate from the application (new APIs and all), and this is something that this change would break. Everybody is asking for modularization, and I don't want to discard all this effort and take a step backward now, with the hope of fixing it some time later. Even start-up performance might be affected, if oox is added as a dependency to sc. So, at the risk of seeing more evil Sun isn't accepting our contributions blog entries: No, ooxml02 can't be integrated as-is. Of course, the way to avoid such situations in the future is to discuss these things before starting the implementation. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Please add CSV-export to Export-Dialog
On 10/30/08 00:51, Leonard Mada wrote: Please add the CSV-format to the Export-Dialog as suggested in issue 32684. http://www.openoffice.org/issues/show_bug.cgi?id=32684 See issue 11393. That would be a change in framework, not in Calc. Currently, Export shows those formats that only have export, not import, filters. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Filling dates in Calc
On 10/30/08 01:10, Leonard Mada wrote: What do you mean as simple fill? If I select 2 or more equal dates, and try to fill, the date still gets incremented. This is not the case with ordinary numbers. This is the reason, I supposed that the fill is broken (and basically it is, because it doesn't work as for simple numbers). Strangely, filling using the menu works as expected (though you can't trigger increment on). Two numbers lead to linear fill, no special handling for the equal case there. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Examine changes for ODFv1.2
On 10/10/08 02:44 PM, Regina Henschel wrote: in discussion with Eike the idea has come up, to examine which changes are necessary to adapt the functions to ODF1.2, especially examine the distributions. First I thought to write a document, but now I have the idea to track it in the Wiki. My plan is a page like http://wiki.services.openoffice.org/wiki/User:Regina/MyDrafts So everyone can see what is already done, in progress, or need to be done, and the examination can be done successively as time is available. Do you agree? If yes, please tell me a place, to put it. If yes, do you have any suggestion for improvement? Is it limited to ODFF? Then it would fit nicely below http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] How to handle ODFF constrain number must be integer?
On 09/27/08 20:06, Regina Henschel wrote: In the ODFF draft spec of CHISQDIST is a constraint for the parameter 'degrees of freedom' to be integer. Shouldn't the argument type be integer instead? Should I implement it: (1) break with an illegal argument error, if the value is not an integer or (2) round the value to an integer. The current implementation of the complement function CHIDIST rounds the incoming value, but the spec has the same constraint for LEGACY.CHIDIST. I would prefer version (2) to make it consistent with existing CHIDIST. And changing CHIDIST too, I consider to dangerous, because existing documents might no longer work. Yes, for the implementation, let's stay consistent with the other functions, that is, truncate (not round) the value. The current implementations of CHIDIST and CHIINV have a constraint 'degrees of freedom 1.0E5'. The spec don't have such restriction nor mention that they might be necessary. The code has no comment, why this constraint has been introduced. Can you tell me? Huge values might overflow oder underflow somewhere, but is that reason enough to reject them from the beginning? The old implementation (before issue 90703) looks like it couldn't handle large values. If you're confident that the current implementation is better, I think that constraint can be removed. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Style of strings in sc/source/ui/src/scfuncs.src
On 09/26/08 17:50, Regina Henschel wrote: I'll introduce new functions and I'm uncertain, how I should write the strings in the mentioned resource file. (1) Upper or lower case? If I give the type of the parameter, should I use lower or upper case, for example Number or number? Same if I give the name of the parameter, for example alpha or Alpha? Name, not type, see below. It's not really consistent in the existing functions, so one could say it doesn't matter. Probably better to use upper case, because an all-lower-case string can always be generated. (2) Excel shows a tooltip when you enter a function, for example (German) 'GAMMAVERT(x;Alpha;Beta;Kumuliert)'. Will there be a similar feature in OOo? If yes, will the tooltip be generated from the part 'Name of Parameter' of the resource file? Something similar is in progress, see issue 86856. The same kind of summary is already visible in the Function Wizard, if you select a function, before double-clicking or selecting Next, or if you double-click a function in the Function List window (one is with optional parameters, the other without). All of them use the Name of Parameter x strings. (3) Should the type be combined with the name? For example Cumulative (logical) or only the type Logical or name Cumulative and the other information in the description? Just the name. In some functions the parameter name is value or text, but here it should be just Cumulative. (4) Are there any restrictions in the length of the strings 'Description', 'Name of Parameter' and 'Description of Parameter'? There's no fixed string length limit, but if they are too long, they won't fit into the Function Wizard dialog. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Patch increasing goal seek accuracy
On 08/19/08 18:51, sophie wrote: Can any body have a look to the patch on this issue: http://www.openoffice.org/issues/show_bug.cgi?id=92552 It is very small, Kohei has made comments on it. Its integration will really help several of our users :) Would your users be happy with 1E-4, or do you need 1E-6? Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Calc Very Slow
On 08/12/08 22:14, Leonard Mada wrote: I did install OOo-dev m29 and this version is clearly more responsive. I opened the same files, SeaMonkey is active again, and the Internet is also on the point of continously crashing, so basically same conditions, but the Menu pop ups fast enough, and scrolling is also more fluent (processsor speed jumps up to 92%, but this is probably an MS Win2k issue). With WinAmp paused, it is quite OK. When scrolling quickly, a high CPU usage is completely normal: You scroll a bit, new cells become visible and have to be drawn. If, by the time that drawing is finished, you have already scrolled further, the CPU is used without much pause. Nothing unusual or dangerous about that. Though I noticed something else: when a row is selected, the scrolling speed drops substantially. I cannot accurately quantify, but it is clearly visible (and I would say it is a couple of times lower). So overall, I would say m29 is faster. If the previously failed install was the culprit, I have no idea. Even so, it seems a good idea to improve the speed even further. It bothers me that the row selection has such a dramatic effect. If the selection is visible, there is some extra work to do. But for me, it doesn't have a noticeable effect. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
