[sc-dev] Farewell
In case anyone is still reading these lists: I have left Oracle and started a new job, not related to OpenOffice.org. Because of this, I won't have enough time for any meaningful participation in the "new" OpenOffice.org at Apache. So it's time for me to say goodbye. OpenOffice.org has always been great fun for me, so I'm happy to see some familiar names in the Apache project, which makes me confident they will be able to continue the success of OpenOffice.org. Thanks everybody for a great time! 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: 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: Internship 2010: Statistical Data Analysis Tool
On 25.03.2011 15:42, Regina Henschel wrote: There has been the project 'Internship 2010: Statistical Data Analysis Tool'. On Wiki http://wiki.services.openoffice.org/wiki/OpenOffice.org_Internship/Projects/2010/Statistical_Data_Analysis_Tool I read in 'Project Status' the sentences "The implementation of the data analysis tool project has been completed. The analysis tool has all the above mentioned analysis methods covering variety of statistical aspects." But where can I find the results? 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. 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] overview of interoperability with functions Calc <> Excel ?
On 12/01/10 13:00, Cor Nouws wrote: Is there any overview of interoperability issues with functions Calc <> Excel? What I already know/have found, is the following: - http://wi.wu-wien.ac.at/rgf/diplomarbeiten/Seminararbeiten/2009/200901_Mueller/20090116_Functions_Macros_OOo_Excel_MuellerFranz.pdf Looks rather comprehensive, but is 2008, and not so accessible. - http://wiki.services.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions Is very good, but only new 2010-functions. - http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category A good overview, but not for interoperability issues (may be mentioned in individual pages of course, such as in this example http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MATCH_function ) - http://www.oooauthors.org/english/userguide2/published/mg-published The older migration guide, which is not so specific on the subject. - http://tinyurl.com/2edw8pl a query on IssueTracker with Calc and ms_interoperability. There's also the old "Function Validation" Summer of Code project at http://sc.openoffice.org/servlets/ProjectDocumentList?folderID=504, maybe a bit outdated. Is there any straight away overview? None that I know of. 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/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. Displaying the icons in OO documents will touch the document format and Oasis must accept this, won't it? That has been in the file format for ages. 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] View Settings was: Dispatching AutoComplete for cell values
On 10/28/10 15:23, Peter Eberlein wrote: Tried in m84 the property ShowCharts=2 without success. ( http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/View_Settings ) Is this documented, but not implemented? The placeholder display was removed a while ago, see issue 80528. The API implementation now treats 2 (placeholders) like 0 (show). 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] XChartDataChangeListener and inserting rows
On 09/20/10 09:04, Peter Eberlein wrote: if the subject listener is implemented on a sheet, a ChartDataChangeEvent is fired, when nonempty rows are deleted. It is not fired when a row has been inserted. Which listener should be implemented to catch such a user action? To get notified about modifications, it's better to use addModifyListener (XModifyBroadcaster). 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] 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] 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 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] 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 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] 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] Include file error
On 07/06/10 16:31, rashi dhing wrote: 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 ? Header files in core/inc should be included only from the core directory. Using ScInterpreter directly isn't a good idea anyway. Where formulas are calculated (like validity or conditional formats), we always use ScFormulaCell. 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 07/06/10 13:47, rashi dhing wrote: So does this mean that if I create a matrix formula range and call PushMatrix, I will have the result displayed on the sheet ? Yes, you get the same behavior as with the MUNIT function. See ScInterpreter::ScEMat for the implementation of MUNIT. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Drawing layer: comments and AWT controls
On 07/01/10 10:59, Peter Eberlein wrote: even if uno awt control are set to background in a sheet, comments are neither really readable with "mouse hover" nor with setting permanently visible. They are behind the controls. Found http://qa.openoffice.org/issues/show_bug.cgi?id=108293 for that. Can somebody confirm and set a target? See issue 10621. In "live" mode, controls use their own VCL windows. 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] 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] 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] Tab color
On 06/18/10 21:05, PC Maker wrote: Please include in the windows versions of Calc "tab color" functionality as it is in Linux versions. It would be a great improvment . You can follow the state of that issue at http://qa.openoffice.org/issues/show_bug.cgi?id=5560, or http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalctabcolor for the child workspace. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Pitanje u vezi sa temom za praksu za studente.
On 06/16/10 17:08, Nikola Stojic wrote: Zainteresovan sam da kao praksu za studente radim na temi Calc/Chart: Component to check spreadsheet documents for potential errors. Mozete li mi molim vas reci da li je tema jos uvek aktuelna, i nesto vise o temi. Mails to this list should be in English. There have already been some applications for this project, I don't know if additional ones are still accepted. You could ask on the general internship mailing list, interns...@openoffice.org. The error checking component could be an extension. See http://wiki.services.openoffice.org/wiki/Extensions_development for information about extension development. There is no specification yet about the UI and the details of the errors that can be handled. You would have to come up with some ideas here. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Statistical Data Analysis Tool
On 06/16/10 13:02, Miloš Hadžić wrote: Does this mean that you have enough qualified people for the Statistics Tool project or for the whole internship? I don't know about the state for the whole internship. There's a mailing list interns...@openoffice.org, you could ask there. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Statistical Data Analysis Tool
On 06/16/10 02:42, Miloš Hadžić wrote: I'm interested in tackling this problem for this years internship and have a few questions. Some others have already applied for this project. I think the application form is going to be disabled soon (but I'm not sure about that). What's the status of this project and what are the current priorities? I've seen the GSoC project from 2007 "Integrating R with Calc". Is R integration still considered the best way to add more advanced statistical functionality to Calc and would I be building on top of Wojciech Gryc's code? No, this project should preferably contain a fixed set of methods implemented directly in the extension, as opposed to the generic approach of the R integration. 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] 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] Absurd behaviour while displaying values in a range of cells
On 06/07/10 09:12, rashi dhing wrote: I do need to display the result of my function in a range of cells. How can I facilitate that in this scenario ? You can return an array and display it in an array formula (the kind of formula you get with Shift-Ctrl-Enter). 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] 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 09:12, Kálmán „KAMI” Szalai wrote: We are working on a Validator that checks the formulas, cells, etc in Calc. The extension is written in Java. What is the main conditions that we should check and fix? Currently we are checking for reference to empty cell refelence to text cell non used value cells in formulas. What other validations should we do? Maybe we can select some from this list: http://documentation.openoffice.org/manuals/oooauthors2/0315CG-CalcErrorCodes.pdf We have that on the list of suggested projects for the OpenOffice.org Internship (http://wiki.services.openoffice.org/wiki/OpenOffice.org_Internship/ProjectProposals). Maybe you want to be the mentor for one of the students to define and implement additional checks? Also we created an extension for Watch Window but we had problem with R1C1 notation. Kohei was so kind to patch it, then we had problem with references in some system. All extension is opensorce, so I can send the code, or the extension for analysis. Is it in the extensions repository? Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Range Highlighter Anchor Handle
On 05/30/10 10:54, rashi dhing wrote: Whenever a range is referenced, there is this anchor handle that allows one to grow or resize the selected range. Now the anchor only appears whenever the focus is in the inputline. I am trying to find the function that is responsible for the anchor to appear. I came across the * ScGridWindow::CreateAnchorHandle* function but don't think it is really useful. Can you let me know which is the relevant function ? Do you mean the rectangle at the lower right corner of a reference range? That is part of the range highlighting when you start editing an existing formula, not when you input a new reference. It doesn't matter if the focus is in the input line or the cell area. It's drawn in ScOutputData::DrawRefMark if bHandle is set (called from ScGridWindow::Draw). ScGridWindow::CreateAnchorHandle is for the anchors of drawing objects. 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] 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] 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] 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/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
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/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] Debug the Calc Source Code
On 04/06/10 09:03, rashi dhing wrote: Hi ! Is there a good debugger which can be implemented on the source code of openoffice inorder to step into the lines and add break points at various locations of the code. I am using Cygwin on Windows to compile and build the code. Are "gdb" and "C++ Builder" good options ? Would it involve loading all the files into the debugger or just the exe file (scalc.exe for the sc project) ? You can use the Microsoft debugger, see http://www.openoffice.org/servlets/ReadMsg?list=dev&msgNo=23888. 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/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] 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] 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, drag&drop is started. In 3.0 on Mac, drag&drop 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] Linker error on adding a new module to the sc project
On 12/15/09 15:00, rashi dhing wrote: Hi , I've been having a hard trying trying building a new module (directory) that I added to the "sc" project. I am using cygwin in windows to do the build. I want to parse the formula string that is entered in the formula bar and i created a new class called "ScParser" under the sc/source/ui/parser directory that does the parsing where "parser" is the new dir that i created. I added a makefile for that directory and included the header file in the "inc" directory under "ui". I also changed the build.lst to include my module. A method of this class is to be called in the "inputwin.cxx" file which is in sc/source/ui/app. While the compiling of the scparser.cxx has no errors and creates an .obj file , i get a "LNK2019" for the line in "inputwin.cxx" where i am calling the method of the "ScParser" class. The error is unresolved external symbol . I just cannot figure out what am i doing wrong ! Any one has any idea ? If there's a new directory where a new library is built, that library has to be included in sc/util/makefile.mk. But in most cases it's better to add a file to one of the existing directories (sc/source/ui/app could be a candidate), instead of having a new directory with only one file. 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] Calc Background Color Picker Suggestion
On 11/06/09 14:52, van Staden wrote: Would it be possible that if a cell is selected and the Background color picker opened, the color already assigned to that cell be highlighted as it is frustrating to try and figure out what color was utilised. It's probably possible, but there is also the opposite request to not show the current color even in the toolbar button, see issue 10864. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] working with multiple spreadsheets
On 11/07/09 22:06, Sebastian Queißer wrote: I discovered issue #44079 [1] where someone requests at least the MS Excel feature for arranging different opened sheets. I cannot imagine that my proposal is so hard to implement. I'd like to have a look at the code, could anyone give me some hints where to start looking at? The implementation of "New Window" could be a good place to start. It's a single implementation for different document types, in sfx2/source/view/viewfrm.cxx, see handling of SID_NEWWINDOW. 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] API for Calc Input Line
On 10/08/09 15:10, rashi dhing wrote: I wanted to know if the Calc Input line and all its properties like text, font, colors etc. could be made available through the API. Does anyone have any experience dealing with the Input line ? Do you mean if the API could be extended to include the input line? Sure, that seems possible, but there are no plans to do so currently. The input line's content is kept in the EditEngine, so any API implementation could be similar to that of cell contents, which also uses EditEngine for the text interfaces. 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/21/09 22:56, Regina Henschel wrote: =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. So what is a 'reference'? For ISREF the help say, "Tests if the argument is a reference. Returns TRUE if the argument is a reference, returns FALSE otherwise." Taking that, D1:D3!C2:E2 is a 'reference'. The result of the expression is a reference, just like the result of "OFFSET(A1;A2;A3)". As part of a formula, like your ISREF example, the expression is evaluated, and the ISREF function only handles the result. For INDIRECT, the parameter is a string, which may be the result of some other calculation, but the string isn't parsed and evaluated before it's passed to 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] 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] 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] 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] 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] Improvement for Cell Range Picker of the Validity dialog
On 07/27/09 03:45, Yan Peng Guo wrote: What do mean a patch? A source code package or something else? Thanks for the code, find some comments 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] Improvement for Cell Range Picker of the Validity dialog
Yan Peng Guo wrote: What do mean a patch? A source code package or something else? Yse, a source code diff with the changes. Niklas - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Improvement for Cell Range Picker of the Validity dialog
On 07/23/09 10:34, Yan Peng Guo wrote: We (IBM) has done an improvement for Cell Range Picker of the Validity modal dialog, and would like to contribute the code back. Currently, in OO3.1, if a user selects "Cell Range" in "Allow" list of the Validity dialog, (s)he has to input the range manually, unlike other modeless dialogs having cell range picker function, which have a shrink button to switch to range picker mode, or can directly select a range from the editing area, such as "Consolidate" dialog and so on. We enabled a shrink button besides the range source list-box of the Validity dialog so that users can click it to switch to range picker mode. And when focus is in the range source list-box, the Validity dialog will switch from modal to modeless so that users can directly select a range. If focus is moved out from the list-box, the dialog will switch back to modal again. If we would like to contribute the code, any advise would be appreciated. That sounds good. Do you have a patch available? Then it would be best to attach it to issue 66484, so I can take a closer look. 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
Regina Henschel wrote: The list of types for which headers are made is in UNOTYPES in makefile.mk. Just add the new one there. Here? /scaddins/source/analysis/makefile.mk Yes. Shall I remove it from /offapi/com/sun/star/sheet/makefile.mk ? No, that's needed, too, so it is put into the rdb file that's used to generate the headers in scaddins. 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
Regina Henschel wrote: c:\softwarearchiv2\odff06\scaddins\source\analysis\bessel.hxx(35) : fatal error C1083: Cannot open include file: 'com/sun/star/sheet/NoConvergenceException.hpp': No such file or directory I see the file NoConvergenceException.hpp in C:\SoftwareArchiv2\odff06\solver\300\wntmsci12.pro\inc\offuh\com\sun\star\sheet and in C:\SoftwareArchiv2\odff06\offuh\wntmsci12.pro\inc\offuh\com\sun\star\sheet What goes wrong here? The scaddins module doesn't use the headers from offuh, but creates its own ones. This is done in part to bring it closer to being a pure UNO component (it isn't really one because it depends on tools for the resource files), and in part because it's needed for the own interfaces anyway. The list of types for which headers are made is in UNOTYPES in makefile.mk. Just add the new one there. 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=discuss&msgNo=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] 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
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/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] How should MULTIPLE.OPERATIONS calculate?
On 06/22/09 15:11, Regina Henschel wrote: That makes it not clearer and I do not see by which rules OOo results in 702. Would you be so kind to give a step by step calculation? And besides the question what OOo does, there is the question whether that conforms to the spec. Calculation starts in (A7=)MULTIPLE.OPERATIONS(A5;A2;A6). This means, "Take the formula in A5, replace all occurrence of A2 with A6 and calculate the formula then". Right? So instead of calculating (A5=)MULTIPLE.OPERATIONS(A3;A2;A4) OOo calculates "=MULTIPLE.OPERATIONS(A3;A6;A4)". And now? If I understand the spec correct, then OOo has to go to A3 and look whether it depends on A2 and replace A2 with A6 if so. Right. A1+A2 is calculated as A1+A6, which is 2+700, or 702. If the formula on which a cell depends is a simple operation like + or * (as in the examples in the spec), then it makes no difference, when the replacement is done. In addition, it makes no difference whether you use the reference or use already the value to which the reference points. But here it is more complex and need to be defined. Another example, again enter in column A. 2 3 5 7 11 13 17 19 =OFFSET(A2;1;0) =A9+A2 =MULTIPLE.OPERATIONS(A10;A2;A4) Try the same with =OFFSET(A2;1;0)+A2 in cell A10 instead of =A9+A2 I would expect the same result, but it isn't. 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. 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] 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] 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] 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] 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