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

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

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

Re: [sc-dev] Optional argument in Calc Add-in function

2005-07-25 Thread Niklas Nebel
Kohei Yoshida wrote: All went well, but now I need to make some arguments in some functions optional, by providing a default value for them. How do I do that? Do I do it in the IDL definition, or in one of those overloaded member functions of com.sun.star.sheet.XAddIn ? In the IDL. Among an

Re: [sc-dev] Calc File Loading Compared to Excel

2005-08-29 Thread Niklas Nebel
Lakin Wecker wrote: I assume these discrepancies are the result of caching formula results. The assumption is that Excel stores the previously calculated results of the formulae in the spreadsheet and uses these values at load time, while OO.o ignores these and fully recalculates the formulae on

Re: [sc-dev] Any news on: How to standardize Spreadsheet formulas?

2005-08-29 Thread Niklas Nebel
M. Fioretti wrote: a couple of months ago I asked about this: http://www.mail-archive.com/dev@sc.openoffice.org/msg00139.html I just wanted to ask is there has been any news about this (especially openformula adoption) and where I could read it. Any comment is obviously appreciated. I

Re: [sc-dev] Validation of Functions. Progress for last week

2005-08-31 Thread Niklas Nebel
Daniel Miller wrote: As I close out the last week of the summer of code, I have finished the test cases, deployed them in the code and rendered results. I am finishing up the final documentation to hand in to my mentor Niklas by Tuesday. If you have any comments or questions on this project

[sc-dev] List of possible Calc performance improvements

2005-09-19 Thread Niklas Nebel
Hi everybody, I have put a file possible performance improvements.sxw into the Performance folder under http://sc.openoffice.org/servlets/ProjectDocumentList. It lists a few improvement ideas for loading and saving files in Excel XLS as well as our own format. This was collected last year,

Re: [sc-dev] Article: OpenDocument office suites lack formula compatibility

2005-09-21 Thread Niklas Nebel
Eike Rathke wrote: Not sure if this is related to this formula standardization issue, but would such a standardization address the argument separator inconsistency i.e. ',' vs ';' ? Note that OpenFormula is about the file format, no the representation in the UI. The draft does have a section

Re: [sc-dev] Article: OpenDocument office suites lack formula compatibility

2005-09-22 Thread Niklas Nebel
Jody Goldberg wrote: What is the goal of an open-formula specification ? I'd assume it is to improve interoperability between versions and implementors of the standard. If that is the case then there is already a standard, MS Excel. Given the complexity and prevalence of it's evaluation

Re: [sc-dev] FWD: Re: [discuss] OO.o bloat seen from KOffice side

2005-11-03 Thread Niklas Nebel
Kohei Yoshida wrote: Also, refer to Niklas's comment on this list a while ago: http://sc.openoffice.org/servlets/ReadMsg?list=devmsgNo=1598 So I might as well give a little update on some items from that list: - Access to simple (non-formatted) cell content has been changed to direct calls,

Re: [sc-dev] Natural sort

2005-11-08 Thread Niklas Nebel
Kohei Yoshida wrote: What's the latest word on natural sort? Will this feature ever stand a chance for integration? http://qa.openoffice.org/issues/show_bug.cgi?id=26565 With UI changes and file format extension, that seems to be something for the next major version (3.0, or whatever it

Re: [sc-dev] Issue 55735

2005-11-09 Thread Niklas Nebel
Kohei Yoshida wrote: Thanks for letting me know. Would, myself creating a CWS and having someone QA it help take some load off your shoulder, or not really? Just a hypothetical scenario, as I don't know if I could find an appropriate QA personnel... But just a thought. Last 2.0.1 CWS

Re: [sc-dev] Spreadsheet functions

2005-11-14 Thread Niklas Nebel
Norm Byers wrote: Dear Sirs, Long ago, in a galaxy far away... I was the developer of the Saturn-Calc Spreadsheet application for the PDP-11 (RT-11,TSX,RSX,RSTS O/S), VAX (VMS), and PC (DOS only). Though a couple of $million worth were sold it met its demise with the demise of DEC and the rise

Re: [sc-dev] OpenOffice.org Calc: WB3 File Import

2005-12-06 Thread Niklas Nebel
Pablo Rodríguez Rey wrote: We hope if your team have any time you can make a WQ1/WB3 Quattro Pro file format importer from Corel WordPerfect Suite v6,7,8. We have a lot of documents in this format and we are trying to upgrade to OpenOffice 2.0, but this characteristic is basic for us. A

Re: [sc-dev] oo 2.0.1 file format: text:span text:style-name=T1/ removed ?

2006-01-02 Thread Niklas Nebel
Oliver Brinzing wrote: it seems, the text:span text:style-name=T1/ has been removed, T1 was: style:style style:name=T1 style:family=text style:text-properties fo:language=de fo:country=DE/ /style:style is it a change or is it my fault,

Re: [sc-dev] Import from Excel: link updating or not ???

2006-01-02 Thread Niklas Nebel
JC Helary wrote: Neither in Excel nor in Calc are the linked files/sheets originally displayed. I am only translating the displayed information in the files, I am not the creator so I don't know what was the purpose of linking the tables in the first place. It's a hidden sheet. You can

Re: [sc-dev] line break in a text box attached to a cell

2006-01-02 Thread Niklas Nebel
JC Helary wrote: You mean that OOo considers a line break to be a paragraph in any context ? |You mean that | |OOo considers | |a line break to | |be a paragraph | |in any context ?| Here my whole box uses the same style for each of the line break

Re: [sc-dev] line break in a text box attached to a cell

2006-01-03 Thread Niklas Nebel
JC Helary wrote: |You mean that | |OOo considers | |a line break to | |be a paragraph | |in any context ?| I was wondering why OOo considers the necessity to convert a line break to a series of paragraphs in the context of a shape (is that what text

Re: [sc-dev] XCellRangeMovement - copyRange() does not work if destination range has merged cells

2006-01-06 Thread Niklas Nebel
Oliver Brinzing wrote: i found that, the oSheet.copyRange(oDstCell, oSrcRange) does not work, if cells in the destination area are merged ... If the source and destination area both contain merged cells, to be exact. It's the same limitation as with DragDrop. The check is there to prevent

Re: [sc-dev] Solver integration

2006-01-25 Thread Niklas Nebel
Kohei Yoshida wrote: My question is, how do you guys think this integration should be done? Especially the way it is done as described above is not good for localization. The menu label needs to be empty, and the label needs to be define elsewhere, properly localized I assume (I'm not really

Re: [sc-dev] Formula Compatibility

2006-01-26 Thread Niklas Nebel
Terry North wrote: I'm not a programmer but I've been using spreadsheets for a long time, including Lotus, which went through a number of changes. I hope that reading this does not take too long, if my suggestion has no merit. Sorry for the late reply. It's good to see some suggestions,

Re: [sc-dev] extending Number of rows

2006-02-06 Thread Niklas Nebel
Laurent Godard wrote: reading some press article, it is claimed that the next xls monster will handle 1 000 000 of lines and thousands of columns i think it is ridiculous but for a end-user point of view it will be a difference. And communication by microsoft seems to oriented in this

Re: [sc-dev] extending Number of rows

2006-02-07 Thread Niklas Nebel
Laurent Godard wrote: MAXCOLCOUNT_DEFINE, but I'm not sure if all code that deals with column names can handle more than two letters. yes i found it (was not so hard ;-) ) i'll try and see for the letter support a pointer on the source where to do handle it ? (well, optional) The code in

Re: [sc-dev] Re: Syncronize SW and SC statusbar behavior

2006-03-08 Thread Niklas Nebel
Kohei Yoshida wrote: On 3/6/06, KamiHír [EMAIL PROTECTED] wrote: As you probably know I am not a programmer, but I would like to add one small functionality to SC. If you click twice on first field ofWriter's statusbar the Navigator shows up. You can not start the navigator same way in Calc. I

Re: [sc-dev] Drag or copy over filtered rows

2006-03-09 Thread Niklas Nebel
jim wrote: (e) What is the solution? This is a matter of opinion. My view is that an improvement for one type of case is a step forward, and it does not matter if other cases remain as they are now. We know about the case when drag or copy is done from a single row, onto a range of filtered

Re: [sc-dev] Making Live Spreadsheets: Can OOo connect to an XML feed

2006-04-11 Thread Niklas Nebel
Alexandro Colorado wrote: Is it possible to make a live spreadsheet, meaning that the content of the cells are provided by a live XML feed from an APi. The idea is to have stock charts/currency exchange/ and/or pricing of products directly inserted into a Calc spreadsheet and users can add

Re: [sc-dev] troubleshoot calc addin load

2006-04-18 Thread Niklas Nebel
eric ehlers wrote: how do i troubleshoot problems with OOo calc loading a custom addin (DLL) from the program directory? on my old windows machine i have an addin which successfully compiles under VC6 and loads into calc version 1.1. on my new windows machine i take the same source code and

Re: [sc-dev] using cut paste on pw protected sheets causes problems ...

2006-04-20 Thread Niklas Nebel
Oliver Brinzing wrote: I have a problem using cut paste on non protected cells (input area) on password protected sheets: Example: A user insert values into non protected cells to do some calculations. The sheet is password protected, the user can not change the formulas. Now the user uses

Re: [sc-dev] Re: Google Summer of Code 2006 : Working for Calc -Show formula syntax in tip help

2006-04-20 Thread Niklas Nebel
Niklas Nebel wrote: less than an hour after the suggestions were published Er, forget about that part (times listed in too many different time zones)... Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [sc-dev] I have a question for someone who works with the spreadsheet part.

2006-04-26 Thread Niklas Nebel
Geoffrey Hyde wrote: Hi, I am an end-user of OpenOffice Org 1.1.2 and I was wondering if there are any plans to add more types of units of measurement into OpenOffice Org's next version? What I am after is basically simple unit conversion, addition, and subtraction of weights, eg 4lb 6 oz

Re: [sc-dev] how to stop cell editing ?

2006-05-02 Thread Niklas Nebel
Oliver Brinzing wrote: maybe i am blind, but i am looking for a simple way to stop the cell editing, if a user presses a control element (for example an ok button) background: the users has to insert values into some spreadsheet cells. after that he has to press a button to do some calculation

Re: [sc-dev] Solver type of component for Open Office

2006-05-03 Thread Niklas Nebel
Vagmi Mudumbai wrote: I have recently moved my laptop into the all unix world with Ubuntu. I am now participating in a Management course. Lot of the quantitative techniques demostrated use the solver addin for Excel. I was surprised that I could not find a relevant component in Calc. Alhough

Re: [sc-dev] how to stop cell editing ?

2006-05-04 Thread Niklas Nebel
Oliver Brinzing wrote: yes, i can do so, but i think it's just a workaround ... what about an interface with the following methods isCellEditable() isEditing() startCellEditing() stopCellEditing() cancelEditing() Is there any deeper meaning to the inclusion of Cell into only some of the

Re: [sc-dev] how to stop cell editing ?

2006-05-05 Thread Niklas Nebel
Oliver Brinzing wrote: No, i had a look at some java classes (javax.swing.AbstractCellEditor, javax.swing.plaf.TreeUI,...) and found a mixture of names indeed i would prefer the method names without Cell ... Which might lead to the expectation that editing of text in shapes is included,

Re: [sc-dev] Calc Solver snapshot 2006-06-16

2006-06-19 Thread Niklas Nebel
Kohei Yoshida wrote: I've uploaded a new snapshot of Calc Solver to my website. The difference from the previous snapshot is mainly to combine the two separate UNO packages into one, by statically linking to lp_solve, and removing some preprocessing of models which prevented lp_solve from

Re: [sc-dev] Calc Solver snapshot 2006-06-16

2006-06-19 Thread Niklas Nebel
Kohei Yoshida wrote: The static linking is done only for the standalone UNO package that is to be distributed outside OO.o (i.e. via my personal website). I would think this should pose no problem since my UNO package is distributed separately from the main OO.o build. As far as integration

Re: [sc-dev] Disabling cell updates

2006-06-20 Thread Niklas Nebel
Kohei Yoshida wrote: My question is, is it possible to disable repainting of cells while their data are being modified? Something like: disableCellUpdates(); convert models enableCellUpdates(); would be the most desirable, but I'm not sure if such API exists. You can use lockControllers /

Re: [sc-dev] Contribution to OpenOffice

2006-06-23 Thread Niklas Nebel
Gerrow, Darryl wrote: I am looking to contribute to the projects of: *- OpenOffice.org Calc: Validation of spreadsheet functions* *- OpenOffice.org Platform Technology: Layout Manager Widget* Please let me know how I can join and help in these projects. Thanks. Validation of spreadsheet

Re: [sc-dev] how can I reference a cell containing text with linebreaks ?

2006-06-23 Thread Niklas Nebel
Oliver Brinzing wrote: IMHO this should be treated as a bug, cause the linebreak char is changed into a space (code 32) ... The first cell doesn't contain a line break character. It contains two paragraphs. Niklas - To

Re: [sc-dev] how can I reference a cell containing text with linebreaks ?

2006-06-23 Thread Niklas Nebel
Oliver Brinzing wrote: this is true, if one acesses the cell via basic getString() method ... ' result: 10 - ok but if one uses a formula =CODE(TEIL(A1;6;1)) the result is 32 ... :-( Sure, different interfaces for different uses. This by itself is not a problem and was done on

Re: [sc-dev] Solver Component

2006-06-27 Thread Niklas Nebel
Leandro Silveira Monteiro da Silva wrote: My name's Leandro Silveira and I'm a Brazilian computer programmer just trying to find something nice to do. While visiting OpenOffice.org website, I got interested in doing some contributing work. That's great. Actually, the task below interested me

Re: [sc-dev] Nice ideas

2006-07-19 Thread Niklas Nebel
Sven Verleyen wrote: 1. I have a little table with 2 collumns and 8 rows, in that table is the legend of something in my spreadsheet. So I want to so that legend when I scroll down the page. So the idea is: the ability to block a few cells. You mean something like Window/Freeze, but not for

Re: [sc-dev] Plots with Multiple Data Sets

2006-09-15 Thread Niklas Nebel
Morgan Stefik wrote: I am writing to request an OO.org Calc feature. There is no ability to plot multiple data sets in an XY plot. In order to do this currently one would have to merge the X lists and space the Y values in the appropriate columns. There should be an ability to select multiple

Re: [sc-dev] interface com.sun.star.util.XSortable, restrictions

2006-09-29 Thread Niklas Nebel
Peter Eberlein wrote: is the method sort on a xRange restricted to max 3 columns (as in the GUI)? If I specify 6 TableSortFields and run the method, it seems, that MaxFieldCount is always 3 and a readOnly property. Yes, it's the same limitation. Niklas

Re: [sc-dev] interface com.sun.star.util.XSortable, restrictions

2006-09-29 Thread Niklas Nebel
Peter Eberlein wrote: is there an issue about that? At least a note in the DevGuide would be useful. For more sort fields, there's issue 10933. The IDL description for MaxFieldCount in the sort descriptor says contains the maximum number of sort fields the descriptor can hold. By contrast

Re: [sc-dev] accessing cipher api for sheet/document protection possible ?

2006-10-18 Thread Niklas Nebel
Oliver Brinzing wrote: is it possible to access the cipher api for en-/decrypting calc password protected sheets/documents ? No, not directly (you could create a hidden document, protect a sheet, save the file and extract the hash, or something like that). Niklas

Re: [sc-dev] Statistical Functions Implementation

2006-10-23 Thread Niklas Nebel
Leonard Mada wrote: I was wondering what coding algorithm does Calc use when implementing the various statistical functions? REASON === Although different formulas are mathematically identical, they give different *error estimates* when coded on a computer. EXAMPLE The variance

[sc-dev] Status of ooo-build patches

2006-10-23 Thread Niklas Nebel
Hi, Some people complain that a large number of Calc patches is piling up at ooo-build and we at Sun are ignoring or delaying them. To counter this impression, we (the core Calc team at Sun) went through the Calc section of the list at http://go-oo.org/ooo-build/patches/src680/apply, and

Re: [sc-dev] Re: Calc cell justification

2006-10-25 Thread Niklas Nebel
Alan Yaniger wrote: Thanks for your suggestion. I added a function in output2.cxx to extend the default alignment handling, call it when necessary, and it works great. There's still a problem, though. When I edit a field by pressing F2 or clicking on the string in the input window, the

Re: [sc-dev] Re: Calc cell justification

2006-10-26 Thread Niklas Nebel
Alan Yaniger wrote: Is this the way to get the text direction value if I want to change it ? To change the value, I've been trying to use the function, for example: pItem.PutValue( FRMDIR_ENVIRONMENT, ATTR_WRITINGDIR ); but I'm getting the compiler error: cannot convert 'this'

Re: [sc-dev] Status of ooo-build patches

2006-10-26 Thread Niklas Nebel
Kohei Yoshida wrote: Issue 35579 - sc-standard-filter-options.diff Issue 26565 - sc-natural-sort.diff I'm fully aware that the reason why the file format needs to be extended in order for these patches to be included is because the state of their corresponding UI control (i.e. checkbox, combo

Re: [sc-dev] String Operations in Calc and Advanced Utilities

2006-10-31 Thread Niklas Nebel
Leonard Mada wrote: Exactly this is the problem. It returns an *ERROR*, so searching for string 1 OR string 2 will fail grandiosely. Actually, it is impossible to perform this search in calc. This is a *BUG*. (the full comments can be found for issue 66590) It's possible using ISERROR. One

Re: [sc-dev] Statistical Functions Implementation

2006-11-10 Thread Niklas Nebel
Leonard Mada wrote: I entered in column B(1): =A1 + 1, that is I added the value 1 for every element in column A. That said, data values in columns A and B should be totally correlated. The NIST accepts a value of -0.999, but: They don't accept a value of -0.999 instead of 1, they just

Re: [sc-dev] Statistical Functions Implementation

2006-11-10 Thread Niklas Nebel
Leonard Mada wrote: Mind if I ask, in which file is the CORREL function defined? Tests are still useful to see where the algorithm fails (and purportedly, the new algorithm should be correct). Extensive test cases are always welcome. sc/source/core/tool/interpr3.cxx, method

Re: [sc-dev] Text Direction in formula dialog

2006-12-20 Thread Niklas Nebel
Alan Yaniger wrote: Question 1: To align the names in the function list, I added following to ScFuncPage::UpdateFunctionList() : if (ScGlobal::IsSystemRTL()) aLbFunction.EnableMirroring( ); Is this the best way to do it? That would mean double mirroring, the flag wasn't

Re: [sc-dev] about bugs

2007-02-06 Thread Niklas Nebel
blueeagle wrote: We are RedOffice team.there is some bugs that we found in the OOo2.1. If you find bugs, please file them in IssueTracker, see http://qa.openoffice.org/issue_handling/index.html. On the mailing lists, there may be some discussion, but unless a bug is filed, it will be forgotten

Re: [sc-dev] Using text in calculation fails to raise error

2007-03-01 Thread Niklas Nebel
Guido Ostkamp wrote: (*) This is _not_ one of the typical we want numbers erroneously formatted as text to be still treated as numbers as in Excel questions as handled in many issues like #5658 etc. It's related. The error that others show is from failure to convert to a number. Our approach

Re: [sc-dev] we find a new bug

2007-03-06 Thread Niklas Nebel
gaozm wrote: We are RedOffice team, I'm Gao Zemin. There is a bug that we found in the OOo2.1. The bug can be described as follows: Open a special case file with the Calc, and edit it, then freeze occurs. 1, Open a new calc document. 2, Open a special case file with the calc, and

Re: [sc-dev] Issue 51564 - clicking Sum with several cells selected produces unexpected result

2007-03-19 Thread Niklas Nebel
Kirill S. Palagin wrote: Issue http://www.openoffice.org/issues/show_bug.cgi?id=51564 describes important functionality that is missing in our product - competing product has this functionality and it is widely used by users. The issue has generated a significant interest among our users -

[sc-dev] Rough sketch of formula API

2007-03-19 Thread Niklas Nebel
Hi everyone (including those who bring this up on wrong irc channels), Here's a quick overview on what I have in mind for the API to allow the OOX import component to handle formulas: 1. The cell will have a new interface XFormulaTokens or something, with methods * sequenceany

Re: [sc-dev] First draft for margins in Page Preview, please

2007-03-23 Thread Niklas Nebel
zhaosheng wrote: I have sent a email to you with the file, did you receive it? No, I only got the mail from the mailing list (don't know why). Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[sc-dev] Formula API on CWS xmlfilter02

2007-03-23 Thread Niklas Nebel
Hi, A first version of the formula API is now in the cvs for the xmlfilter02 CWS. Because much of ScToken's functionality is needed only within the context of the RPN code used for calculation, and this new API only deals with the non-RPN code, it can be simpler than in the previous mail.

Re: [sc-dev] First draft for margins in Page Preview, please

2007-03-23 Thread Niklas Nebel
zhaosheng wrote: I have sent a email to you with the file, did you receive it? I got it now, and I see it's also attached to issue 75673. Keep in mind that the header has a Height and a Spacing setting. The line in your screenshot seems to be at the sum of both. Which one is supposed to be

Re: [sc-dev] Summer of Code: R and Calc

2007-04-02 Thread Niklas Nebel
Erich Neuwirth wrote: You really want a closed interface for naive users of statistics, probably through a menu driven interface similar to the analysis toolkit in Excel. In the end, I would like to have ready-to-use methods for naive users, with the list of method definitions extensible by

Re: [sc-dev] Once again, the thing I am missing most in OpenOffice

2007-04-02 Thread Niklas Nebel
Erich Neuwirth wrote: I have posed this question some time ago. Let me repeat it. OpenOffice gives the option of placing a slider aka scrollbar on a worksheet and connecting it to a cell. Moving the slider (=scrollbar) changes the cell value. In principle this is the easiest way of creating

Re: [sc-dev] Once again, the thing I am missing most in OpenOffice

2007-04-05 Thread Niklas Nebel
Erich Neuwirth wrote: I checked, and it is much better now! But still not the full functionality. While the scrollbar button is grabbed with the mouse, the linked cell value does not change, it only changes after the scrollbar button is released. So some animation is possible by clicking and not

Re: [sc-dev] ScInterpreter::ScPropper() Optimization?

2007-04-12 Thread Niklas Nebel
Leonard Mada wrote: I found some interesting code inside the function ScInterpreter::ScPropper() [in interpr1.cxx]. namely, there is a while loop and an unnecessary subtraction is nested inside this while loop: see pStr[nPos - 1] while( nPos nLen ) { aTmpStr.SetChar( 0,

Re: [sc-dev] regression analysis tool for openoffice calc

2007-04-17 Thread Niklas Nebel
bernie hunter wrote: I'm a new developer in grad school, and want to make a regression tool for CALC which it doesnt have (at least my version of Open Office Calc doesnt)..and just wanted to make contact and say I'm going to try and learn about that and do it. I'd hope someone would write and

Re: [sc-dev] There is a new bug

2007-04-18 Thread Niklas Nebel
gaozm wrote: Thank you very much for your help during these weeks, now,there is a new bug that we found in the OOo2.1. The bug can be described as follows: Save the document when the content of the note show Fontwork, withdraw from the process. 1, Open a new Calc document. 2,

Re: [sc-dev] R + Calc Update

2007-04-23 Thread Niklas Nebel
Leonard Mada wrote: could you please explain what this code does? { ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, rString); bIsString = (nType != SC_MATVAL_VALUE); } My thinking is: - it gets content of current table cell - IF content is a numerical value, fVal is set - IF content is

Re: [sc-dev] R + Calc Update

2007-05-02 Thread Niklas Nebel
Kohei Yoshida wrote: You may have already seen it, but there is also the scaddins module where you can add new functions. This module was there originally to ease addition of new cell functions without touching the Calc core, but I don't know if this module is actively used today (Niklas?). I

Re: [sc-dev] Re: [?? Probable Spam] Re: [sc-dev] There is a new crash bug!

2007-05-02 Thread Niklas Nebel
毛勇岗 wrote: Thank you for your suggestions. As you said I analyzed the call stack. And in the SfxMedium* SfxApplication::InsertDocumentDialog(sfx2\source\appl\appopen.cxx), sal_uInt32 nError = pMatcher-DetectFilter( *pMedium, pFilter, FALSE ); if ( nError == ERRCODE_NONE pFilter )

Re: [sc-dev] Re: [sc-dev] There is a new crashbug!

2007-05-02 Thread Niklas Nebel
毛勇岗 wrote: Thank you very much for you reply. As you said,regarding this crash issue,I should be how to modify in the next step. What can I do? I hope to get you hits. Thank you! There are two possibilities: 1. Prevent the file from being opened as CSV. This is what the filter detection

Re: [sc-dev] Calc and R through UNO

2007-05-07 Thread Niklas Nebel
Wojciech Gryc wrote: In general, I think it would be best to continue with the UNO add-in development using Rserve. While working on this, I realized that no matter what happens, users of this tool will need to install R and possibly an R package. As such, I don't mind making the entire thing

Re: [sc-dev] Something about the Filter function

2007-05-14 Thread Niklas Nebel
gaozm wrote: As you know, there are some differences between Calc and Excel of Filter Function, for example, in Excel, select a whole colum which contains data, the action flow can be described like: Data-Filter-Auto Filter, then select the Top10 option, you can see a dialog for users

Re: [sc-dev] About the bug of Fontwork

2007-05-15 Thread Niklas Nebel
maoyg wrote: FontWork should be disabled for note objects,because it will be caused crash. I analyzed the call stack, and in the void ScDrawShell::GetState() (sc\source\ui\drawfunc\drawsh2.cxx ), if( pObj pObj- GetObjIdentifier() == OBJ_CAPTION pObj- GetLayer() ==

Re: [sc-dev] Can't insert rows/columns when contains cells merged !

2007-05-16 Thread Niklas Nebel
maoyg wrote: Thank you very much for your help and relpy.I have a new problem now. In Calc,select only the range B3:D5 on an empty sheet,click toolbar -merge cells.Then I want to insert a row/column where contains the merged cells. The result : Can't insert rows/columns when contains

Re: [sc-dev] About the Top-10 dialog

2007-05-16 Thread Niklas Nebel
gaozm wrote: Thank you very much for your help, we have accomplished a Top-10 dialog for our users, because we thought it is necessary to bring more convenience to users.Do you think it feasible?I'm looking forward to your suggestions, thank you. So you have something finished? What does it

Re: [sc-dev] About the Top-10 dialog

2007-05-16 Thread Niklas Nebel
gaozm wrote: We have finished the Top-10 dialog, it looks like the Top-10 dialog when you select the Top-10 in MSoffice, do you think it is feasible? Thank you. It seems a bit redundant with the Standard Filter dialog. You should bring it up on the ux-discuss list. Niklas

Re: [sc-dev] About the Cells Hold high-default Value

2007-05-21 Thread Niklas Nebel
gaozm wrote: Hello all: Here is a new question that because the cells hold high-default value is too small(0.45cm), so our team changed the cells hold high-default value to 0.53cm, the changed code like this: // ppPoolDefaults[ ATTR_FONT_HEIGHT - ATTR_STARTINDEX ] = new

Re: [sc-dev] Whom should I assign i56202 to (for QA)?

2007-05-29 Thread Niklas Nebel
Muthu Subramanian wrote: I fixed i56202 in msba01. [http://www.openoffice.org/issues/show_bug.cgi?id=56202] Whom should I 'assign to', in EIS, for QA? It's on the wrong branch. OOF680 was used for 2.2.1. The CWS has to be resynced to a current SRC680 version first. Niklas

Re: [sc-dev] queryEmptyCells()

2007-06-05 Thread Niklas Nebel
Jahn, Ray (R.) wrote: The symptoms can be divided into two types: * a brand new spreadsheet file a brand new and empty spreadsheet no content in any cell aXCellRange.queryEmptyCells() always returns nothing regardless what the range is set to. * a brand new spreadsheet file a brand

Re: [sc-dev] SDK Java Examples Windows XP

2007-06-05 Thread Niklas Nebel
Wojciech Gryc wrote: But they're Java add-ins...? So shouldn't they work? I'm specifically referring to the java/Spreadsheet examples in the SDK. The Java examples, compiled on Linux, also work on Windows. Did you close the application, including the quickstarter? Niklas

Re: [sc-dev] Something about Filter function

2007-06-05 Thread Niklas Nebel
Kohei Yoshida wrote: I've also started some work on Excel 2007 style multi-string matching filter (or whatever people like to call it). It's basically an autofilter extension where you can select multiple items to display; rather than just one. The detail is in here:

Re: [sc-dev] SDK Java Examples Windows XP

2007-06-05 Thread Niklas Nebel
Wojciech Gryc wrote: However, when I install RAddon.uno.pkg it does add menus and everything else, just no functions... That would mean the installation itself works on XP, right? Or is there a separate issue to consider with adding functions? Calc keeps a list of all add-in functions. If an

Re: [sc-dev] Some simple tasks

2007-06-15 Thread Niklas Nebel
Kohei Yoshida wrote: I can see that #i27745# and #i33851# have the highest votes casted among all autofilter related issues. http://www.openoffice.org/issues/show_bug.cgi?id=27745 http://www.openoffice.org/issues/show_bug.cgi?id=33851 So, I personally would recommend looking into those issues.

Re: [sc-dev] OpenOffice.org Calc: Validation of spreadsheet functions

2007-06-20 Thread Niklas Nebel
Tommy Reed wrote: I am interested in helping out with this 'to-do'. Any information you could provide would be great. Some work has already been done, see the folder Function Validation at http://sc.openoffice.org/servlets/ProjectDocumentList. A possible next step would be to single out

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

2007-06-20 Thread Niklas Nebel
Max Giesbert wrote: Thanks for pointing to XEnhancedMouseClickBroadcaster . I register a XEnhancedMouseClickHandler to it. But I only have an EnhancedMouseEvent in the mousePressed method. How can i find out the cell clicked with that? I didn't find any suiting methods. It's in the Target

Re: [sc-dev] Increasing maximum worksheet size

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

Re: [sc-dev] About issue 63144#,please review patch file!

2007-06-22 Thread Niklas Nebel
maoyg wrote: I have made some changes about Issue 63144# on the version SRC680_m215.The attachment is patch file of the issue 63144#. Would you give me some suggestion and help about the patch file? The attachment was removed from your mail by the mailing list server, so we can't see it. Can

Re: [sc-dev] About issue 63144#,please review patch file!

2007-06-22 Thread Niklas Nebel
maoyg wrote: I have just attached the patch to the issue. Please check it. It's the right direction, but the patch disables editing of any notes on a protected sheet. You should look if the note's cell is protected, so notes of non-protected cells can still be edited. Niklas

Re: [sc-dev] Re: [!! SPAM] Re: [sc-dev] About issue 63144#,please review patch file!

2007-06-25 Thread Niklas Nebel
maoyg wrote: The current sheet has been protected, so all of the cells in it are protected. So that there is no non-protected cells in this protected sheet. Then there is no need to look if the note's cell is protected. All the notes in it should not be edited then. I find the all the objects

[sc-dev] ScRange::Parse return values

2007-06-25 Thread Niklas Nebel
Hi everyone who's involved with reference parsing, When parsing references with CONV_XL_A1 convention, the return values from ScRange::Parse are different from those for CONV_OOO and don't match what ScCompiler::IsReference expects. - For a single reference (Sheet1!A1), the bit SCA_VALID is

Re: [sc-dev] ScRange::Parse return values

2007-06-26 Thread Niklas Nebel
Noel Power wrote: While not involved with reference parsing, I do know that for say the example range like Sheet1!A1 currently code that Jody popped into the vba interop api to help me ( for various range XL/R1C1 support ) expects SCA_VALID to be set on return From your comments below it would

Re: [sc-dev] About issue 63144#,please review patch file!

2007-06-27 Thread Niklas Nebel
maoyg wrote: About issue 63144# has been fixed. I have attached the patch to the issue63144#, please check it. I'm looking forward to your advice :). Using the cursor position isn't right. The cell cursor can be anywhere, it doesn't have to be at the note's cell when a user selects the note.

Re: [sc-dev] Some simple tasks

2007-06-27 Thread Niklas Nebel
gaozm wrote: I have looked at issue 23299, but the code in my version is a little different from m215 about formula, because we have added some code in that files, and I don't understand the concrete steps of issue 23299 fully, so I had a choice issue 27745. I hope you can give me some

Re: [sc-dev] ScRange::Parse return values

2007-06-27 Thread Niklas Nebel
Noel Power wrote: If you can let me know when you commit the change ( and to what file(s) ) I will at least run some tests against that as a sanity check. It's in sc/source/core/tool/address.cxx 1.9.18.1. I also made a small change to compiler.cxx (1.68.18.1) to correct the output of such

Re: [sc-dev] Slow copy in SC

2007-06-28 Thread Niklas Nebel
zhaosheng wrote: I found something in SC, IMHO, it may be annoying to some people. it is the inserted picture. if you insert a picture into a cell, it acutally doesn't insert the picture to the cell, right? it seems to be inserted floating on the whole spreadsheet, you can move it anywhere.

Re: [sc-dev] Setting default character set for DBase files

2007-06-28 Thread Niklas Nebel
Alan Yaniger wrote: When openeing a DBF file in Calc, OOo asks the user which character set to use. Is there a way to set a default charset for all files with a given extension, like *.dbf? If such a feature is not built-in, could it be done in an OOo BASIC macro? If so, how? The initial

  1   2   3   >