Re: [sc-dev] Enhance use Extension CT2N WAS Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-11 Thread Niklas Nebel
On 08/08/08 17:30, Cor Nouws wrote: When Calc will generate an error for such cells when used in arithmetic operations, it would even be possible to enhance the extension to make use of the detective to track down the source of the error and point the user to original problem. Yes that would

Re: [sc-dev] Specs date handling

2008-07-14 Thread Niklas Nebel
Cor Nouws wrote: But that is not the reason I write. I want to ask a related question: are there places on earth where people write dates as 1.1.08 or 1,1,08 ? 1.1.08 is not uncommon in Germany. Niklas - To unsubscribe,

Re: [sc-dev] just found ;-)

2008-07-03 Thread Niklas Nebel
Oliver Brinzing wrote: have a look: http://www.spiegel.de/netzwelt/web/0,1518,563637,00.html seem's oo has the same problem with: 29513736 * 92842033 = 2740115251665290 Output is rounded to 15 significant digits. That's intended behavior. Niklas

Re: [sc-dev] Something about issue 40300

2008-07-02 Thread Niklas Nebel
gaozemin wrote: Thank you for your comment on issue 40300. What do you think of adding a new method or I should change the method ScTable::GetDataArea()? GetDataArea is supposed to look at cell contents, not database ranges. So the change has to be outside of it. Niklas

Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Niklas Nebel
Eike Rathke wrote: On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell is =BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result

Re: [sc-dev] About Issue88467#!

2008-06-03 Thread Niklas Nebel
maoyg wrote: I have some questions about Undo which hover in my mind these days. I have two rough ideas in mind... First idea: I don't completely understand the specificaton on Undo. I make some operations in normol mode,for example,I input some characters in cell,or I change the column

Re: [sc-dev] About Issue88467#!

2008-06-02 Thread Niklas Nebel
maoyg wrote: I am working Issue88467# about Undo question in page preview. I have some questions about it. If the Undo or Redo is possible in page preview. when I create a spreadsheet doc, I input some characters in cell, the undo list have recorded input operation. it display input string.

Re: [sc-dev] compatible with Excel

2008-05-21 Thread Niklas Nebel
YunJingtao wrote: we want to add one format like 二七年二月 or 二七年二月十一日 in Numbers-Date and we had did some work on this. There are such formats in Excel, but there are some compatible problems with Excel. can you give us some instructions to deal with compatible problems? With

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-05-14 Thread Niklas Nebel
Niklas Nebel wrote: Niklas Nebel wrote: There is now a preliminary planning section on the wiki page. It can be discussed for a week, and will be finalized in an IRC meeting on May 12th. Same mistake again. It's May 13th. The second meeting took place, and we have a final list now, without

Re: [sc-dev] About issue88521#!

2008-05-09 Thread Niklas Nebel
maoyg wrote: I have submited a patch file, whether my direction is right? You can apply this patch file to your compluter, the SvxZoomSliderItem will have some problems. I only implemented a part of window class, when I click the left slider or right slider, it have not been updated, I

Re: [sc-dev] About the print scaling item question!

2008-05-05 Thread Niklas Nebel
maoyg wrote: I encountered a question about SvxZoomSliderItem, I have defined const USHORT nCurrentZoom = ScPrintFunc( pDocShell, pDocShell-GetPrinter(), nTab ).GetZoom(), MINZOOM_SLIDER = 10,MAXZOOM_SLIDER = 400, SvxZoomSliderItem

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-05-05 Thread Niklas Nebel
Niklas Nebel wrote: As discussed on the dev list (http://www.openoffice.org/servlets/ReadMsg?list=devmsgNo=22000), we are doing quarterly reviews for each project. There is now a wiki page at http://wiki.services.openoffice.org/wiki/2008_Q2_Review_of_Spreadsheet_Project to collect issues

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-05-05 Thread Niklas Nebel
Niklas Nebel wrote: There is now a preliminary planning section on the wiki page. It can be discussed for a week, and will be finalized in an IRC meeting on May 12th. Same mistake again. It's May 13th. Niklas

Re: [sc-dev] formatting of protected cell changed?

2008-04-30 Thread Niklas Nebel
Cor Nouws wrote: Before entering in IssueTracker a question about something I experience in 2.4.0 (and dev300_m10) that is new to me. When a sheet is protected, all protected cells become gray. Also the ones with another color. In 2.3.1 that did not happen. Did I miss a change or is it an

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-04-30 Thread Niklas Nebel
Eike Rathke wrote: 3.) offer easy recognition and conversion of text to numbers This may be implemented as well then, after we treat text-if-number as error. This was on the suggestion list for Summer of Code (potential errors). Maybe it can be done in the Community Innovation Program.

Re: [sc-dev] A question about refering the encrypted!

2008-04-21 Thread Niklas Nebel
maoyg wrote: The user creates two Calcs, and one is encrypted whose content is 100, the user will open another Calc to refer the encrypted one, but fail. Can we solve this problem? or are there any ways to solve this problem? I'm looking forward to your advice. The code to load a document

Re: [sc-dev] Possible Regression due to Issue 20496

2008-04-08 Thread Niklas Nebel
Leonard Mada wrote: Please see issue 87974 as this is probably a regression due to issue 20496: http://www.openoffice.org/issues/show_bug.cgi?id=87974 http://www.openoffice.org/issues/show_bug.cgi?id=20496 Entering a negative number in one cell (e.g. -1) followed by clicking a different cell

Re: [sc-dev] R4Calc, 0.1.12

2008-02-27 Thread Niklas Nebel
Wojciech Gryc wrote: It's been a long time coming, but a new version of R4Calc is now available on the OO.org wiki. It's up here: http://wiki.services.openoffice.org/wiki/R_and_Calc There's a number of new things here, all of which are discussed in the change log. The one thing that I'm

Re: [sc-dev] A new feature spec about show formula syntax in tip help!

2008-02-26 Thread Niklas Nebel
maoyg wrote: I have added a new feature specification about show formula syntax in tip help, please check it and give some suggestion to me. I'm looking forwards to your apply! :) http://wiki.services.openoffice.org/wiki/Show_Formula_Syntax The old, existing tip window can also be useful

Re: [sc-dev] About the show formula syntax feature some questions!

2008-02-22 Thread Niklas Nebel
maoyg wrote: when I see ScInputHandler::GetFormulaData() method, I discover a interesting phenomenon. USHORT nMRUCount = rOpt.GetLRUFuncListCount(); const USHORT* pMRUList = rOpt.GetLRUFuncList(); It seems that the two avariables above lead to the phenomenon. I believe when inputing one

Re: [sc-dev] About page margins some problems!

2008-01-31 Thread Niklas Nebel
maoyg wrote: I discovered some problems in fixing the patch file today. For example,in several pages, 1).When Scaling mode is Reduce/enlarge printout,Scaling factor is 50% or 120%, the header and footer can work well,the column can be rightly setted. 2).When Scaling mode is Fit print

Re: [sc-dev] About page margins some problems!

2008-01-29 Thread Niklas Nebel
maoyg wrote: I'm fixing the right-to-left, I encounter a question. I don't know how to handle it, when I dragging the cloumn, whether the action of right-to-left is opposite to the action of left-to-right. You can query the right-to-left flag using ScDocument::IsLayoutRTL. In that mode, the

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Niklas Nebel
Cor Nouws wrote: I can't find any spaces in the HTML. But pasting in a text editor or another spreadsheet appl. indeed gives the same result ... So probably something strange with the HTML-page? Or Firefox bug 303597 (https://bugzilla.mozilla.org/show_bug.cgi?id=303597), assuming that you

Re: [sc-dev] Some questions about the page margins feature!

2007-12-04 Thread Niklas Nebel
maoyg wrote: What do the user experience people in sum think of the spec, is there any consensus? They're still busy with other things, I'm afraid. I have finished reading the code of class preview and class ScPrintFunc. According to your comment on the issue51656#, we have removed the

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-04 Thread Niklas Nebel
Cor Nouws wrote: From the Dutch users-list, a questions arose with pasting data, copied from a HTML page. When choosing Paste special-unformatted text (via the text import dialog), the content of every cell gets an extra space. Is this known? Can't find an existing issue. Are you sure the

Re: [sc-dev] Some questions about print preview!

2007-11-19 Thread Niklas Nebel
maoyg wrote: 1.What is the variable(Point aOffset) used for in class ScPreview? That's the amount by which the preview is scrolled. (0,0) means the page starts at the top left position of the window. 2. In function ScPreviewShell::UpdateScrollBars(), there are two variables: Size aPageSize =

Re: [sc-dev] Page margins in print preview

2007-11-08 Thread Niklas Nebel
gaozm wrote: We want to pay some contribution to page margins in print preview, as you said, we already did some work on that, and the patcha and the specification has been committed. I want to know that whether we should follow the your comments of Issue51656 to modify the feature? I hope

Re: [sc-dev] Please give some help to me about i64462#!

2007-11-02 Thread Niklas Nebel
maoyg wrote: I traced the issue64462# for a whole day , but I still have not found some key information, I don't know whether this problem exists in the CopyToClip(...) or PasteFromClip(...). I'm looking forward to your some advice. Do you still see the described problem at all? It may

Re: [sc-dev] Could your assign a task to me?

2007-10-17 Thread Niklas Nebel
maoyg wrote: Thanks for your help and advice about issue63144#. At present could you assign a new task to me? How about issue 77236, also related to protected cells? Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [sc-dev] A new phenomena need to be confirmed!

2007-10-17 Thread Niklas Nebel
maoyg wrote: I want to perfect this function. Following is my thought about Note of the popup menu: 1. I will add a menu entry Edit Note to popup menu,the Edit Note can edit the Note. 2. The Insert Note should not be shown in the popup menu,when the cell exists the Note. Don't forget that

Re: [sc-dev] A new phenomena need to be confirmed!

2007-10-15 Thread Niklas Nebel
maoyg wrote: I find a phenomena,it can be described as follow: 1.Create a new Calc. 2.Select one Cell-Right Button-Insert Note-Input any characters. 3.Select the cell which has the note-Right Button. Result: The Insert Note is shown in the popup menu. Is this a defect? I think the item

Re: [sc-dev] Behavior of Ctrl-+ and - to insert/delete rows

2007-10-04 Thread Niklas Nebel
Cor Nouws wrote: Hmm, maybe the difference is caused by the fact that I possibly once had edited my keyboard settings, thus resulting in a different a current.xml in ...user\config\soffice.cfg\modules\scalc\accelerator\nl ?? (I fell the same trap once, I remember now) with a keyboard shortcut

Re: [sc-dev] RE: [users] PROBLEM WITH DATES CHANGED IN OPEN OFFICE CALC

2007-10-01 Thread Niklas Nebel
sophie wrote: Yes this bug is really annoying and actually blocking several migrations in France. Eike, did you have some time to investigate the issue and if so, could you please, tell us an approximative milestone where it could be corrected ? Eike is on vacation, he'll return next week.

Re: [sc-dev] Hello

2007-09-13 Thread Niklas Nebel
Kohei Yoshida wrote: On Thu, 2007-09-13 at 11:29 -0400, Himanshu Thapar wrote: I just wanted to confirm that is this the only part which is responsilble to read and write excel files, I mean if I include this part as a library in my application will I be able to read and write Excel files. In

Re: [sc-dev] R/Calc Version 0.1.8

2007-09-04 Thread Niklas Nebel
Wojciech Gryc wrote: A new version of the add-on is now out... This one focuses specifically on fixing the bug where the rcall_*.txt files don't load properly for some people... Could you please try this version and let me know if this has been fixed? It always worked on my computer, so I would

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Niklas Nebel
Kohei Yoshida wrote: What I meant to say was that Excel embeds the ruby text directly into string data in the shared string table, instead of storing it as a cell attribute. Just like text formats within the cell. :-) Niklas

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-20 Thread Niklas Nebel
Kohei Yoshida wrote: But, logically, it would make sense to store the ruby text together with the base text, because the ruby text is conceptually a property of the base text. Putting them together would also eliminate the synchronization problem because the ruby and the base texts would never

Re: [sc-dev] Our plan to improve Calc functionality related tophonetictext

2007-08-20 Thread Niklas Nebel
Kohei Yoshida wrote: Conceptually, it's a property of a part of the text, not the whole cell content. Yes. But since we don't differentiate partial texts from whole texts in terms of class representation (both are represented by OUString), my logic and yours have very little difference. :-)

Re: [sc-dev] R/Calc - 0.1.6

2007-08-20 Thread Niklas Nebel
Wojciech Gryc wrote: From an administrative point of view, I am supposed to stop working as a Google Summer of Code student today at 3 pm EST. As such, I've leased a new version of the package: 0.1.6, with links at http://wiki.services.openoffice.org/wiki/R_and_Calc Great to see graphics from

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

2007-07-27 Thread Niklas Nebel
Max Giesbert wrote: thx to Niklas and Daniel i got it running. Attached you find a Java class which can be registered with XEnhancedMouseClickBroadcaster. please have a look at it. i am looking forward to your feedback. Now I finally found the time to look at this. Yes, it looks good. still

Re: [sc-dev] time and date overlap when previewing

2007-07-27 Thread Niklas Nebel
yunjingtao wrote: Following Niklas's advice,I tried to find out the output of fields in the EditEngine,but the efforts were in vain.I want to know its location and I think the phenomenon is related to Preview.Hope someone help me and tell me in details.Please forgive my childishness,because

Re: [sc-dev] XActivationEventListener - how to listen to changes in OO 1.1.5

2007-07-26 Thread Niklas Nebel
Oliver Brinzing wrote: is it possible to listen for a change of the current sheet in OO 1.1.5 ? In OO 2.x I use the XActivationEventListener .. You could use a SelectionChangeListener and then compare the current sheet's index. Niklas

Re: [sc-dev] time and date overlap when previewing

2007-07-23 Thread Niklas Nebel
yunjingtao wrote: Please follow these steps: 1.create a new Calc and input some letters in any cell 2.On the tool bar, click format-page,pop up Page Style: Default dialogue, 3.choose Header or Footer, 4.click Edit, 5.on the Head (Page Style: Default) or Footer (Page Style:

Re: [sc-dev] UNO API for extended sheet filters

2007-07-20 Thread Niklas Nebel
Kohei Yoshida wrote: I'd like get your input on the new UNO API that I have introduced as part of implementing the multi-string filter. The relevant issue page is here: http://qa.openoffice.org/issues/show_bug.cgi?id=77677 Currently, Calc only has one type of sheet filter, which is

Re: [sc-dev] why add '_'before 'c'when creating names

2007-07-19 Thread Niklas Nebel
开源技术部-云惊涛 wrote: please follow these procedures 1.create a new calc. 2.input some date into cells,make sure 'c' in one cell for instance 'c' in A1 and 'b' in A2,choose the two cells 3.on the tool bar,click insert-name-create,choose top row,click ok. 4.and then click insert-name-define,in

Re: [sc-dev] A compatible problem

2007-07-19 Thread Niklas Nebel
gaozm wrote: I found that it was related to the default row height of Calc, I suggest to change the default row height to 0.52cm, but how to achieve it, I hope you can give me some help, thank you very much! Default row height isn't a fixed value, it's determined from text height of the

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

2007-07-18 Thread Niklas Nebel
Niklas Nebel wrote: It looks like the layer has to be locked again, possibly in FuText::StopEditMode. And for right-click selection, ScGridWindow::SelectForContextMenu calls lcl_UnLockComment (in gridwin.cxx), which has to be changed in a similar way to FuSelection::TestComment, or preferably

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

2007-07-11 Thread Niklas Nebel
Steve Griffiths wrote: I am interested in helping with Validating spreadsheet functions. What do I need to do? 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 significant

Re: [sc-dev] External cell reference implementation

2007-07-06 Thread Niklas Nebel
Kohei Yoshida wrote: I realize that Calc's external cell reference (a cell reference that refers to a cell in another document) is implemented by creating an invisible external link sheet first, then setting reference to it. Can this be done purely via existing UNO API? Create a linked sheet?

Re: [sc-dev] stable algorithm for statistic functions issue 78250

2007-07-05 Thread Niklas Nebel
Regina Henschel wrote: I had a look at the source in interpr3.cxx and have made the proposed changes for the COVAR function. Although I'm a very beginner I think, that I'm able to change some of the other such functions too. The changes need to calculate the mean in a first loop and than

Re: [sc-dev] Table Highlighting

2007-07-05 Thread Niklas Nebel
Leonard Mada wrote: I posted some time back a feature-request to implement a special spreadsheet-view in which rows get *highlighted* (see http://www.openoffice.org/issues/show_bug.cgi?id=78181). Virtually every table on the net is displayed this way. Also, most web applications have

Re: [sc-dev] Finance Functions

2007-07-05 Thread Niklas Nebel
gcavalcanti wrote: Anybody knows where are the finance functions (ex. TIR,PV,RATE...) in the OpenOffice sources? I looked in the directory OOF680_m14\sc\source\core\tool\interpr*.cxx, but without success... Those that aren't add-in function are just there, but some have non-obvious names

Re: [sc-dev] Table Highlighting

2007-07-05 Thread Niklas Nebel
Kohei Yoshida wrote: Along the same line, I would also like to see the possibility of overlaying (or underlaying) a background image to enhance the visual effect of Calc's (rather boring) sheet. Note that such background image is not printable, so it's only for display. And it wouldn't scroll

Re: [sc-dev] About issue18704

2007-07-04 Thread Niklas Nebel
Xu dehua wrote: I am fixing issue18704 and reading the function TRIMMEAN. But the problem is: I don't know which statistics function has problem, so I just look through the functions without any purpers. It is difficult to find out the function which is needed to be modified. Could you guys

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

2007-07-02 Thread Niklas Nebel
maoyg wrote: Thanks very much your advice. I have attached the patch file to the issue 63144#,please check it. When I fixed the issue, I found some problems about Notes. On a protected sheet, the note's cell is protected,the other note's cell is non-protected. I want to edit the

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

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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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

<    1   2   3   >