Re: [sc-dev] about DataPilot

2009-08-03 Thread Niklas Nebel
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

Re: [sc-dev] about DataPilot

2009-08-13 Thread Niklas Nebel
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 fi

Re: [sc-dev] Accessing the Calc Formula Bar Input Line

2009-09-14 Thread Niklas Nebel
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 direc

Re: [sc-dev] How to test a patch?

2009-09-14 Thread Niklas Nebel
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.ope

Re: [sc-dev] Accessing the Calc Formula Bar Input Line

2009-09-15 Thread Niklas Nebel
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

Re: [sc-dev] What are valid arguments for INDIRECT

2009-09-21 Thread Niklas Nebel
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(

Re: [sc-dev] What are valid arguments for INDIRECT

2009-09-22 Thread Niklas Nebel
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

Re: [sc-dev] [Issue 47600] Patch

2009-09-25 Thread Niklas Nebel
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 n

Re: [sc-dev] Create an Extension for the Solver

2009-09-29 Thread Niklas Nebel
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

Re: [sc-dev] API for Calc Input Line

2009-10-09 Thread Niklas Nebel
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

Re: [sc-dev] API for Calc Input Line

2009-10-09 Thread Niklas Nebel
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 e

Re: [sc-dev] Automatic URL Recognition

2009-11-02 Thread Niklas Nebel
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

Re: [sc-dev] working with multiple spreadsheets

2009-11-09 Thread Niklas Nebel
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 wh

Re: [sc-dev] Calc Background Color Picker Suggestion

2009-11-09 Thread Niklas Nebel
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

Re: [sc-dev] Microsoft testing Excel for supercomputers

2009-11-19 Thread Niklas Nebel
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

Re: [sc-dev] Creating a run-time dialog

2009-12-08 Thread Niklas Nebel
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 wor

Re: [sc-dev] Linker error on adding a new module to the sc project

2009-12-15 Thread Niklas Nebel
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 calle

Re: [sc-dev] Data - Refresh range - deletes formatting

2010-01-20 Thread Niklas Nebel
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, becaus

Re: [sc-dev] Please help with bug 108720

2010-01-28 Thread Niklas Nebel
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 na

Re: [sc-dev] improvements to openoffice calc

2010-02-15 Thread Niklas Nebel
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 t

Re: [sc-dev] improvements to openoffice calc

2010-02-15 Thread Niklas Nebel
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 ? Th

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

2010-03-25 Thread Niklas Nebel
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

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

2010-04-06 Thread Niklas Nebel
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++ Builde

Re: [sc-dev] Reading and writing to cells

2010-04-06 Thread Niklas Nebel
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

Re: [sc-dev] Functions in Excel 2010

2010-04-06 Thread Niklas Nebel
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 function

Re: [sc-dev] Reading and writing to cells

2010-04-06 Thread Niklas Nebel
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 s

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

2010-04-12 Thread Niklas Nebel
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 progra

Re: [sc-dev] Issue 109940

2010-04-14 Thread Niklas Nebel
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, in

Re: [sc-dev] optional (soft) hyphen in spreadsheets ...

2010-04-15 Thread Niklas Nebel
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

Re: [sc-dev] constraint of x in sin(x) in scaddins

2010-05-10 Thread Niklas Nebel
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 co

Re: [sc-dev] constraint of x in sin(x) in scaddins

2010-05-11 Thread Niklas Nebel
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

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

2010-05-17 Thread Niklas Nebel
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

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

2010-05-17 Thread Niklas Nebel
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 p

Re: [sc-dev] HelpID for imaginary trigonometric functions

2010-05-17 Thread Niklas Nebel
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

Re: [sc-dev] Range Highlighter Anchor Handle

2010-05-31 Thread Niklas Nebel
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

Re: [sc-dev] Validator for Calc

2010-06-04 Thread Niklas Nebel
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

Re: [sc-dev] Validator for Calc

2010-06-04 Thread Niklas Nebel
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. Ex

Re: [sc-dev] Validator for Calc

2010-06-04 Thread Niklas Nebel
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 ori

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-07 Thread Niklas Nebel
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 -

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-08 Thread Niklas Nebel
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

Re: [sc-dev] Conditional Formatting with newly inserted cellstyle (Java)

2010-06-08 Thread Niklas Nebel
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.

Re: [sc-dev] Statistical Data Analysis Tool

2010-06-16 Thread Niklas Nebel
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

Re: [sc-dev] Statistical Data Analysis Tool

2010-06-16 Thread Niklas Nebel
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 -

Re: [sc-dev] Pitanje u vezi sa temom za praksu za studente.

2010-06-16 Thread Niklas Nebel
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

Re: [sc-dev] Tab color

2010-06-21 Thread Niklas Nebel
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.open

Re: [sc-dev] Component to check spreadsheet documents for potential errors for the OpenOffice.org Summer 2010 Internship - Oren Zeev-Ben-Mordehai

2010-06-24 Thread Niklas Nebel
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

Re: [sc-dev] Optimization NLPSolver

2010-06-28 Thread Niklas Nebel
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

Re: [sc-dev] XViewFreezable

2010-06-28 Thread Niklas Nebel
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

Re: [sc-dev] Drawing layer: comments and AWT controls

2010-07-01 Thread Niklas Nebel
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

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-07-06 Thread Niklas Nebel
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 -

Re: [sc-dev] Include file error

2010-07-06 Thread Niklas Nebel
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 shou

Re: [sc-dev] Include file error

2010-07-07 Thread Niklas Nebel
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

Re: [sc-dev] "queryColumnDifferences" working wrongly ?

2010-07-09 Thread Niklas Nebel
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 addre

Re: [sc-dev] crashes in m84

2010-07-12 Thread Niklas Nebel
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 ..

Re: [sc-dev] Include file error

2010-07-19 Thread Niklas Nebel
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, whi

Re: [sc-dev] Include file error

2010-07-19 Thread Niklas Nebel
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 pr

Re: [sc-dev] Include file error

2010-07-19 Thread Niklas Nebel
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

Re: [sc-dev] Validator for Calc

2010-07-20 Thread Niklas Nebel
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 tas

Re: [sc-dev] Include file error

2010-07-20 Thread Niklas Nebel
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

Re: [sc-dev] Range selection and UNO awt

2010-07-23 Thread Niklas Nebel
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.

Re: [sc-dev] XChartDataChangeListener and inserting rows

2010-09-20 Thread Niklas Nebel
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 mo

Re: [sc-dev] vlookup issues ...

2010-09-28 Thread Niklas Nebel
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

Re: [sc-dev] How to access cell values in a cell range in Calc add-ins?

2010-10-18 Thread Niklas Nebel
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.XCellRangeAddress

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

2010-10-27 Thread Niklas Nebel
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);

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

2010-10-28 Thread Niklas Nebel
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 stuf

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

2010-10-28 Thread Niklas Nebel
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 805

Re: [sc-dev] Issue 83783

2010-10-29 Thread Niklas Nebel
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 A

Re: [sc-dev] Issue 83783

2010-11-01 Thread Niklas Nebel
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 O

Re: [sc-dev] Issue 83783

2010-11-02 Thread 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.

Re: [sc-dev] Issue 83783

2010-11-02 Thread Niklas Nebel
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

Re: [sc-dev] overview of interoperability with functions Calc <> Excel ?

2010-12-01 Thread Niklas Nebel
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.

Re: [sc-dev] Help with SC wiki template

2010-12-06 Thread Niklas Nebel
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

[sc-dev] Re: type logical in Excel

2011-03-01 Thread Niklas Nebel
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

[sc-dev] Re: c.s.s.XDataPilotFieldGrouping - how does createNameGroup() work ?

2011-03-08 Thread Niklas Nebel
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<

[sc-dev] Re: Internship 2010: Statistical Data Analysis Tool

2011-03-28 Thread Niklas Nebel
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 implement

[sc-dev] Re: Internship 2010: Statistical Data Analysis Tool

2011-03-28 Thread Niklas Nebel
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 r

[sc-dev] Re: Calc Watch Window

2011-03-29 Thread Niklas Nebel
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 writin

[sc-dev] Re: Insert Sheet - Before or After?

2011-04-08 Thread Niklas Nebel
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.servic

[sc-dev] Re: oo 3.x: hiding columns in large spreadsheets sometimes very slow

2011-06-23 Thread Niklas Nebel
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 N

[sc-dev] Farewell

2011-09-04 Thread Niklas Nebel
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

Re: [sc-dev] RangeSelection

2005-01-18 Thread Niklas Nebel
Kohei Yoshida wrote: My proposed patch is up attached to the issue. I have assigned the issue to you, Niklas. As I said in the issue, the change is pretty small that it shouldn't affect the existing functionality. Yes, looks about right. But we're supposed to be feature-complete for 2.0, so I do

Re: [sc-dev] support Mongolian in SpreadSheet

2005-01-18 Thread Niklas Nebel
Jiayanmin wrote: > In order to support Mongolian in "SpreadSheet", I want to make table > in sc displayed vertically. I'm not sure where I begin with. What exactly is it supposed to look like? Columns and rows switched? A different default text direction in cells? Different rules for displaying co

Re: [sc-dev] MultiThreaded Spreadsheets..

2005-01-18 Thread Niklas Nebel
Safee wrote: I wanted to know how can we make a multithreaded spreadsheet from a single threaded one which we may already have? What do you mean? Changes to OOo, or to some other code? If it's some other code, then it depends on that code's architecture. Niklas ---

Re: [sc-dev] MultiThreaded Spreadsheets..

2005-01-19 Thread Niklas Nebel
Safee wrote: The code which i have is for TideStone Formula One ActiveX Spreadsheet.. I wanted to know "IF" we can multithread a spreadsheet..depending on any general design patterns available for Spreadsheets.. And what are you trying to achieve? Allow modifications to a spreadsheet from several

Re: [sc-dev] support Mongolian in SpreadSheet

2005-01-19 Thread Niklas Nebel
Jiayanmin wrote: > Because Mongolian text displays from top to bottom, from left to > right, I want the table in sc look like the picture in my attach. If all horizontal/vertical coordinates are swapped, it might be possible to handle most of it on the VCL level (OutputDevice). OutputDevice alread

Re: [sc-dev] Function wizard: language in field result=de

2005-01-20 Thread Niklas Nebel
Peter Eberlein wrote: Sorry, Typo, meant either. i installed m69 without language pack. The boolean in the result field is neither "WAHR" or "FALSCH" (and the content in the corresponding cell too). This is part of number formatting, which depends on the "Locale setting" configuration in the opti

Re: [sc-dev] OpenOffice Usability and Features

2005-01-25 Thread Niklas Nebel
Chris Calvin wrote: 1. Cut Column or Row ( or Range) followed by Insert Cut Cells. This has the affect of quickly moving rows or columns. Range can be used but unless the cut and insert take place in the same column or row, the results can be messy. In either case, references are updated to fo

Re: [sc-dev] int to ostringstream crashes Calc

2005-02-03 Thread Niklas Nebel
eric . wrote: if my Calc addin attempts to pass an integer to an ostringstream, Calc crashes. i write a simple Calc addin containing one formula including the lines below std::ostringstream s1; s1 << 5; Calc blows up on the statment "s1 << 5;". the code runs OK on Windows, it only

Re: [sc-dev] int to ostringstream crashes Calc

2005-02-04 Thread Niklas Nebel
eric . wrote: so i think the problem relates to Calc in some way. how do i investigate this further? i'm thinking of rebuilding office from source so that i can debug, are there less drastic things i should try first? My next guess would be some library version incompatibilities, see http://ud

Re: [sc-dev] Validation of spreadsheet functions

2005-02-07 Thread Niklas Nebel
Paul J Ray wrote: I am new to OpenOffice Calc, but have quite a bit of experience with Excel. What is involved in validating spreadsheet functions? I would like to help, but have very little programming experience. I work with MS Office 2003 and Windows XP Professional. Programming isn't require

Re: [sc-dev] Solver addin based on Octave dll

2005-03-11 Thread Niklas Nebel
Вадим Карп wrote: Are there a solver for linear and non-linear programming in OOffice? I have not found it. If there are not we could make an add-in using Octave libraries. Octave is a project like MatLab but very small and under GNU (see www.octave.org). GPL libraries aren't suitable for inclusio

Re: [sc-dev] Spreadsheet Regression Tools

2005-03-30 Thread Niklas Nebel
Le Farfadet Spatial wrote: Just wondering, When do you think the Statistical data annalisis tools, especially the regression line for the spreadsheet chart, will be done? I have already work on some regression stuff, that you can find on issue 25478. The code already available on this issue c

Re: [sc-dev] Solver addin based on Octave dll

2005-03-31 Thread Niklas Nebel
Kohei Yoshida wrote: Although it's a long-term project, I'm working toward creating an optimization solver component for Calc. Still not sure if this will ever materialize (hope it will), but at least I'm working on it. I am also working on creating a public website for this. http://kohei.us/ooo/s

Re: [sc-dev] Solver addin based on Octave dll

2005-04-01 Thread Niklas Nebel
Kohei Yoshida wrote: With this one, since this is not linear, the linearity test should fail. I still don't know wether the linearity test can be done by merely changing the cell values. But this seems like the only case where the descent parser may be necessary. But again, I may still be over-c

Re: [sc-dev] Statistical tool used within Sun

2005-04-05 Thread Niklas Nebel
Kohei Yoshida wrote: In this blog entry by well-respected Mr. Tenhumberg http://blogs.sun.com/roller/page/dancer/20050404#just_switch_staroffice_add_in near the end of the article, there is a mention of "a statistical tool that is used within Sun". I hope I'm not being too nosy, but is this some

Re: [sc-dev] Adding a page number in the header/footer

2005-04-14 Thread Niklas Nebel
Kohei Yoshida wrote: When I try to create a service object "com.sun.star.text.textfield.PageNumber" from the SpreadsheetDocument, I get an "NoSuchServiceRegistered" (or something similar) exception. So, I'm at a loss on getting a page number object to insert into an XHeaderFooterContent object. It

Re: [sc-dev] Feature Request - Charting

2005-05-03 Thread Niklas Nebel
james haischer wrote: I was looking for this in OO 2.0 but I haven't found it. That is the ability to insert a Chart as a new page (sheet). Clicking on that tab would bring the chart which would fill up the entire sheet. It would print off as a full page. This is similar to what is available in

Re: [sc-dev] inputing infinity into a calc cell?

2005-05-25 Thread Niklas Nebel
Sander Vesik wrote: how do I get the value of a cell to be +INF / -INF? the obvious way doesn't work :( Infinity isn't supposed to be in a cell. An infinite result from a formula is considered an error, and the error message (Err:503) is shown. Issue 47724 exists to distinguish between diffe

Re: [sc-dev] inputing infinity into a calc cell?

2005-05-25 Thread Niklas Nebel
Sander Vesik wrote: Infinity isn't supposed to be in a cell. An infinite result from a formula is considered an error, and the error message (Err:503) is shown. Issue 47724 exists to distinguish between different errors, but it would still be an error flag, not infinity value. So I can't do i

Re: [sc-dev] Table protection and undo

2005-05-30 Thread Niklas Nebel
Paolo Mantovani wrote: If I protect a sheet with password and after I press the UNDO button, the sheet is unprotect without any password maybe you think that this isn't a real problem, because If you save and reopen the file, you will not allowed to unprotect the table without insert the pass

<    1   2   3   4   5   >