[sc-dev] oo 1.1.5: inserting form control via script - can't print until save reload

2005-11-02 Thread Oliver Brinzing
Hi, the following basic script will insert a form control into a spreadsheet. but it is not possible to print the form control (have a look at the print preview) printing of the form control will only work after a save relaod ... any hints whats wrong ? no problems so far with oo 2.0 ... i

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

2006-01-06 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, i found that, the oSheet.copyRange(oDstCell, oSrcRange) does not work, if cells in the destination area are merged ... this is not a real problem, cause you can unmerge the destination range before the copy ... -

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

2006-04-20 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have a problem using cut paste on non protected cells (input area) on password protected sheets: Example: A user insert values into non protected cells to do some calculations. The sheet is password protected, the user can not change the

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

2006-04-20 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, Disabling it only on the protected sheet wouldn't be enough, a protected formula might as well depend on cells on non-protected sheets. Also, it's not only cut paste, but also stuff like drag drop and inserting/deleting cells. yes,

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

2006-05-04 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, Edit mode isn't directly available in the API (see issue 20210). What you can do right now is change the selection (select a different cell, then the original one again). This will always end the edit mode. yes, i can do so, but i

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

2006-05-05 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, Is there any deeper meaning to the inclusion of Cell into only some of the method names? No, i had a look at some java classes (javax.swing.AbstractCellEditor, javax.swing.plaf.TreeUI,...) and found a mixture of names indeed i

[sc-dev] OO-DEV m165 - sometimes the screen is not

2006-05-05 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I just tried out the latest oo dev-build m165 and have problems with the display update in calc now. I use a Listbox (form control) to change between the sheets, this originally caused oo 1.1.5 to crash

Re: [sc-dev] OO-DEV m165 - sometimes the screen is not

2006-05-05 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, Is this with the file from issue 33728, or something more complicated? yes and no, i used a newer version of this file ... I will try to reproduce this behaviour over the weekend and send you some screenshots :-) Is it possible to

Re: [sc-dev] OO-DEV m165 - sometimes the screen is not

2006-05-09 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, I will try to reproduce this behaviour over the weekend and send you some screenshots :-) can not reproduce it with m167 at the moment :-) Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45

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

2006-06-22 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, how can I reference a cell containing text with linebreaks ? example: Cell A1:Hello - linebreak (Strg) (Enter) World Cell B1: =A1 result: Hello World in B1 the linebreak char *changed* into a space char (code 32)

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

2006-06-23 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Peter, This is a known issue (30781), thanks, next time i will ask you before asking the community :-) IMHO this should be treated as a bug, cause the linebreak char is changed into a space (code 32) ... Oliver - -- GnuPG key 0xCFD04A45: 8822

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

2006-06-23 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, The first cell doesn't contain a line break character. It contains two paragraphs. this is true, if one acesses the cell via basic getString() method ... example: A1 = Hello World Sub Test() Dim s as String s

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

2006-06-23 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, What are you trying to do? You have multiple-paragraph content in one cell and want to use each paragraph in a separate formula? How does the content get into the first cell? the main purpose is to fill a (merged) cell with address

[sc-dev] pdf_calc_Export for single sheet possible ?

2006-09-21 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, is there an easy way to export a single sheet (which can contain 1-X print pages) to pdf ? for example: a calc document contains: sheet1 1 page sheet2 2 pages sheet3 1 page How to export sheet2 ? Do we have the same problem as

Re: [sc-dev] Table Highlighting

2007-07-06 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, please have a look at http://qa.openoffice.org/issues/show_bug.cgi?id=10957 are you talking about the same limitation ? Oliver Am 05.07.2007 19:24 schrieb Kohei Yoshida: On Thu, 2007-07-05 at 19:04 +0200, Niklas Nebel wrote: Leonard Mada

[sc-dev] XNamedRanges - how to listen to changes ?

2007-07-26 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, maybe i am blind, but how to listen to changes of NamedRanges (addNewByName/removeByName) ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32)

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

2007-07-26 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, is it possible to listen for a change of the current sheet in OO 1.1.5 ? In OO 2.x I use the XActivationEventListener .. Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version:

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

2007-07-27 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, You could use a SelectionChangeListener and then compare the current sheet's index. yes, that's what i had in mind too ... hopefully i will not run into performance problems ... thx Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956

Re: [sc-dev] XNamedRanges - how to listen to changes ?

2007-07-27 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, No, there's no notification for that. I am thinking about an RFE for this ... Cause the NamedRanges are an unsorted list, IMHO it will make sense to get informed if one has to update a sorted list ... Further on i am thinking about

[sc-dev] XActivationBroadcaster - crash after switching from printPreview back to sheet ...

2007-08-05 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, i add a XActivationEventListener to a calc document using: XController xController = xModel.getCurrentController(); XActivationBroadcaster xActivation = (XActivationBroadcaster) UnoRuntime

Re: [sc-dev] XActivationBroadcaster - crash after switching from printPreview back to sheet ...

2007-08-07 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Eike, No, but crashing surely is a bug. Please file an issue. http://www.openoffice.org/issues/show_bug.cgi?id=80437 regards Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE-

Re: [sc-dev] XActivationBroadcaster - crash after switching from printPreview back to sheet ...

2007-08-13 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi http://www.openoffice.org/issues/show_bug.cgi?id=80437 is it possible, that someone can verify thsi bug ? it makes XActivationBroadcaster unusable ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45

Re: [sc-dev] ValueHighlighting

2008-01-04 Thread Oliver Brinzing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Peter, IIRC in a former StarOffice version ValueHighlighting was stored with the document. are you talking from so5.2 ? AFAIK oo 1.x seems to be the same as oo 2.x ... Isn't it confusing for the user that some properties of the

[sc-dev] just found ;-)

2008-07-03 Thread Oliver Brinzing
have a look: http://www.spiegel.de/netzwelt/web/0,1518,563637,00.html seem's oo has the same problem with: 29513736 * 92842033 = 2740115251665290 Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature

[sc-dev] macro fails with oo 3.0 - returns byte instead of string array !

2008-07-17 Thread Oliver Brinzing
Hi, are there any known issues with the basic engine in oo 3.0 ? i tried m23/m25 with same results ... i have code *similar* to the snippet below, which will filter Named Ranges of a calc document, for example all Named Ranges starting with X_XXX ... it will return an array of strings,

Re: [sc-dev] macro fails with oo 3.0 - returns byte instead of string array !

2008-07-17 Thread Oliver Brinzing
forget to mention, that i get a basic error (overflow) in some cases here ' mRanges is a String Typ (correct) Test = mRanges() -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature

Re: [sc-dev] macro fails with oo 3.0 - returns byte instead of string array !

2008-07-18 Thread Oliver Brinzing
Hi Daniel, But I'm not an expert, and as the code below is not specific to the Calc API, you probably should ask on the [EMAIL PROTECTED] or [EMAIL PROTECTED] mailing list. i found out what is going wrong, just run the new example ... i think this is a bug ... can you confirm ? Oliver REM

Re: [sc-dev] macro fails with oo 3.0 - returns byte instead of string array !

2008-07-21 Thread Oliver Brinzing
Hi Daniel, Yes, confirmed. Behaviour changed between 2.4.1 and 3.0, and looks wrong i submitted an issus ... http://www.openoffice.org/issues/show_bug.cgi?id=91911 Oliver -- GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein:

[sc-dev] =CELL(Width;A1) does not recognize changes of column width ?

2008-10-11 Thread Oliver Brinzing
Hi, =CELL(Width;A1) reports the cell width, for example 12 now a user changes column width - but the formula still reports: 12 pressing (F9) does not help ... only a save reload cycle will display the new column witdh ... imho a column size listener is missing here ... Oliver -- GnuPG key

Re: [sc-dev] =CELL(Width;A1) does not recognize changes of column width ?

2008-10-12 Thread Oliver Brinzing
Hi, Eike, thanks a lot :-) So as long as your default font (what's that anyway?) is not monospaced the result is even meaningless. yes but now i am can determine whether a column is hidden or not ... =WENN(ZELLE(WIDTH;A1)+0*ZUFALLSZAHL()=0 Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956

[sc-dev] *.xls import: formula =Cell(Zeile) is broken

2008-11-26 Thread Oliver Brinzing
Hi, just recieved an excel file with a formula like this: =DATUM($G$1;MONAT(A$3);((ZELLE(ZEILE;A4))-3)) OO displays Err:502, cause the argument Zeile should be row ... is it possible to fix the import or localize the arguments ? Oliver -- Sensationsangebot nur bis 30.11: GMX FreeDSL -

Re: [sc-dev] *.xls import: formula =Cell(Zeile) is broken

2008-11-28 Thread Oliver Brinzing
Hi Eike, Kohei did already some work for French and Hungarian, we could add the German keywords. Please submit an issue and list all keywords of the CELL/ZELLE function and their localization in a German Excel. http://www.openoffice.org/issues/show_bug.cgi?id=96689 just noticed i forgot the

Re: [sc-dev] strange formula Err:504 with oo 3.x

2008-12-13 Thread Oliver Brinzing
i created an issue with attachment http://www.openoffice.org/issues/show_bug.cgi?id=97225 GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature

Re: [sc-dev] strange formula Err:504 with oo 3.x

2008-12-14 Thread Oliver Brinzing
Hi Eike, I used Vista with oo 3.1 DEV300m37 Build 9371 and oo 3.0.1 DEV300m12 Build 9368 'Feiertage' point to $Input.$D$6:$E$21 if i open F3 on sheet 'Input', but points to $Input.$D$6:Calendar.$E$21 if i open on sheet 'Calendar' ! i will add 4 attachments (gif's) to show

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

2010-04-15 Thread Oliver Brinzing
Can someone give me a hint how the Optional hyphen should be used to avoid spellchecking errors in spreadsheet application ? If i need to wrap a word i have to format the cell with Format Format Cells - [x] Alignment Wrap text automatically [x] Hyphenation active If i don't want

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

2010-04-16 Thread Oliver Brinzing
Hi Niklas, Full handling of optional hyphens is only in Writer, see issue 90566. ahh, have not seen this issue till now ;-) i added two issues for: Format – AutoCorrect – While Typing not available in calc http://www.openoffice.org/issues/show_bug.cgi?id=110949 Insert – Formating Mark has no

Re: [sc-dev] Validator for Calc

2010-06-19 Thread Oliver Brinzing
Hi KAMI, Please test it and write your experience. i had a look at the validator :-) i found extremely useful: it will show the precedent's even if they are on *other* sheets, oo's detective won't do that at the moment ... some hints: - selecting a listbox item should set the spreadsheet

[sc-dev] vlookup issues ...

2010-09-28 Thread Oliver Brinzing
Hi, 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

[sc-dev] #i116833# sc: Sheet linking malfunction after document saving

2011-02-07 Thread Oliver Brinzing
Hi, http://www.openoffice.org/issues/show_bug.cgi?id=116833 is it possible, that someone from sc team can confirm ? imho this is a serious problem ... Regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital

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

2011-03-08 Thread Oliver Brinzing
Hi Niklas, Are category and region items of the field oField? They sound more like field names. yes, your're right, i have to use the field items, not the field names ;-) thanks Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc

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

2011-06-23 Thread Oliver Brinzing
Hi, 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