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

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

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

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] #i116833# sc: Sheet linking malfunction after document saving

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] vlookup issues ...

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

Re: [sc-dev] Validator for Calc

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

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

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

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

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] strange formula Err:504 with oo 3.x

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

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

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] *.xls import: formula =Cell(Zeile) is broken

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

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

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] =CELL(Width;A1) does not recognize changes of column width ?

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] =CELL(Width;A1) does not recognize changes of column width ?

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] macro fails with oo 3.0 - returns byte instead of string array !

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:

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

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

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

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 !

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

[sc-dev] just found ;-)

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

Re: [sc-dev] ValueHighlighting

-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

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

-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

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

-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] XActivationEventListener - how to listen to changes in OO 1.1.5

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

-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] XNamedRanges - how to listen to changes ?

-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

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

-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] pdf_calc_Export for single sheet possible ?

-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] how can I reference a cell containing text with linebreaks ?

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

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

-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] how can I reference a cell containing text with linebreaks ?

-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] OO-DEV m165 - sometimes the screen is not

-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

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

-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

-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

-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] how to stop cell editing ?

-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

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

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

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

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

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