[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] 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] #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, 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
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
[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
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 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] 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]
[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] 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]
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]
[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]
[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]
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]
[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 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]
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 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]
[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] 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]
[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] 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]
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] 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]
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] 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]