[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
  Next i

will take about 3 seconds for each range in my spreadsheet - why ?


Are there many comments (notes) in the file? Then it might be related to 
issue 102716.



adding oDoc.addActionLock() / oDoc.removeActionLock()
will solve the problem, but i am not sure if i have to use a
oDoc.calculateAll() after removing the lock to be sure,
all formulas are calculated correctly ?


No, addActionLock for the document doesn't interfere with formula 
calculation. It mainly affects the drawing layer.


Niklas
--
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help


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

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.services.openoffice.org/wiki/User_Experience/Improving_OOo_Default_Settings.


Niklas
--
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help


[sc-dev] Re: Calc Watch Window

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 writing a module with OpenOffice Basic and I think the work could
be finished in a few days or a week (depending on my school agenda).

This is my first OpenOffice project, so I don't know some things. Whom
can I ask help to? How do I have to send you the final work?

I wish I hear from you soon.


There are already two Watch Window extensions in the repository now, 
http://extensions.services.openoffice.org/en/project/watchwindow and 
http://extensions.services.openoffice.org/en/project/watchingwindow.


If you still want to do an implementation in Basic, the best places to 
ask for help are this list or d...@api.openoffice.org. You should 
subscribe to any mailing list before posting, to make sure you get all 
replies.


Niklas
--
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help


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

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 re-uploaded it. final evaluation version is the latest version.

Niklas
--
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help


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

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  string  aItems )


Parameter aItems
a sequence containing the names of the items (members)
which will be part of the new group. Must be names of items contained in the 
current field.


but all i get is a IllegalArgumentExecption if i use for example:

Dim mGroup(1)

mGroup(0) = category
mGroup(1) = region
oField.createNameGroup(mGroup())


Are category and region items of the field oField? They sound more 
like field names.


Niklas
--
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help


[sc-dev] Re: type logical in Excel

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 myself.)


That's older. There are already related issues 58572 and 84266.

Niklas
--

To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: sy...@sc.openoffice.org with Subject: help


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

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 it here:
http://wiki.services.openoffice.org/wiki/Template:Calc_Project


Looks good.


Also suggest to have a language table (with the option
{{Calc/Lang|Spreadsheet}} ). See it in action here:
http://wiki.services.openoffice.org/wiki/Base


Do we have suitable Calc pages in other languages?

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Issue 83783

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 box Display As Icon.


Ah, yes.
But this system dialog only appears in MS Office, not in OpenOffice.


No, I'm talking about OOo of course. It has to be compiled with OLE
support, but the downloads from the website are compiled that way.



I always use that downloads for ages, but never got this system dialog,
only the oo-OLE-Dialog.
And yes, Tools/Options/%productname%/General/Use OpenOffice.org
dialogs is unchecked.


What do you get if you select Further objects in the Insert OLE 
Object dialog?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Issue 83783

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 Object, 
and then Further objects. That's an OLE dialog, not part of OOo. It 
has a check box Display As Icon.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Issue 83783

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 As Icon in the system dialog (Further objects) 
isn't what you're looking for?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 stuff.
These differences are sometimes not clear.


Value highlighting is a view setting that can be enabled for each view 
individually. It's the property IsValueHighlightingEnabled in service 
SpreadsheetViewSettings, part of SpreadsheetView.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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);

PropertyValue[] args = new PropertyValue[1];
args[0] = new PropertyValue();
args[0].Name = AutoComplete;
args[0].Value = false;

XDispatchProvider xDispatchProvider = (XDispatchProvider)
UnoRuntime.queryInterface(XDispatchProvider.class,
xModel.getCurrentController().getFrame());

xDispatchHelper.executeDispatch(xDispatchProvider, .uno:AutoComplete,
, 0, args);

This doesn't work. Seem there is only a Toggling without args possible.
If this is true: How can I detect, if AutoComplete is On or Off?


Service com.sun.star.sheet.GlobalSheetSettings has a property 
DoAutoComplete. It can be read and modified, so you don't need the 
dispatch stuff for that.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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.XCellRangeAddressable.class,
xCellRange);

CellRangeAddress aRangeAddress = xRangeAddr.getRangeAddress();

 From aRangeAddress you can get details about range start column,start row
  and range end column,end row. Then you can get the no of columns and rows
you have in the range

int noOfColums = aRangeAddress.EndColumn - aRangeAddress.StartColumn + 1;
int noOfRows = aRangeAddress.EndRow - aRangeAddress.StartRow + 1;

Then traverse through the range using this and you can get all the cells
inside the given range.

for (int i = 0; i  noOfColums; i++) {

 for (int j = 0; j  noOfRows; j++) {

 XCell cell = xCellRange.getCellByPosition(i, j);

 }


Or if the parameter has a type like sequence sequence double   in 
IDL, which is double[][] in Java, you can just use length to access 
the array's length.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 with 
/ character
99472   DEFECT  P3  Macintos   spreadsheet  UNCONF  
 VLookup breaks if a PIPE '|'

character is used in matching c
have same root cause.

and issue http://www.openoffice.org/issues/show_bug.cgi?id=89690
(error in VLOOKUP when importing from Office2007) seems to be fixed
with oo 3.2.

can someone mark as dup/close ?


Yes, thanks for pointing this out.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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. Functionality I need is something alike the cell function
data input method. I wanted to know whether this is possible in using UNO
awt and cell range selection.


There is the XRangeSelection interface of the SpreadsheetView service, 
but it doesn't allow the same level of integration as Calc's own 
dialogs. With this interface, you can do something like the Data Range 
page of the Chart Wizard dialog, where you have a button in a modal 
dialog and start the range selection if that button is pressed. It 
doesn't allow selecting a range in the sheet with just the focus in a 
range edit, like it's possible in the Calc dialogs.


Sooner or later we'll have to extend the API here, so extensions can 
have dialogs that work like our own. So we shouldn't put much effort 
into implementing something with XRangeSelection now. Instead I suggest 
to just use simple Edit controls into which the range address has to be 
typed, like Copy sort results to in the Sort dialog. The component 
then has to parse that input. If we later extend the API, we can have 
the new API read and write from these Edit controls.


One thing you should prepare is the possibility to change your dialogs 
to modeless dialogs, because that's how Calc's reference dialogs work. A 
modeless dialog doesn't have an execute method that returns when the 
dialog is closed. Instead it performs its actions from event handlers, 
so you can't keep information in local variables across the execute 
call. To simulate this, you can just add a method like dialogClosed to 
your component, and call it directly after execute, with no additional 
parameters. If that method reads the settings from the dialog and does 
the processing, it can later be called from a listener when the dialog 
is changed to modeless.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Validator for Calc

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 task pane?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Include file error

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 still seems unusual. Are these formulas supposed to be static, or 
should they be updated when other cells change?


Anyway, if you modify cell content from UI code, you have to take care 
of repaint, undo, formula updates, and possibly row heights. There's a 
method ScDocFunc::SetCellText for a single cell, which handles this, or 
you might do something similar to lcl_PutDataArray in cellsuno.cxx.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Include file error

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,
which I will have to generate ? Also, my formula follows a different grammar
!!

What If I evalute my formula in a separate function rather than call
interpret and just return
the answer in a matrix. How do I then print the matrix ?

This is tough work. Appreciate all your help !!


If you don't want to add an OpCode and have your function called by 
formula evaluation, ScInterpreter is the wrong place for the function. 
Returning a ScMatrix might still be useful, but not necessarily so.


What are you really trying to do? It would help to know that.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Include file error

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 print the result but again,
my function resides in the ui
module which limits access to ScInterpreter. I could define a function in
ScFormulaCell that calls
the pushmatrix function and call that function from my class. I hope i am
making sense.
If opcode is a better option, where do I go and add it ?


When and from where is that function called, and what do you want to do 
with the results?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Include file error

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 formula in a cell but I would
like to display the result in a range
on the spreadsheet as the result is an array / matrix.
Can you tell me the right approach to do this !


Does that mean while a user is editing a cell, you want to put results 
into other cells, overwriting the previous content of the cells?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] crashes in m84

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 ..
  crash

It was in moments of repeated, swift editing.
I tried to reproduce with some random files and editing, but of course
was not able to reproduce. Sorry.
Nevertheless, it is behaviour that I do not know from OOo 321 - I would
have had troubles with that more often then.


Do you have some other tools running that interact with the clipboard?

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] queryColumnDifferences working wrongly ?

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 address of the cell 4,1 as an argument. The resulting
XSheetCellRanges is then used to colorize the cells in red, and also its
method getRangeAsAddresses is used to display the cell ranges in a human
readable form in A7


Each column of the range is compared to a cell in the same column and 
the row of the parameter. They are not all compared to the same value.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Include file error

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 ?


I wouldn't recommend that. If you have a function that can be used 
without ScInterpreter, you should move it out of interpre.hxx. If you're 
creating an ScInterpreter instance to call your function, better use 
ScFormulaCell instead.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] 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

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Include file error

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 should be included only from the core 
directory. Using ScInterpreter directly isn't a good idea anyway. Where 
formulas are calculated (like validity or conditional formats), we 
always use ScFormulaCell.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] 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.

Can somebody confirm and set a target?


See issue 10621. In live mode, controls use their own VCL windows.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] 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 can I
delete the window?


The No solution dialog is shown by Calc if getSuccess returns false 
after the solve call (ScSolverNoSolutionDialog in optsolver.cxx).


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] XViewFreezable

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 the view to un-split, un-frozen with 
splitAtPosition(0,0) from the XViewSplitable interface.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Statistical Data Analysis Tool

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 this project and what are the current priorities?
I've seen the GSoC project from 2007 Integrating R with Calc. Is R
integration still considered the best way to add more advanced
statistical functionality to Calc and would I be building on top of
Wojciech Gryc's code?


No, this project should preferably contain a fixed set of methods 
implemented directly in the extension, as opposed to the generic 
approach of the R integration.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] 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

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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. There have already been some 
applications for this project, I don't know if additional ones are still 
accepted. You could ask on the general internship mailing list, 
interns...@openoffice.org.


The error checking component could be an extension. See 
http://wiki.services.openoffice.org/wiki/Extensions_development for 
information about extension development. There is no specification yet 
about the UI and the details of the errors that can be handled. You 
would have to come up with some ideas here.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] 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 are used in the other functions.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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.

Nevertheless the entry in Format/Conditional Formatting.. is correct.

How can I force an update of the style?


Are you sure the style contains any format attributes? Remember you have 
to insert a new style before setting format properties (generally for 
cell styles, not only for conditional formatting).


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Validator for Calc

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. Excel has this functionality.


Oh, I see. Yes, excluded cells would be a possible check. Or a set of 
repeated formulas where one is different from the others. I don't have a 
list of possible errors, it's still open to define them.


Because this extension is not production quality we are still working on 
it, but we hit a problem that we can't avoid. If you interested I can 
send two version of it,
one that works well with A1 reference modell another (patched by Kohei) 
works well with A1 and R1C1 notation but drops mystery reference errors. 
So that is why we did not uploaded to the extension repo.


It would be best to have it available for everyone to take a look. But 
if that isn't possible, you can send it to me.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Validator for Calc

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 original version (only A1 
notation)



Please test it and share your opinion wit us!


Oh, that's very cool.

The formulas in watchwindow_1.1.2.1_kohei.oxt are wrong because you call 
the printFormula method with a wrong reference position. You have to 
pass the position of the formula cell.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 not sure if the filters are prepared to handle functions
from the Calc Analysis add-in that do not exist in Excel. Will think
about that tomorrow :)


I have collected the function names including the used categories [1]. 
This might help to decide, whether those functions, which are part of 
ODFF, should be moved to somewhere else.


[1] 
http://wiki.services.openoffice.org/wiki/File:Compare_Function_Category_Excel_ODF_OOo.ods 


Simply moving a function will cause some changes in behavior (like the 
API getFormula method). For consistency, let's add the new 
complex-number functions to the analysis add-in, so their behavior is as 
similar as possible to the existing functions.


There are already add-in functions that have no Excel equivalent (like 
ROT13 in the date add-in), probably the new functions can be handled the 
same way.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 part is due to issue 95312.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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.src too?


Yes, these help IDs are needed so help for a function can be shown if 
the Help button in the Function Wizard is pressed after selecting the 
function.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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, that huge arguments are not 
needed. For those, who really need them, a spreadsheet application is 
likely the wrong program. On the other hand this is the only place, 
where there is such a limit to sin(), afaik. Please decide.


To keep at least some consistency, I think these should also use the 
SinOverflow function, so all the complex-number functions have the same 
limit.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 constraint 
x=9,22337203685478E+018, which is much larger.


If there is no special reason, should I replace it, while I work on the 
missing complex trigonometric functions?


The 2^63 limit is there to prevent invalid results (outside of the range 
from -1 to 1). The 2^27 limit also prevents inaccurate results, like 
Leonard described. Both can be justified. The pragmatic solution, to 
avoid breaking any existing usage, might be to keep the separate limit 
for the scaddins complex number functions, at least for now.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 different from writer application ...


Full handling of optional hyphens is only in Writer, see issue 90566.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Issue 109940

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, 
including the introduction of class ScDPTableDataCache, which uses an 
stl::vector and a second vector for the order and no longer has that 
limitation. But it's not a small change, and the OOO320 and DEV300 code 
is quite different already, so we can't easily use it for 3.2.1.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 programs dir of the
installation set.
2) Opening VS2008 and attaching the process soffice.bin
3)Opening the source files that I need to debug.
4)Adding the breakpoint. But that is when the error arises.

I did everything on Calc to hit the breakpoint but nothing happens.Do I have
to build the calc source in debug mode ? Has anyone had a similar situation
?


Yes, build the affected code with debug=true. You can mix debug and 
non-debug code, so you don't have to build the whole module with debug 
information.


In fact, until CWS dr73 is integrated, building the complete sc module 
with debug info will fail, see issue 100534.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 of the different types of 
cell content, ScBaseCell and its subclasses. Formulas are handled by 
ScFormulaCell.


ScDocument has methods like GetCell/PutCell to access cells in a 
document. ScDocFunc has methods that modify a document and handle things 
like repaint and undo.


Does that help?

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Functions in Excel 2010

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 functions to Calc. They 
can probably be handled in the import filter, but nothing has been 
started yet.


A good first step would be to make an overview which new Excel functions 
have to be mapped to which existing functions. If someone wants to do 
this step, that would be great.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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
some array so that I don't have to iterate over each cell of the range .


ScRangeToSequence has helper methods to fill UNO sequences, but these 
methods just iterate over the cells, too.



Could you also shed some light on the following :

- Which file handles the calculations and recalculations in the spreadsheet.
Is it ScDocument again ?


Calculation of a formula is done by ScFormulaCell::Interpret, which uses 
ScInterpreter. After modifications to a document, cells are notified 
using broadcasters which call ScFormulaCell::Notify.



- Where exactly is ScRange (class / struct ?)  defined ? Can't seem to
locate it.


OpenGrok answers such questions 
(http://svn.services.openoffice.org/opengrok/). ScRange is in address.hxx.



- What exactly is   tableview  ? Does it refer to all the cells on the
spreadsheet ? I know that Topview = Input line view.


In the input handler, that's the EditView in the cell in the table, as 
opposed to the input line.



- ScInputHandler has a function StartTable. What is it really doing ?


It basically checks if editing is possible at the cell cursor position, 
and puts the cell content into the EditEngine.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 the remaining problems are still in progress. We don't 
want to cause performance problems for those who don't use the larger 
number of rows. See issue 110116 for an extreme example. The quick  
dirty solution of enlarging the broadcast slot sizes would slow down 
recalculation a bit. We'll try to avoid that.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] improvements to openoffice calc

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 the original data. When there is a lot of
data this is a very helpful feature for quick reference for trends etc.
Also, as I am using a netbook, it means that the graph easily fills the
screen without having to scroll through columns to find the graph. It would
be great if you could incorporate this into Calc!


Separate chart sheets have been suggested before (issue 5736) and 
would be useful. They haven't been added because it would require larger 
changes.


But you can already cut  paste a chart to a normal empty sheet in your 
file and manually resize it to the window size. That way, you have it 
available without scrolling, too.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] improvements to openoffice calc

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 ?


The slot to insert a chart is .uno:InsertObjectChart. Note that after 
executing it, the chart remains activated.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 name.


I use version 3.0.0 OOO300m9(Build:9358) in Swedish. (I don't understand 
the
data at the top of this page under Found in version and Subcomponent... 
Sorry!)


Is this a known behaviour according to design? Any reference in the 
manual that might help this customer?


If the mouse is moved some pixels while selecting a sheet, dragdrop is 
started. In 3.0 on Mac, dragdrop defaulted to copy instead of move, 
see issue 96413. This was fixed in 3.0.1.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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, because we don't know if the 
same data row ends up in a cell. But if you set the Keep formatting 
flag at the database range, formats from the first data row will be 
extended to the other rows on refreshing.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 called ScParser under
the sc/source/ui/parser directory that does the parsing
where parser is the new dir that i created.
I added a makefile for that directory and included
the header file in the inc directory under ui.
I also changed the build.lst to include my module.

A method of this class is to be called in the inputwin.cxx
file which is in sc/source/ui/app.
While the compiling of the scparser.cxx has no errors
and creates an .obj file , i get a LNK2019 for the line in
inputwin.cxx where i am calling the method of the ScParser
class. The error is unresolved external symbol .

I just cannot figure out what am i doing wrong !
Any one has any idea ?


If there's a new directory where a new library is built, that library 
has to be included in sc/util/makefile.mk. But in most cases it's better 
to add a file to one of the existing directories (sc/source/ui/app could 
be a candidate), instead of having a new directory with only one file.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 work for me.

There is a situation when the user inputs are dependent in a linear fashion
where I am thinking of implementing them as dialog. Although, I am not sure
if that is the best way. If dialogs are the best way to implement these,
then I am failing to find the right tutorial on how a dialog should be
implemented which is created during run-time from scratch.

I need immediate help on where to locate APIs which could enable me
implement a run-time dialog as mentioned in the post script.


You can create a dialog from scratch, adding one control after 
another, but why don't you just create it with the dialog editor (see 
http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/Working_With_Dialogs)?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 dependent on each other,
and therefore can be run in parallel.


Gotcha.  So Excel's formula calculation is already multi-threaded.  This
is an area we should still work on to improve with Calc.


The idea has of course come up before (see 
http://wiki.services.openoffice.org/wiki/Calc/Performance/misc), but it 
hasn't been evaluated in much detail yet.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Automatic URL Recognition

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 
people opening a spreadsheet will never have heard of db: or slot:, 
and therefore this feature will be a very bad experience.


Note that there is no separate implementation of URL recognition in 
Calc. Via the EditEngine we use the svtools implementation, which mostly 
allows all schemes that INetURLObject supports.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 ensure this change would not conflict with the extended API.


Once you have a working implementation, you can contribute it as a 
patch, to be included in future releases. See 
http://wiki.services.openoffice.org/wiki/Contributing_Patches.



  Would an extension solve the problem ?


No, an extension can only use what is available via the API.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 
new calc addin, but I don't know, how to write an extension.
I developed the algorithm in Java but now I want to intigrate it in openoffice. 
If I intigrate it, how should the user choose between the two algoritms?
The extension I want to develope should be similar to the actual extension for 
the NLPSolver. Or is it better if I work with the actual extension?


You can use the NetBeans plugin to create a new Component project and 
implement the com.sun.star.sheet.Solver service, or use NLPSolver as an 
example. But it's better to make a new extension, so both can be updated 
independently.


If you provide a new implementation of the Solver service, it can be 
selected as a new solver engine in the solver Options dialog.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 needed information, and if my correction is 
correct.


There is a problem: The patch changes more than the issue describes. See 
the comment in the issue.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 they allowed 
but not implemented yet?


INDIRECT is supposed to parse a reference, not any more complex 
expression.


So what is a 'reference'? For ISREF the help say, Tests if the argument 
is a reference. Returns TRUE if the argument is a reference, returns 
FALSE otherwise. Taking that, D1:D3!C2:E2 is a 'reference'.


The result of the expression is a reference, just like the result of 
OFFSET(A1;A2;A3). As part of a formula, like your ISREF example, the 
expression is evaluated, and the ISREF function only handles the result. 
For INDIRECT, the parameter is a string, which may be the result of some 
other calculation, but the string isn't parsed and evaluated before it's 
passed to the function.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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(INDIRECT(A1~B1)) returns FALSE

And INDIRECT((A1:C3):(B2:D4)) fails too.

Are expressions as text not allowed for INDIRECT or are they allowed but 
not implemented yet?


INDIRECT is supposed to parse a reference, not any more complex expression.

And same with issue 104969, References to external sheets not allowed or 
 allowed but still need to be implemented?


INDIRECT with external references works (works again, see issue 101645). 
The problem in issue 104969 seems to be the use of OFFSET together with 
external references.


And what about all type of names? INDIRECT(name) will fail. I know, 
that is mentioned in the help. But must it fail?


The help is outdated here. Support for named ranges was added some time 
ago (issue 4695).


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 be extremely grateful !


The existing range highlighting might be a good start. It's initialized 
in method ScInputHandler::InitRangeFinder in sc/source/ui/app/inputhdl.cxx.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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 direct references only (no 
names), and it's only highlighted in the cell, not in the input line 
(formula bar).



Someone suggested using a text cursor but i believe that it only for
text objects. How can I modify and format the text in the formula bar and
not the cell.


The text cursor API also works for cell content. But that's the content 
after editing, not what is currently edited. For currently edited text, 
there's only special-purpose API like XTransferableSupplier, so I think 
what you describe can't be done without modifying OOo code.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



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

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.openoffice.org/wiki/Documentation/Building_Guide. 
Then, after modifying something you can just build a single module again 
and copy the binaries into your installation.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

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 file.

   If that, we need the approval of the ODF format proposal relate it.


OOo 3.x has a cache (ScDPCacheTable), but it isn't saved, and the 
results are still created using ScDPItemData. We'll have to see how we 
can put these things together. Also, you're right, we'll have to clarify 
the file format handling.


A little update on the file format part:

The current plan is to extend the ODF format version list box in the 
options dialog with an additional entry, to select between 1.2 and 
extended 1.2 (extended in the ODF 1.2 sense).


If 1.2 is selected, nothing is saved that is not in ODF 1.2.
If 1.2 extended is selected (the default), extensions are saved as 
foreign elements/attributes (this means, in a different namespace - 
but accept both namespaces when loading).


Also, we want to use extensions sparingly, and generally only if a new 
feature is really used. This is difficult with the cache table, where 
the obvious approach is to always write it.


File format extensions are also needed for shapes in charts and notes in 
Impress, so the UI and configuration change will probably be implemented 
for one of these features (details will be sorted out next week, but 
then I will be on vacation).


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

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

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-07-31 Thread Niklas Nebel

On 07/31/09 16:28, Kohei Yoshida wrote:
- Extensions to the DataPilotSource API must be done in a compatible way 
(see the handling of the Filter property).


I've reviewed my change against the baseline, and my only addition to
the UNO API is two new constant values to MemberResultFlags.  It's my
understanding that adding new constant values to the existing constant
set is considered binary compatible.

Having said that, it's entirely possible that I'm misunderstanding the
intent of your comment here, so could you please clarify on this point?


An extension can supply its own implementation of the DataPilotSource 
service, which can then be used with the External source/interface 
option (see 
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/DataPilot_Sources). 
To maintain compatibility with such extensions, Calc must not rely on 
the presence of new, added properties. This is different from services 
which are only implemented in Calc.



Also, I'd like to see how the Filter property was handled in a
compatible way.  Could you point me to the place to look for?  I did my
own search, but I couldn't find what may look like the code you are
referring to.


For the Filter property, ScDPSaveDimension::WriteToSource just has to 
be prepared for an exception from setPropertyValue, because it's not an 
error if that property isn't supported.



I've switched to using SvxCheckListBox for the member list control.  So,
that should take care of that part of the accessibility, I assume.

Also, I'd like to know more about the accessibility function
requirements.  Could you give me some pointers, please?  I'm not that
familiar with accessibility requirements, as that subject always sounded
too abstract to me...  Any details would be great.


It has to work. :-)
See http://wiki.services.openoffice.org/wiki/Accessibility for some more 
information and which tools can be used.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Improvement for Cell Range Picker of the Validity dialog

2009-07-23 Thread Niklas Nebel

On 07/23/09 10:34, Yan Peng Guo wrote:

We (IBM) has done an improvement for Cell Range Picker of the Validity
modal dialog, and would like to contribute the code back.
Currently, in OO3.1, if a user selects Cell Range in Allow list of the
Validity dialog, (s)he has to input the range manually, unlike other
modeless dialogs having cell range picker function, which have a shrink
button to switch to range picker mode, or can directly select a range from
the editing area, such as Consolidate dialog and so on.
We enabled a shrink button besides the range source list-box of the
Validity dialog so that users can click it to switch to range picker mode.
And when focus is in the range source list-box, the Validity dialog will
switch from modal to modeless so that users can directly select a range. If
focus is moved out from the list-box, the dialog will switch back to modal
again.
If we would like to contribute the code, any advise would be appreciated.


That sounds good. Do you have a patch available? Then it would be best 
to attach it to issue 66484, so I can take a closer look.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Re: [qa-cvs] Maitanance of Bug #326914

2009-07-17 Thread Niklas Nebel

On 07/17/09 17:19, Joost Andrae wrote:

Tshepiso Rantho schrieb:
As part of my final year project assignment, i have been assigned to 
create a patch for Bug #326914:table border color doesn't work 
correctly. How do i get hold of the code and how do i cooperate with 
you to successfully complete my assignment.


It works as intended, although that's probably not what you wanted to 
hear. :-)


Seriously, the Format Cells dialog modifies only the selected cells. 
Sounds obvious thus far, but it means the adjacent cells keep their 
black borders. Where adjacent cells have different borders, the thicker 
border is drawn. In your example, the width is the same, so that rule 
doesn't help, and the border from the bottom or right cell is used.


If you want to experiment anyway, see 
http://wiki.services.openoffice.org/wiki/Development/OpenOffice.org_Building_Guide 
about how to get the source and build it. Then, ScOutputData::DrawFrame 
(sc/source/ui/view/output.cxx) for drawing and 
ScViewFunc::ApplyPatternLines (sc/source/ui/view/viewfunc.cxx) for 
applying the borders are good starting points.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Problems with BESSELJ

2009-07-09 Thread Niklas Nebel

On 07/09/09 12:17, Regina Henschel wrote:

(2) I have tried the following too. Instead of my provisional
return 888.88;
I write
throw ::com::sun::star::uno::RuntimeException();
Now the spreadsheet shows
#VALUE!
in cell and
Error: Wrong data type
in status bar in that cases.

But it shows this, whatever I write in 
ScUnoAddInCall::ExecuteCallWithArgs(). I have tried it there with


catch(uno::RuntimeException)
{
  nErrCode = errNoConvergence;
}

and (only for testing) with

catch(uno::Exception)
{
//nErrCode = errNoValue;
nErrCode = errDivisionByZero;
}

Where comes the #VALUE! from?


XIdlMethod::invoke wraps exceptions from the add-in in an 
InvocationTargetException. You have to extend the handling of that one.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-07-09 Thread Niklas Nebel

Kohei Yoshida wrote:

On Fri, 2009-06-26 at 17:19 +0200, Niklas Nebel wrote:

In addition to the visual comments on the ux-discuss list


Which I assume is this one:
http://ux.openoffice.org/servlets/ReadMsg?list=discussmsgNo=3658


Yes, that's what I meant.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-26 Thread Niklas Nebel

On 06/20/09 02:38, Kohei Yoshida wrote:

Ok.  All my changes related to DataPilot are now in koheidatapilot03
cws.  I'm also working on specs on the wiki.  They are at:

http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_enhanced_field_popup_window
http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_custom_display_names

The first spec is pretty much complete, while the second one is still
being worked on.

Also, FYI, I'll be on vacation for the entire next week.  So, whatever
change still needs to be done will be done after I get back.


In addition to the visual comments on the ux-discuss list, some 
technical remarks (I haven't looked through all of it yet, expect more 
to come):


- Extensions to the DataPilotSource API must be done in a compatible way 
(see the handling of the Filter property).


- We have to pay attention to keyboard accessibility (obvious key 
choice: Ctrl-D, as for page fields).


- The popup window has to implement accessibility API. Generally the 
easiest way for that is to use existing controls, like SvxCheckListBox 
for the item selection. For the menu entries a new control would have to 
be implemented, including the accessibility functions. Perhaps it's also 
possible to extend the VCL popup menu with an extra window, but I can't 
guarantee that's even possible without running into new problems.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-25 Thread Niklas Nebel

On 06/25/09 10:17, Xu Ming Wang wrote:
We are migrating our work to 3.x code base now. If need, we can extract 
these parts. Data buffer may need some refactoring work with the class 
ScDPCacheTable.


Extracting smaller parts from your changes would make it much easier to 
integrate the changes. Especially the performance improvements don't 
need any User Experience discussion and could be integrated quickly.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-24 Thread Niklas Nebel

On 06/24/09 05:00, Xu Ming Wang wrote:

- The data in the Quantify screenshot looks strange. For any larger
calculation, screen output (OutputDevice::DrawLine) shouldn't play a
significant role.
   It maybe relate to Quantify environment - drawing is very slow.
   Actually, ScAttrArray::ApplyBlockFrame is a low performance function.
   If the output table about 1 rows, ScDPOutput::Output() used 8-10 
seconds in our test environment.

   Current solution, to data area in the table:
   Case 1:  all cells need set border, then setting block frame border 
only once is ok.
   Case 2:  otherwise, set block frame border like this


Applying the frames takes some time in a large output table, that's right.


- Data Source buffer sounds interesting. Now it would of course be
helpful to see the actual code changes for it.
   It is something like Excel's PivotCache, and better to save it in the 
document file.

   If that, we need the approval of the ODF format proposal relate it.


OOo 3.x has a cache (ScDPCacheTable), but it isn't saved, and the 
results are still created using ScDPItemData. We'll have to see how we 
can put these things together. Also, you're right, we'll have to clarify 
the file format handling.



- The allocation for all members (B1,B2,B3) is what issue 55266 is
about. In the Solution Description section, there's only the heading.
Do you have a solution for that?
   I have a solution in LateInitFrom. To row data, only new 
ScDPResultMember when find it.


Excellent. I had something like that in mind for issue 55266, but never 
found the time to actually try it.


All three changes you mention still seem to be valid and useful for 3.x. 
How big are the individual changes, is it possible to extract them, so 
we can try to update them to the 3.x code base?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-23 Thread Niklas Nebel

On 06/23/09 17:24, Zhi Yu Yue wrote:
Struggled a little with the wiki editing, and here is the performance 
part. Thanks, Xu 
Ming!http://wiki.services.openoffice.org/wiki/Calc/Proposal_DataPilot_byIBM


Great, thanks. Some comments:

- The data in the Quantify screenshot looks strange. For any larger 
calculation, screen output (OutputDevice::DrawLine) shouldn't play a 
significant role.


- Data Source buffer sounds interesting. Now it would of course be 
helpful to see the actual code changes for it.


- The allocation for all members (B1,B2,B3) is what issue 55266 is 
about. In the Solution Description section, there's only the heading. 
Do you have a solution for that?


Not completed, but should be OK to start some discussion. We will then 
turn to the UX spec.


For the UI features, note that Kohei's changes are now available, with a 
description at 
http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_enhanced_field_popup_window 
and 
http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_custom_display_names. 
You should take a look at that and see where your proposed changes are 
different.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?

2009-06-22 Thread Niklas Nebel

On 06/21/09 22:57, Regina Henschel wrote:
In ODF1.2 draft spec I read, MULTIPLE.OPERATIONS executes the formula 
expression pointed to by FormulaCell and _all_ formula expressions it 
depends on while replacing _all_ references to RowCell with references 
to RowReplacement respectively all references to ColumnCell with 
references to ColumnReplacement.


I think that the terms execute formula expression and while 
replacing is not exact enough.


(1) I interpret it in the way, that I first replace all references, 
generating intermediate, temp sheets, and then evaluate that sheet. I 
get the following:


The references are replaced dynamically during calculation, not in a 
separate step up front. The implementation uses a list of active 
replacements in the document (aTableOpList), no modified copies of the 
formulas are made.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?

2009-06-22 Thread Niklas Nebel

On 06/22/09 17:10, Regina Henschel wrote:

Right. A1+A2 is calculated as A1+A6, which is 2+700, or 702.


So OOo drops =MULTIPLE.OPERATIONS(A3;A6;A4)? OOo acts as if the 
formula in A5 is =A3.


All references to A6 in A3's formula are replaced with A4. There are 
none, so the result is A3, unchanged.


OFFSET doesn't mix well with MULTIPLE.OPERATIONS because it's one of 
the functions that cause the cell to be recalculated on any change, 
like RAND or NOW. So the changed formula depends on the special 
ALWAYS range, not on A2. That's a matter of implementation, and 
could probably be changed, but it doesn't look like a high-priority 
issue.


That means, that it is another problem and a real bug and the result 
should be 18 in both cases? [18= 11 (content of one position after A4)+7 
(content of A4)]

OOo Later would be OK for me.


A bug or a limitation, whatever one might call it, but certainly 
different from the other case.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-19 Thread Niklas Nebel

On 06/19/09 10:58, Zhi Yu Yue wrote:
It spent a little more time than I thought to organize it. Where should 
I post it? should I create a new wiki page? Thanks.


Yes, a wiki page would be good.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] NLP Solver program Levenberg Marquardt

2009-06-19 Thread Niklas Nebel

On 06/19/09 14:59, Martina Fares wrote:

I'm new here, and I don't know a lot about `to program in OpenOffice`.
I want to develope the Levenberg marquardt algorithm in the NLP Solver.
I get the source code of the NLP, but now I want to know what I should do if I 
want to include the source code to netbeans.


The NLPSolver extension is a NetBeans project, you should be able to 
open it directly.



Is there some place where I should tell that I want to program the algorithm, 
so that  nobody else look for this algorithm.


You just did. :-) You could also create a new page in the wiki 
(wiki.services.openoffice.org), and describe what you're doing.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Request on some issues

2009-06-18 Thread Niklas Nebel

On 06/18/09 16:36, Cor Nouws wrote:

Yesterday I came across some issues, that might need a new owner:
 - 102022
 Data validity using cells area don't work after export to xls


Anything xls-related can be dumped on Daniel (dr). :-)


 - 3007
 Hatching fill within a cell


Honestly, it doesn't matter. It's well known that this feature is 
missing, and if we get around to implementing it, we'll find the issue, 
regardless if it's assigned to requirements or any individual person.



Also, I checked other issues that IMO are fixed in the mean time :-)
57298, 27057, 81178, 4880  So I set to fixed. Is it seen as responsible 
behaviour if I close those myself?


Yes. Normally, an issue is closed when the fix was seen in a milestone 
build. This is done in case a fix gets lost during CWS integration 
(merge conflicts, etc). If you found them fixed in a milestone already, 
there's no need for the separate step.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-18 Thread Niklas Nebel

On 06/11/09 10:37, Zhi Yu Yue wrote:
I need to check my colleague (Xu Ming Wang) if we can separate the code 
out. It is possibly a little difficult, but I'm not quite sure. I will 
update you later once I get the result. However I think the least we can 
do is to post some of our idea/or code here so that we can start some 
discussion. How do you think?


Are there any updates on this yet?
Like you say, it would already help to have a rough overview about your 
performance changes.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-11 Thread Niklas Nebel
On 06/11/09 05:41, Zhi Yu Yue wrote:
 I'm new here, so I list my ToDos as below. Please help to advise.
 1. Send our UX spec on user experience community for review.
   - I compared Kohei's list with mine. Most are different and should be 
 fine. One may have some overlap. Kohei, I would appreciate if you can 
 also review the UX spec after I post it. We can solve the conflict at 
 the UX level.
 2. Check in the code after UX spec is agreed. I may have more questions 
 at that time.

That's a good plan for the UI changes.

One thing that doesn't need UX review is the performance improvements.
Can you separate the performance changes from the rest? Then we could
work to integrate them already in parallel with UX discussion.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-11 Thread Niklas Nebel

On 06/11/09 10:37, Zhi Yu Yue wrote:
I need to check my colleague (Xu Ming Wang) if we can separate the code 
out. It is possibly a little difficult, but I'm not quite sure. I will 
update you later once I get the result. However I think the least we can 
do is to post some of our idea/or code here so that we can start some 
discussion. How do you think?


Yes, sure, that would help.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-10 Thread Niklas Nebel

On 06/10/09 04:15, Kohei Yoshida wrote:

On Wed, 2009-06-10 at 09:26 +0800, Zhi Yu Yue wrote:

We (IBM) has done some improvements on DataPilot (improved UI,
performance, cache support, ...), and would like to contribute the
code back. I know there are also some DataPilot work ongoing here.
What steps should we follow? or who can I contact? I have already read
the guide here, http://contributing.openoffice.org/programming.html.
It says I should come here. Any advise would be appreciated. 


I've already sent you an email, but the first thing we need to do is to
coordinate our work to avoid duplication of effort.  I have several
DataPilot work in the pipeline, so we need to make sure we don't step on
each other's toes.


I have to disagree here. If IBM wants to contribute their changes, 
that's great and should be done right away, without waiting for go-oo 
changes that are being held back instead of contributed.


Kohei, if you do your changes outside of openoffice.org, there's always 
the risk of duplicated work. Remember the solver? It's your decision, 
but don't try to inflict the same on others.


Helen, performance is on my agenda anyway, so we can work together on 
that very quickly. For UI changes, we have to involve the User 
Experience community. It would be best if we have a summary of the UI 
changes that we can discuss on the disc...@ux.openoffice.org list.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-10 Thread Niklas Nebel

On 06/10/09 11:08, Zhi Yu Yue wrote:

Either way is OK for me. I just want to contribute the code quickly. :-)


That really sounds very good.

Let me give my list first. We started this work mid of last year. Some 
work are based on OpenOffice code, while some are new. I list the new 
items as below. We may still need some time to migrate to new code base. 
I will soon send the UI related specification to user experience mail list.


Find some comments on the list items below. The next steps could be two 
things in parallel:

- Discussion of the UI changes with ux community.
- Looking at the performance improvements (see below).

-- New sidebar UI: Users can easily assign fields in sidebar by only 
drag and drop anytime to change the table structure and access the 
commands easily.


I assume this depends on the general sidebar infrastructure?
The quickest way to get such an extra window into OOo is to use a 
docking window, like the Navigator or styles. See 
ScFunctionChildWindow (Insert - Function List) for an example in Calc. 
It's a VCL window, of course, so the interaction inside the window has 
to be done with VCL controls.


-- Empty table, default table style, and auto-resize: since we still do 
not support the AutoFormat, we improved the user experience by providing 
the instructions on empty table, well-defined table style by default, 
and also automatically resize the width when the table is created.


This sounds like something that can be applied to current code without 
big changes.


-- Duplicate items: users can drag the same fields multiple times, and 
set different field settings.


For data fields, right? It's mostly the dialog that currently doesn't 
handle this.


-- Cache/buffer support: MS Excel has this feature. With this, even the 
data source is deleted, the DataPilot table can still be updated.


Internally, OOo now uses the ScDPCacheTable. So in this area there will 
probably be conflicts. But ScDPCacheTable still has some problems with 
memory usage, maybe your solution is even better.


-- Performance: roughly ~40% improvement on generating table and fields 
operation


Which parts were improved? We've had some improvements with issues 63686 
and 72188. Do they overlap with your changes?


It would be great if you could isolate your performance improvements 
from the other changes. If you have a diff against the old code, I would 
like to look at it to see if the changes can be used with the current 
version. This could then be the first thing to integrate.


-- Field items show/hide UI panel: provide a new filter panel to 
show/hide items easily. Users can also set Top N in this panel.


This sounds similar to what Kohei has announced but not yet contributed. 
Let's see if he wants to contribute his changes now, then we can try to 
merge them.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] about DataPilot

2009-06-10 Thread Niklas Nebel

On 06/10/09 16:51, Michael Meeks wrote:

What makes you think they are being held back ? the issues around
DataPilot that Kohei are working on have been communicated quite clearly
to Sun - eg. i#101328 - how clear can it be: the comment accepting it
for 3.2 from Kohei; i#100619, i#22029 both assigned to 
Kohei, all fitting the mould of work we send up-stream.


It seems extraordinarily short sighted, and saddening to try and
avoid co-ordination on this; it makes it appear that you almost relish
destroying other people's work by duplication, even when they are trying
hard to work with you - which is a highly unfortunate and unpleasant
position. Strangely, sad to say, this is a friction that is not normally
experienced when dealing with your co-workers.

Despite your obviously offensive mail; to make it easier for IBM to
review the changes, I've asked Kohei to create a CWS and whack the
patches in there - please don't do the normal witheringly negative critique,
they may not be completely ready yet. FWIW, I'm always amused when I ask for
design review, people prefer instead to rave about commented (or not)
debugging fprintfs instead ;-)


There is code that the IBM people want to contribute now, and code that 
you advertise as a go-oo feature but didn't contribute yet. If you're 
changing your mind now, that's good. As I wrote: Then we can try to 
merge them (the changes). Otherwise, what else can we do but use the 
code that we can get? I am not going to delay integration of IBM's 
changes until you decide you've kept your changes to yourself long enough.



So - the context is that Kohei has asked, politely, and reasonably
asked, to co-ordinate this work so we don't waste effort here - he talks
of a pipeline of changes in data-pilot, of solidifying the code. And then
you turned him down: why all this aggressive talk of deliberate work
duplication ?

If you choose to dig up the past, lets do it: sure - we remember
the solver, there was my code in there too; we remember your leading
role in destroying a volunteer's spare-time creation, your tone almost
sounds as if you enjoyed that. I had always assumed this appalling
initiative to abuse, divide and stifle the 'Open'Office.org project,
purely in Sun's proprietary interest, was forced by StarDivisions's
(visionary) senior management, rather than being cheer-lead by
individual Sun developers.

Since I see almost nothing defensible about Sun's past action
here, I would (personally) recommend avoiding raking over it all again;
why don't we just get on with the technical issues around improving
the DataPilot implementation. 


For at least two years (2005 to 2007) we didn't start a solver 
component, although there was demand and the approach was sketched out, 
because I believed Kohei was going to make (and contribute) one. I don't 
want the same situation with DataPilot enhancements.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] specifications

2009-06-05 Thread Niklas Nebel

On 06/05/09 11:03, Ain Vagula wrote:

Where can I find specifications about new features in oo.o calc 3.0 and later?
http://specs.openoffice.org/calc/index.html shows specifications only
for 2.0 and in wiki and documents sections I dont find anything too.


Where specifications exist, they are mostly attached to the issues. For 
smaller or more obvious changes, it's often just a discussion thread on 
the ux-discuss list, or some comments in the issue. Some are also in the 
wiki at http://wiki.services.openoffice.org/wiki/Calc/Drafts. Are you 
looking for anything in particular?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] About Issue 66028's correct behavior.

2009-05-26 Thread Niklas Nebel
On 05/25/09 05:33, maoyg wrote:
 I suggest the following behavior:
 
 For calculating the continuing interval, not-empty hidden cells are
 treated as if they were not hidden, and empty hidden cell are treated as
 if they do not exist.
 The hidden cell are only considered in drag direction.
 The target area gets the same merge pattern than the source range.
 Dragfilling overwrites all existing values.
 
 My idea is all hidden cells are treated as if they do not exist, but I need 
 still to ask ux-discuss's and Niklas's advice.

Non-empty overlapped cells are quite rare, but if they occur, we
shouldn't ignore them. But perhaps we should extend Regina's suggestion
to all empty cells, even if not overlapped (hidden) by merged cells, so
any sequence of 10,empty,20,empty would be continued with 30,empty,40,empty.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Generating calc spreadsheet from c#

2009-05-20 Thread Niklas Nebel

On 05/20/09 09:54, Wayne Douglas wrote:

I'm creating a reporting tool using c#, nhibernate, castle monorail and sql
server. I'd like to be able to generate spreadsheets on the server which
have some grouping, outlining and basic formatting.

My questions is this: do I firstly need to have oo installed on the server
or can I just pull in the dlls I need and if I can get away with only
pulling in the dlls i need - where do i start? :)


The OpenOffice.org code works only when installed properly. But you 
could take a look at the ODF Toolkit Project, http://odftoolkit.org/.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Hi, could some developer answer some questions?

2009-05-11 Thread Niklas Nebel

On 05/10/09 10:15, Isaac M. Marcos wrote:

I need to solve some bugs in OOfice.

I am willing to code if you could point me in the right direction.


Great, welcome.


Let's assume I am a complete *newb*, Could you guide me to start?


The first step is building OpenOffice.org, see 
http://wiki.services.openoffice.org/wiki/Building_OpenOffice.org.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] About issue 60401#'s behavior.

2009-03-30 Thread Niklas Nebel
On 03/27/09 10:09, maoyg wrote:
 I have a small problem about issue 60401's behavior.
 for example, the data ranges is from B4 to D8, I select data range from C2 to 
 C5, 
 the cursor's position locate C5, according to cursor's position,I will extend 
 the data 
 range to B4:D8,this behavior is right, then when I select data range from C2 
 to C5,
 the cursor's position locate C2, according to cursor's position, it will not 
 extend the data range, 
 the both data range is same,only the direction is different,but the result is 
 different, 
 what do you think of that?

I think that's fine. If the detection is based on the cursor position,
that's easy to describe and explain. But if the whole column is
selected, the range should still be found.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Excel 2003 XML export

2009-03-18 Thread Niklas Nebel

On 03/18/09 13:48, Eike Rathke wrote:

That's http://qa.openoffice.org/issues/show_bug.cgi?id=96018

We should consider to drop that filter completely...


+1

Objections, anyone?


We'd still have the same kind of issues with any user-defined XSLT 
filters. We just wouldn't know it.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Multiline formulae support

2009-03-06 Thread Niklas Nebel

On 03/06/09 00:47, William S Fulton wrote:
Well, I finally found some time to get back to this, sorry for delays. 
Tabs and newlines are now replaced with spaces for DDE linking. Please 
see latest patch: 
http://www.openoffice.org/issues/show_bug.cgi?id=35913. Is now the right 
time to set up a CWS as mentioned above or are there any more 
suggestions for improvement?


Great! This looks good now, ready to make a CWS.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] About issue 8302#.

2009-03-03 Thread Niklas Nebel
On 03/02/09 08:38, maoyg wrote:
 I submit the second patch about issue 8302 today, I find a problem when I 
 test it.
 For example,the merged cells are B2:D2,B3:D3,B4:D4,B5:D5...B40:D40, I 
 selected C column,
 click Insert Columns,the inserting merged cell is right, I click Undo 
 command,the calc is very slow,
 because it will mark range from B40:D40,B39:D39... to B3:D3,B2:D2.
 if the merged cells are B2:D2,B3:D3... to B20:D20,click Undo command,the calc 
 is very quick.
 this problem is very important, if the user use this feature,he/she will feel 
 the calc is slow.
 I think this problem is related to the UnmergeCells/MergeCells, can we solve 
 this problem?

Do you mean the scrolling of the view, if some of the merged ranges are
outside of the currently visible area? That is done by the undo actions
for merge/unmerge. To get rid of it, the undo actions would have to know
they are part of insert cells, and then not change the view.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



[sc-dev] An experiment with incremental saving in Calc

2009-02-27 Thread Niklas Nebel
(posted to sc and performance lists; follow-ups should be on the 
performance list)


Hi everyone,

For a while, there has been the idea to speed up the saving of small 
changes to large spreadsheet documents by generating only the XML 
elements for the changed cells.


I did a little experiment to find out how much time this can really 
save. It's not a complete implementation, just a test to see what's 
possible. This is what I changed:


- Loading of the file is unchanged. No additional information is kept in 
memory after the file is loaded.


- What I keep in memory is the list of changes, as long as only 
supported changes were made. For this test, only input of numbers into 
cells that weren't empty before is supported. If any other changes are 
made, the list is discarded and the normal save code is used. For 
simplicity, it is assumed that the input doesn't change the cell's 
format. Changed formula results are ignored (in a real implementation, 
they have to be tracked, too).


- When the file is saved, and the content.xml stream is generated, first 
the old content.xml is opened and parsed for the positions of the 
affected cell elements (see below for details). Then, the output is 
generated by copying the non-affected parts and inserting a new simple 
cell element instead of each affected cell.


- The styles.xml stream is copied in unchanged form.

To find the affected cell elements in the XML stream quickly, expat's C 
interface is used, searching for qualified element names table:table, 
table:table-row, table:table-cell and table:covered-table-cell. Because 
this is just an optimization, I can assume that our own namespace 
prefixes are used. Parsing is stopped when the last affected cell was found.


For testing, I used a large, simple file with 50 cells, only text 
and numbers.


In CPU time (measured with callgrind), normal saving takes 20.1 billion 
cycles. Incremental saving with three values changed at the top of the 
file takes 6.3 billion, and with three values changed at the bottom it 
takes 11.4 billion cycles. Note that a real implementation would 
probably need some additional checks that might increase the time again.


In exchange for these saved CPU cycles, there is a bit of additional 
file access to read the old streams again. This isn't much, because they 
can be read from the compressed file. Reliably measuring the total time 
isn't easy, but quick tests with a larger file show the time for 
incremental saving to be around 50% of normal for changes at the top, 
and 70% for changes at the bottom. On other machines, this might be 
totally different.


What next?

As mentioned above, the immediate goal of this was only to get the 
numbers of what is possible. Before making a real implementation of 
this, we should see where we can get by improving the normal saving, 
because that would benefit all usages, not only specific, limited 
modifications.


For reference, the code of this experiment is in the CWS calcincsave. 
I also put this text into the wiki, at 
http://wiki.services.openoffice.org/wiki/Calc/Performance/Incremental_Saving.


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Bug with named ranges and validation

2009-02-25 Thread Niklas Nebel

On 02/25/09 16:54, Cor Nouws wrote:
I experience a bug, must be related to OOO310mx, bug can't pin it down 
exactly. And what I find in IssueTracker (#97857, #89014, #98174) does 
not look related.


I did some tests with test documents. But cannot (yet) reproduce.
However, I can't send the document involved.
I'll try to get it clear of course.
But just to be on the safe side, here what I have seen so far:

It is an .ods (long history)
- named ranges on sheet3
- columns with Date|Validity  Criteria Allow .. Cell range Name ...
- I use the document both in 3.0.1 and OOO310mx
- Problem:
Sometimes it is impossible to enter data in the columns with validation.
Ctr-D shows (iirc) err520 in OOO310mx and #name in 3.0.1
The same appears in the field Source from the dialog, where I can 
correct the error by re-entering the range name.


I can see that in OOO310m1 (in fact caused by issue 98174, the error is 
in saving the file), but not in OOO310m2. Which is the OOO310mx that you 
used?


Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] About Issue 8302#.

2009-02-24 Thread Niklas Nebel
On 02/24/09 17:14, maoyg wrote:
 Last friday, I tested some questions about issue 8302# when inserting cells.
 For example, the merged cells are from B1:D1,B2:D2,B3:D3 etc...
 when I selected C column,inserting cell,the merged cells can't be 
 inserted rightly,
 this problem have been solved on monday.I encounted the other problem 
 again,
 the merged cells are from B2:D2,B3:D4,B5:D5,B6:D7,B8:D8,B9:D9 etc...,
 the merged cells can't be inserted from B8:D8,B9:D9 etc...
 so far,this problem haven't been solved. I debug the program,
 I find the class ScDocAttrIterator exist some questions, when the merged 
 cell B6:D7 have been unmerged,
 the data member pArray-pData[nPos].nRow will be changed in 
 ScAttrIterator::Next(...).
 for example,firstly before inserting, pArray-pData[0].nRow = 
 0,pArray-pData[1].nRow = 2,pArray-pData[2].nRow = 3,
 pArray-pData[3].nRow = 5,pArray-pData[4].nRow = 
 6,pArray-pData[5].nRow = 8,pArray-pData[6].nRow = 65535...
 when the merged cell B6:D7 have been unmerged, pArray-pData[0].nRow = 
 0,pArray-pData[1].nRow = 6,
 pArray-pData[2].nRow = 8,pArray-pData[3].nRow = 65535... I don't know 
 how to solve this problem,
 Have you any good idea?

I assume the data is for column C. Then it looks right. The AttrArray
collects ranges of equal attributes in a column, not necessarily each
merged range separately. The cells that are covered by a merged cell
have a ScMergeFlagAttr that stores if the cells are overlapped
horizontally or vertically.

In the example before inserting, row 0 (C1) is not overlapped. Row 1
(C2, part of B2:D2) and row 2 (C3, first row of B3:D4) are both
overlapped horizontally, so they have the same attribute and only one
entry in the AttrArray. Row 3 (C4, second row of B3:D4) is overlapped
both horizontally and vertically. The remaining rows are treated similarly.

After unmerging B6:D7 (and the cells above that, I assume), the rows up
to 6 (C7) are not overlapped, 7 and 8 (C8 and C9) are overlapped
horizontally. Row 0 is different because it still has the empty
attribute ItemSet, and 1 to 6 contain an Item with the value no overlap.

If there is a problem, it's probably in how you use these values.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] color of tabs

2009-02-23 Thread Niklas Nebel

On 02/22/09 15:23, Mathias Röllig wrote:

Actually selected Tabs are white. But IMO these should have the same
color as selected row/column headers resp. unselected tabs should have
the same color as like as unselected row/column headers. For
consistence. And for a better difference. And these colors come from the
theme of the OS.


The current colors are from the system, too. The background for the 
selected tabs is the window background color, not necessarily white (the 
patch in issue 94452 would break this, but it was fixed before 
integration). This makes sense for best readability of the sheet name.


A different look of the tabs could be imagined, but keep in mind:
- The same tab bar is also used in Draw and the Basic IDE.
- A more distinct selection background might interfere with the 
changeable tab backgrounds (issue 5560).


So a new look should really be discussed on the ux-discuss list, not here.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] date serial number conversion

2009-02-12 Thread Niklas Nebel

On 02/12/09 17:58, Ain Vagula wrote:

date serial number 11274306 gives result 31.12.32767, when cell is
formatted as date
next number, 11274307 gives result 01.01.-32768, year is negative?
More interesting results:

number   date=day() function

123456789027.01.-25840  31
12345678916.03.1223331
12345678 25.04.-29835   31
11274307 01.01.-32768   31
11274306 31.12.3276731
11274303 28.12.3276731
123456   03.01.2238  3
1234518.10.1933 18

Why some years turn to negative?


See issue 75335, but note that it's prio 4.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



Re: [sc-dev] Python on Windows

2009-02-05 Thread Niklas Nebel

On 02/04/09 15:53, Erich Neuwirth wrote:

I plan to do some development work with Python in OOCalc.
I could not find consistent instruction on how
to make it work, and the examples in my installation
do not work.
I also could not find recent official statements
about the state of things (probably my fault).
Can somebody tell me where to find the information
I need, and some examples, i.e. how to make
a function defined in Python a worksheet function
in OOCalc?


The udk-dev list is better suited for Python questions.

Niklas

-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org



  1   2   3   >