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

2006-06-22 Thread Peter Eberlein
Hi Oliver, Oliver Brinzing schrieb: -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

[sc-dev] interface com.sun.star.util.XSortable, restrictions

2006-09-29 Thread Peter Eberlein
Hi, is the method sort on a xRange restricted to max 3 columns (as in the GUI)? If I specify 6 TableSortFields and run the method, it seems, that MaxFieldCount is always 3 and a readOnly property. Regards Peter - To

Re: [sc-dev] interface com.sun.star.util.XSortable, restrictions

2006-09-29 Thread Peter Eberlein
Hi Niklas, Niklas Nebel schrieb: Peter Eberlein wrote: is the method sort on a xRange restricted to max 3 columns (as in the GUI)? If I specify 6 TableSortFields and run the method, it seems, that MaxFieldCount is always 3 and a readOnly property. Yes, it's the same limitation

[sc-dev] ValueHighlighting

2008-01-04 Thread Peter Eberlein
Hi, IIRC in a former StarOffice version ValueHighlighting was stored with the document. Are there any reasons to put this only into calc.xcu and not in the settings.xml? Isn't it confusing for the user that some properties of the OptionsDialog are global, others not? Regards Peter --

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

2010-01-20 Thread Peter Eberlein
Am 20.01.2010 13:01, schrieb Niklas Nebel: On 01/20/10 12:35, Peter Eberlein wrote: I've linked a range against a registered datasource/table and did some formatting (e.g. wrap text automatically). After refreshing the range all formatting is set to default. Is this behavior intended

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

2010-06-09 Thread Peter Eberlein
Hi Niklas, Niklas Nebel schrieb: On 06/08/10 16:37, Peter Eberlein wrote: after inserting a new cellstyle I cleared all conditional format entries and inserted a new one with the new cellstyle. It seems, the new conditional format doesn't reflect the new style in the sheet. Only if the style

[sc-dev] XViewFreezable

2010-06-28 Thread Peter Eberlein
Hi, just stumbled over the 7 years old issue http://www.openoffice.org/issues/show_bug.cgi?id=19896 Is there a way to remove the freezing using the dispatch API? Regards Peter - To unsubscribe, e-mail:

[sc-dev] Drawing layer: comments and AWT controls

2010-07-01 Thread Peter Eberlein
Hi, even if uno awt control are set to background in a sheet, comments are neither really readable with mouse hover nor with setting permanently visible. They are behind the controls. Found http://qa.openoffice.org/issues/show_bug.cgi?id=108293 for that. Can somebody confirm and set a

[sc-dev] XChartDataChangeListener and inserting rows

2010-09-20 Thread Peter Eberlein
Hi, if the subject listener is implemented on a sheet, a ChartDataChangeEvent is fired, when nonempty rows are deleted. It is not fired when a row has been inserted. Which listener should be implemented to catch such a user action? Regards Peter

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

2010-10-28 Thread Peter Eberlein
Hi Niklas, Am 27.10.2010 19:52, schrieb Niklas Nebel: On 10/27/10 16:30, Peter Eberlein wrote: how can I turn AutoComplete off? Service com.sun.star.sheet.GlobalSheetSettings has a property DoAutoComplete. It can be read and modified, so you don't need the dispatch stuff

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

2010-10-28 Thread Peter Eberlein
Hi Niklas, Am 28.10.2010 11:02, schrieb Niklas Nebel: Value highlighting is a view setting that can be enabled for each view individually. It's the property IsValueHighlightingEnabled in service SpreadsheetViewSettings, part of SpreadsheetView. Thanks (as always) for your fast responses.

Re: [sc-dev] Issue 83783

2010-11-01 Thread Peter Eberlein
Am 29.10.2010 19:09, schrieb Niklas Nebel: On 10/28/10 16:11, Peter Eberlein wrote: can someone of the spreadsheet team confirm http://qa.openoffice.org/issues/show_bug.cgi?id=83783 ? The issue is assigned (ul) and has a target, but status unconfirmed. BTW, I consider this a framework issue

Re: [sc-dev] Issue 83783

2010-11-02 Thread Peter Eberlein
Hi Niklas, Am 01.11.2010 16:26, schrieb Niklas Nebel: On 11/01/10 08:34, Peter Eberlein wrote: Are you sure Display As Icon in the system dialog (Further objects) isn't what you're looking for? Sorry, maybe I overlooked something :-\ , but what do you mean with system dialog ? The dialog

Re: [sc-dev] Issue 83783

2010-11-02 Thread Peter Eberlein
Am 02.11.2010 10:00, schrieb Niklas Nebel: On 11/02/10 08:58, Peter Eberlein wrote: The dialog you get on Windows if you select Insert/Object/OLE Object, and then Further objects. That's an OLE dialog, not part of OOo. It has a check box Display As Icon. Ah, yes. But this system dialog only

Re: [sc-dev] Issue 83783

2010-11-02 Thread Peter Eberlein
Am 02.11.2010 10:47, schrieb Niklas Nebel: On 11/02/10 10:31, Peter Eberlein wrote: Am 02.11.2010 10:00, schrieb Niklas Nebel: On 11/02/10 08:58, Peter Eberlein wrote: The dialog you get on Windows if you select Insert/Object/OLE Object, and then Further objects. That's an OLE dialog