[sc-dev] Re: oo 3.x: hiding columns in large spreadsheets sometimes very slow
Hi Niklas, > Are there many comments (notes) in the file? Then it might be related to > issue 102716. no, only notes in column headers, but the spreadsheet has ~100 sheets with up to 7500 rows and a lot of vlookup formulas > No, addActionLock for the document doesn't interfere with formula calculation. > It mainly affects the drawing layer. good to know, so it's save to use it :-) Best Regards Oliver -- Oliver Brinzing fon +49 7181 481401 fax +49 7181 475635 Ludwigstrasse 14mobil +49 174 3015743 73614 Schorndorfmailto:oliver.brinz...@gmx.de GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[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 range in my spreadsheet - why ? btw: i could not find a way to hide a couple of ranges with a single api call ... 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 ? any hints ? Regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[sc-dev] dev build with cws/calc69 ?
Hi, is there a change to get a win32 dev-build which includes http://hg.services.openoffice.org/cws/calc69/summary ? Regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[sc-dev] Re: Enumerating over a cell range, howto ?
Hi Rony, > extracted from a calc document and > saved in an array in a programming language for further http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangeData.html maybe getDataArray() can help you to extract the values, for example: oNRanges = ThisComponent.NamedRanges oRange = oNRanges.getByName("Source").getReferredCells mX() = oRange.getDataArray() Regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[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 Description: OpenPGP digital signature
[sc-dev] c.s.s.XDataPilotFieldGrouping - how does createNameGroup() work ?
Hi, 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()) btw: createDateGroup() works fine for me... Regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[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 signature
[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 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 ? regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
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 view to the selected cell, so user don't need to scroll - make validator window resizeable, so formula input field can grow - formulas should be displayed localized - running validator on a sheet with many formulas will took a long time until oo will respond again (oo seems to freeze). could validator run in a different thread ? - if a spreadsheet document is closed, validator will stay visible but seems not to work with another spreadsheet, until the dialog is closed and opened again. Best Regards Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
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 accelerators in calc http://www.openoffice.org/issues/show_bug.cgi?id=110950 regards Oliver GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[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 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 ... Example A Bc Open- 1 office Open-office xxx IMHO "-" in B1 should not be displayed/printed Is it a bug ? Oliver -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] strange formula Err:504 with oo 3.x
Hi Eike, > That's http://qa.openoffice.org/issues/show_bug.cgi?id=96529 and fixed > in OOO300_m13, clone will be integrated to DEV300_m38: > https://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=7697 yep, fixed in m13 :-) thanks Oliver -- 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
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 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
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
[sc-dev] strange formula Err:504 with oo 3.x
Hi, i have a problem with a *.sxc file on import in oo 3.0.1 and 3.x the formula =WENN(ISTNV(SVERWEIS(D9;Feiertage;2;0));"";SVERWEIS(D9;Feiertage;2;0)) will display "Err:504" - same file will open with oo 2.4.2 without any problems ... replacing the named range "Feiertage" with the cell range "$x.$D$230:$E$245" in oo 1.15 before lets oo 3.x import without the error ... =WENN(ISTNV(SVERWEIS(D9;$x.$D$230:$E$245;2;0));"";SVERWEIS(D9;$x.$D$230:$E$245;2;0)) any hints what wrong here ??? Oliver -- 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 excel german keywords for "COORD" and "SHEET" ... Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[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 - Telefonanschluss + DSL für nur 16,37 Euro/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 46D3 352C 1A06 4E2C AB40 CFD0 4A45 signature.asc Description: OpenPGP digital signature
[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 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 !
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: http://www.shortview.de/[EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 * BASIC * OPTION EXPLICIT Sub Main Dim s as String Dim mTmp() as String ' return's always a string as expected ... s = Test(True) MsgBox s ' return's an array of byte's if Test(True) was called before !!! ' this is different from oo 1.1.5 / 2.4.1 mTmp() = Test(False) MsgBox mTmp(0) & " " & mTmp(1) End Sub Function Test(ByVal bFlag as Boolean) as Variant Dim mRanges(100) as String If (bFlag = True) Then Test = "return a String" Else mRanges(0) = "return an" mRanges(1) = "Array" Test = mRanges() EndIf End Function -- 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 !
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] 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, containing the cell ranges ... debugging the program show's that the array contains bytes instead of string. mRanges() shows type: String, mX() shows type Byte ... btw: i can not reproduce the bug with the example below no problems with oo 2.4.1 at all... any hints are welcome Oliver REM * BASIC * OPTION EXPLICIT Sub Main Dim mX() as String mX() = Test() 'after the call mX() sometimes has Byte Values instead of String ! 'for example: mX(0) = "1", mX(0) = "0", ... MsgBox mX(0) & " " & mX(1) End Sub Function Test() as Variant Dim mRanges(100) as String mRanges(0) = "1" mRanges(1) = "$A$1:$B$10" ' mRanges is a String Typ (correct) Test = mRanges() End Function -- 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
[sc-dev] XFrameActionListener - COMPONENT_REATTACHED event has no current sheet ?
Hi, I added a XFrameActionListener to a spreadsheet document. If a user changes for example from "Tabelle3" to the print preview (in german: "Seitenansicht") and back the last frameAction(FrameActionEvent evt) i get is: "COMPONENT_REATTACHED" At this point it seems not to be possible to get the current Controller via xModel.getCurrentController() but i can get a XController using: XController xController = evt.Frame.getController(); BTW: Is this correct ? Now i try to get the active sheet ("Tabelle3"), but it seems not to be possible ... XSpreadsheetView xView = (XSpreadsheetView) UnoRuntime.queryInterface( XSpreadsheetView.class, xController); XSpreadsheet xSheet = xView.getActiveSheet() it seem's xSheet always is the *first* sheet of the spreadsheet document with index 0 (for example: "Tabelle1") and not the above mentioned "Tabelle3" which is actually shown ... What can i do ? 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 > OptionsDialog are global, others not? you are right, IMHO it would make sense to have different colors in the options page for document and global options or a different grouping... what about an issue ? BTW: same confusion if you deal with cell styles - you don't know if a property is explicit set or inherited from a parent style... see you next week ;-) Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHfmsuTiyrQM/QSkURAni7AKCWKycBWKWflOKPAsaWO9E/EHRxnQCfe3Gp u7wpdz8uvOcGJlG2cy2r0no= =ZzuV -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] document freezes for about a minute when switching between sheets...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, > thanks, please fix soon :-) BTW: if oo runs inside a vm, this happen even with smaller docs ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHQx/hTiyrQM/QSkURAuSAAKCUQW/YNtsciXlZ5t0cFPfqjAqUlQCeN3e8 BGSRYCej0UoASrVpCJtuchI= =sHxX -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] document freezes for about a minute when switching between sheets...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, > There's issue 83005 about that. thanks, please fix soon :-) Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHQx0PTiyrQM/QSkURAnADAJ9ufrwTU4hJ+dnMAC/kYQZFWtLLDACZAQjp USRfw1Y6+SBnKWbJvbFuguU= =syVy -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] document freezes for about a minute when switching between sheets...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, i have a big calc document (about 3,50 MB, 100 sheets). If one switches between the sheets (click on the sheet tabs) OO freezes for about a minute. this happens always if one tries to click on a sheet tab but in real starts a drag and drop operation (???), cause he clicks - holds the mouse button down - and moves the mouse to the right (next sheet) this can happen if one wants to switch *fast* between the sheets using a touchpad ... the document and sheets are protected ... any hints ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHQxGHTiyrQM/QSkURAp4nAJ0a2hIlF0WGW6Du0uZW+LF/c98C+wCfZGAm s/EWPNENMwA4tuMPRTpU/J4= =qzLk -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] http://www.downloadsquad.com/2007/09/25/excel-2007-cant-do-math-unless-850-77-1-100-000/
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Excel 2007 can't do math oo can better :-) - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD4DBQFG+mudTiyrQM/QSkURApFKAJ91akhaOXbEilRtc049J9eh29djkQCWJb1D ZkcG8JGA7abcTLj8OOVS/w== =wGfb -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGwFqGTiyrQM/QSkURAtvbAJ9ppr5pq6OmwnkOl0sdqVQqHkuKcgCfb/Ja UW0ufHA3+f5JVwb0/9BXLvU= =JDYz -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] XActivationBroadcaster - crash after switching from printPreview back to sheet ...
-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- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGuJrvTiyrQM/QSkURAvHlAKC8bqUyxY5YVSgYoJZvXwUuxgCLUQCgshGQ fEG7lJR+fx9hnx+xk1qJGGE= =roXY -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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 .queryInterface(XActivationBroadcaster.class, xController); xActivation.addActivationEventListener(this); everything works fine, but if i change to the print preview *and* back to the sheet, oo crashes ... this does not happen, if i add a XSelectionChangeListener to listen for sheet changes ... i am using oo 2.2.1 (vista) any hints ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGtbeOTiyrQM/QSkURAv0EAJ0VzLgDxv45Gxc0q9GDjg3jKLJ86ACgp6Do ArAQmlZ1tkEpVWz/rCpbu54= =wclq -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 filter options for the NamedRanges,for example: - - filter all ranges defined on a sheet - - filter named ranges, e.g. with startsWith() ... - - filter case sensitive BTW: This could work for Label/Datbase Ranges too ... What do you think about it ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqhuSTiyrQM/QSkURAieCAKCw1nmq0uzHH5Q49Eq3FxH914ufIwCgvmRh TLcoPsDtJbh1DXcIr5WDGdk= =jqq6 -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqhmWTiyrQM/QSkURAlq8AJ9izto6lD4T0qSQNI0lzPO+ZRXW2gCeLsAG VTr+ZKh8r+BmU6lNtLpAHz8= =CoeQ -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqNfcTiyrQM/QSkURAk8kAJ92kdrypjhaJj4uB0Qq6w7FFqdPrQCfWbD2 vvv7Y5trZo9R18Wvm1L4EYQ= =jhRl -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqNc4TiyrQM/QSkURAghZAJ9RTAwkdQ8cUQsSzD+DAfPZvKQkewCglPBg iZfp2gUpsbLTThm5Hg7KMg0= =HMB7 -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 wrote: >>> I posted some time back a feature-request to implement a special >>> spreadsheet-view in which rows get *highlighted* (see >>> http://www.openoffice.org/issues/show_bug.cgi?id=78181). >>> >>> Virtually every table on the net is displayed this way. Also, most web >>> applications have implemented it (see e.g. phpMyAdmin for one, but there >>> are countless others). The code for the net applications is a mere >>> 20-line java-script (I used it, too). >>> >>> Would it be possible to implement this in Calc? >> Actually exchanging a highlight color for the cell background would >> require changes to the output (rendering) code. Instead, current fashion >> calls for an overlay object, which could highlight the row by painting a >> transparent color over it. > > Along the same line, I would also like to see the possibility of > overlaying (or underlaying) a background image to enhance the visual > effect of Calc's (rather boring) sheet. Note that such background image > is not printable, so it's only for display. And it wouldn't scroll with > the sheet; it stays at the fixed position, or may be aligned with the > frame so that it moves when the app's frame gets resized. > > I think this would be a nice PR feature, don't ya think ? ;-) > > http://idea.opensuse.org/content/ideas/oo.o-calc-with-background-sheet-picture > > Kohei > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGjj8uTiyrQM/QSkURAoApAKCi71tonOcEl3myk2Dgl9mQxbQrzgCaA1ML tI++QoZwg0SuaxbZ96oXJQQ= =niUJ -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] remove user-defined numberformats from spreadsheet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, > Usually, what you remove is gone. You must be doing something special. seems to be true, but i have some files, where the styles still remain in the styles.xml, and don't know why :-( http://www.openoffice.org/issues/show_bug.cgi?id=75045 Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF6BHvTiyrQM/QSkURAnTnAKCqo5+Bgi5akevcJmHv74brWKiI8QCdEb+N OY3HTV3woMx7faVB6+IEfFQ= =mkiD -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] remove user-defined numberformats from spreadsheet
Hi, is it possible to completly remove user defined numberformats from a spreadsheet document ? I used removeByKey() to do so, but it seems, the formats still writen to the xml file (even if the are not longer shown in the dialog ...) Oliver -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] performance problem ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Eike, > If all or most SVERWEIS/VLOOKUP formulas reference the range > Code.$B$4:$F$3492 then this may be due to a broadcaster performance > problem that comes into play when too many formulas listen on identical > portions of ranges. You may try to rearrange things such that those many > identical references aren't needed. this could be true, cause on another cell range (with about 15.000 cells), i replaced all formulas (written in oo basic) through a vlookup formula ... but this lead to a performance desaster ... another two performance question: is it better: - - to use NamedRanges instead of direct cell addressing inside formulas ? CODERANGE = Code.$B$4:$F$3492 =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;CODERANGE;2;0)) - - to split calculations, e.g. from =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E7;Code.$B$4:$F$3492;4;0)) to F6 =ODER(ISTLEER(E6);E6="") =WENN(ISTWAHR(F6);"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) =WENN(ISTWAHR(F6);"";SVERWEIS(E7;Code.$B$4:$F$3492;4;0)) i noticed that this will increase the file size ... thanks Oliver GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF2c/ITiyrQM/QSkURAnCAAKCYHDkkkrNzwZAqwQ2f9MjpXuT/vwCeIYOa Hjn286zE8tN2jnM6Q9NjsKI= =SpgX -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] performance problem ...
Hi, if have a performance problem with a spreadsheet document. The document has about 100 sheets and about 50.000 SVerweis() formulas as =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) =WENN(ODER(ISTLEER(E7);E7="");"";SVERWEIS(E7;Code.$B$4:$F$3492;2;0)) ... If one enters a value in a cell of the code range, it takes about a minute on a 3 GHZ XP machine with 1 GB RAM to recalc ... My Question: Is there an analysis tool, where i can find the formulas which are involved during the recalc operation ? If have the feeleing, that the SVerweis() formulas are recalulated even if the result of the abouve =IF() statement is TRUE (-> "") ... Any hints how to speed up such large documents ? Oliver -- "Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: www.gmx.net/de/go/mailfooter/topmail-out - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] accessing cipher api for sheet/document protection possible ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, is it possible to access the cipher api for en-/decrypting calc password protected sheets/documents ? scenario: Some people have to enter data into a spreadsheet document. But only one of them is allowed to run a macro to do some calculations and get a report. I am thinking about adding a button on a sheet inside the document. After pressing the button, the user has to enter as password before the calculations/report will run ... I want to save the password inside the the basic macro encrypted, like we have it in the above mentioned sheet/document protection ... I know that this is not a real protection, cause a user could change the macro :-) any hints ? or even a better solution ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFNmi7TiyrQM/QSkURAojeAJ9/O7fVFnNrTuoojT3JhG7Y/6mauQCgn4jM pmLSqNk/cgOyLofCCqsCx5A= =pwtJ -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] pdf_calc_Export for single sheet possible ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, thanks, that is what i was looking for :-) > "Selection" only works with a single sheet (or cell range). To export > several sheets, you should set up print areas. REM * BASIC * Sub PDFExport() On Local Error Goto ErrorHandler Dim oDocument as Object Dim oSheet as Object Dim exportPath as String Dim i as Integer Dim mArgs(4) as new com.sun.star.beans.PropertyValue Dim mFilterData(1) as new com.sun.star.beans.PropertyValue exportPath = "E:\" mArgs(0).Name = "FilterName" mArgs(0).Value = "calc_pdf_Export" mArgs(1).Name = "Overwrite" mArgs(1).Value = True oDocument = ThisComponent For i = 0 To oDocument.getSheets().getCount()-1 oSheet = oDocument.getSheets().getByIndex(i) mFilterData(0).Name = "Selection" mFilterData(0).Value = oSheet mArgs(2).Name = "FilterData" mArgs(2).Value = mFilterData() oDocument.storeToURL(ConvertToURL(exportPath & oSheet.getName()) & ".pdf", mArgs()) Next i Exit Sub ErrorHandler: MsgBox("Error: " & Err() & Chr(13) & "Line: " & Erl() & Chr(13) & Error(), 1+16, "Error...") End Sub Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFFBkUTiyrQM/QSkURAucnAKCo543RMWtATNaSHVMmB+NKrbkd4ACggCw+ U+TJymIF+3SOQEIhUEsRyi0= =9SnV -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] pdf_calc_Export for single sheet possible ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Stefan, > (1) File | Export to PDF... > (2) Give file name and destination > (3) Klick "Save" > (4) Choose Range|Selection uups, i forgot to mention, that i was looking for a starbasic script ... but this one seems not to work: Sub PDFExport() On Local Error Goto ErrorHandler Dim oDocument as Object Dim exportPath as String Dim i as Integer Dim mArgs(4) as new com.sun.star.beans.PropertyValue exportPath = "E:\" mArgs(0).Name = "FilterName" mArgs(0).Value = "calc_pdf_Export" mArgs(1).Name = "Overwrite" mArgs(1).Value = True mArgs(2).Name = "SelectionOnly" mArgs(2).Value = True oDocument = ThisComponent For i = 0 To oDocument.getSheets().getCount()-1 oDocument.storeToURL(ConvertToURL(exportPath & oDocument.getSheets().getByIndex(i).getName()) & ".pdf", mArgs()) Next i Exit Sub ErrorHandler: MsgBox("Fehler: " & Err() & Chr(13) & "Zeile: " & Erl() & Chr(13) & Error(), 1+16, "Fehler beim Export") End Sub I am looking for something like: mArgs(2).Name = "Sheets" mArgs(2).Value = "1,2,5-7" Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFEsJqTiyrQM/QSkURAuFmAJ0UrmNUnzGg2Qddt6WBYBbQXW+V7ACfa638 qp21lWK+lZj7JX9e/eoJdLE= =MyAw -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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 http://qa.openoffice.org/issues/show_bug.cgi?id=10658 here ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFErZ6TiyrQM/QSkURAkobAJ9q5N/5Tj1mn586xJFJe7DJA+c49QCeNRB3 0GNh47dA/N997MFyZjCfcew= =QMD5 -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 data, the user selects the address data using an java addon, the addon itself gets the data from an external database for some forms we have to print special drafts, so we have to copy the address data into the draft (e.g. another sheet in the calc document) ... the easiest way to do so, would be, simply to reference the address data field (the user would even be able to edit the address data) we don't want to split the address data into single lines, cause we get one string (containing paragraphs) from the database, and we put the same string into address frames in writer documents too ... at the moment i am thinking about writing my first calc addin to solve the problem :-) Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEnC8HTiyrQM/QSkURAlm8AJ9UY3tIg08wwwl3hpVWyXeju3/WJQCfRmPc 1EewWw82zJCW52a+UdkCkF0= =bOuI -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 = ThisComponent.getCurrentController().getActiveSheet().getCellRangeByName("A1").getString() msgbox asc(mid(s,6,1)) ' result: 10 -> ok End Sub but if one uses a formula =CODE(TEIL(A1;6;1)) the result is 32 ... :-( so i cannot use formulas to split the string and put every part in a own cell ... in excel the code() formula returns 10 and i can format the result cell to show the linebreak ... regards Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEnCADTiyrQM/QSkURArlIAJwNOhJNM9DOiD7AuM0XVvrPz9H2dACgvelQ i/SpAeNT9s1x79N6q9zmElw= =2QER -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEm/3wTiyrQM/QSkURAg7SAKCfRSofr+7IkzHd0jmlUtVq7fMbcACfbuhf KSykZbJ9Vt22W70SbBhqcRk= =+CAJ -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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) !!! In excel it is possible to get the correct result if you format B1 with the linebreak option this also affects import/export ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEmjYOTiyrQM/QSkURAgf7AJ4ueCp0Tns7PcWzlcwSa7nJ7YGb/wCfXIQy Fk4D4T6BUQYxGGaspvIzjbI= =hE3B -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEYM3ITiyrQM/QSkURArcYAKCJ8WyrxEZA24u5KkeJNOsZyhioOwCgjWBT j4AZVTAIGsqklVBGd/33OhM= =vR5n -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 force a redraw using the api ? > You can use the Dispatch API and ".uno:Repaint". ah, good to know, but are there any plans for an api ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEW4EaTiyrQM/QSkURAseGAJ9cgY5sDBQcBYqZ9TDfnRI/sioQngCfZdER 3msxNQ2GwwnWM25dYlFJD/Q= =9sOx -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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 (http://www.openoffice.org/issues/show_bug.cgi?id=33728), but was fixed in oo 2.0. Some month ago there was a new display problem, using frozen panes on a sheet (http://www.openoffice.org/issues/show_bug.cgi?id=62450) Now after the change via listbox *sometimes* the display is not correct, i have some white rectangles on screen. Has something changed between m162 and m165 ? Is it possible to force a redraw using the api ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEW1b1TiyrQM/QSkURAjslAKC5A4Mx7IciNxd5KhzMw2nUPG3dKACfeaB5 qt3+bmTfNbAv7xCvAP94hK8= =+xGF -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 would prefer the method names without "Cell" ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEW1LUTiyrQM/QSkURAptwAJ4/95Ke7Lb6xycmnq8kfu4DW1/GPACeIk96 47H+ErqmTgDIaK41G3QbpP0= =9pwV -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 think it's just a workaround ... what about an interface with the following methods isCellEditable() isEditing() startCellEditing() stopCellEditing() cancelEditing() Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEWispTiyrQM/QSkURAg5TAKCkPt5NuvTtZh58GqS0GPE0nsBSbACfQI1K PGXGraPRGymIGwBOlxssP0E= =nuUT -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] how to stop cell editing ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, maybe i am blind, but i am looking for a simple way to stop the cell editing, if a user presses a control element (for example an ok button) background: the users has to insert values into some spreadsheet cells. after that he has to press a button to do some calculation ... many users enter the last value and do not use (return), so the input mode is still active, and the last value is not written into the cell instead they just press the ok button ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEUlNoTiyrQM/QSkURAsTcAJ95Qzm9u3uVHWXhg4quNzKVk06p3wCffZOd c7TmxIyax7ik5Bc5fbHfwFw= =+3lf -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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, that is true, but what about a simple warning if a sheet is protected ? We have a configurable warning for pasting data: "Show overwrite warning when pasting data" Another posibility might be a special (pw protected) "user" mode, where a user can only insert/delete values in non protected input cells ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFESG+JTiyrQM/QSkURAkUIAJ9OsrHLdXHOFVEhzA7Hhlaf4QHxvACggu5+ rwJXg0M18lKwXm2KTcjlKaw= =6uFf -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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 formulas. Now the user uses cut (strg x) on a non protected cell and paste the content via (strg v) into another non protected cell ... This will change the referenced cells of the formulas and the formular results are wrong ... This is a general problem and seems to affect all documents... Would'nt it make sense to disable "cut" on password protected sheets ? For example, a message is displayed if one tries to change a protected cell: "Protected cells can not be modified" and it's not possible to change a cellstyle if one sheet of the document is protected ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFER466TiyrQM/QSkURAkQ+AKCKi10XdJ4XP4wPe4YvK9kyg1+ZYACeL3fF GE6pjrv8OoahUn+X52fvSyo= =h7V3 -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] XCellRangeMovement - copyRange() does not work if destination range has merged cells
-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 ... - --8<--- oDstRange = oSheet.getCellRangeByPosition(oDstCell.Column, oDstCell.Row,_ oDstCell.Column + oSrcRange.EndColumn - oSrcRange.StartColumn,_ oDstCell.Row + oSrcRange.EndRow - oSrcRange.StartRow) If oDstRange.getIsMerged() = True Then oDstRange.merge(False) EndIf oSheet.copyRange(oDstCell, oSrcRange) - -->8--- but it is a little bit unfortune, that the method has no return code (void), does not throw an exception, and the idl reference tells nothing about this problem ... regards Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFDvoUdTiyrQM/QSkURAuttAKC+hmnIhoPtvecKWntKNkb1uTO8PQCfdzuZ MwgO2BwIy8OyfOKQoDKQauw= =EsjA -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] oo 2.0.1 file format: removed ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, is it possible that the oo2.01. xml file is different from so 8.0 ? My XPATH expressions do not work with oo 2.0.1 files ... oo2.0.1: Hello World so 8.0: Hello World it seems, the has been removed, T1 was: is it a change or is it my fault, mybe i used a different cell formatting ? merry x-mas Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFDq+lvTiyrQM/QSkURAhnqAKCQ2BCL3MScHZZsLIq/c8dwuh6EqwCfVXzJ xmbzUZmW4MCDxsRvf0MqelU= =JdOR -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] oo 1.1.5: inserting form control via script - can't print until save & reload
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, > Form controls have to be on a special layer. This is still true for 2.0, > even if printing happens to work otherwise. This should probably be > enforced somewhere in the API implementation, but it isn't. So you > should add a line like > oControlShape.LayerName = "Controls" > and everything will be fine. thanks a lot, you really saved my day :-) Frank wrote: >This sounds like a problem with inserting shapes into Calc. If the same >code works (aka: prints the control) in other applications, please submit an >issue for Calc. this seems not to happen in writer (oo1.1.5) ... no problems in writer/calc with oo 2.0 so should i submit an issue for this ? regards Oliver -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDaknqTiyrQM/QSkURAhPDAJ9TXOluALVKmbK8JQHeHStWUtGiPQCfbZYq W4dtCTH1+98Ly8Gj3qyX53A= =KKdi -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[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 should have a bugfix for this ... regards Oliver -- Option Explicit Sub CreateControl() Dim oDocument as Object Dim oView as Object Dim oDrawPage as Object Dim oControlModel as Object Dim oControlShape as Object Dim oSize as New com.sun.star.awt.Size Dim oPosition as New com.sun.star.awt.Point oDocument = StarDesktop.getCurrentComponent oView = oDocument.CurrentController oDrawPage = oView.getActiveSheet.DrawPage oControlShape = oDocument.createInstance("com.sun.star.drawing.ControlShape") oSize.Height = 1000 oSize.Width = 3000 oPosition.X = 2000 oPosition.Y = 3000 oControlShape.setSize(oSize) oControlShape.SizeProtect = True oControlShape.setPosition(oPosition) oControlShape.MoveProtect = True oControlModel = createUNOService("com.sun.star.form.component.CommandButton") oControlModel.Name = "My Control" oControlModel.Label = "Test" oControlModel.Printable = True oControlModel.Enabled = True oControlShape.setControl(oControlModel) oDrawPage.add(oControlShape) End Sub -- Highspeed-Freiheit. Bei GMX supergünstig, z.B. GMX DSL_Cityflat, DSL-Flatrate für nur 4,99 Euro/Monat* http://www.gmx.net/de/go/dsl - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]