Re: [sc-dev] Issue 83783
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 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 appears in MS Office, not in OpenOffice. Displaying the icons in OO documents will touch the document format and Oasis must accept this, won't it? Regards Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 83783
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 appears in MS Office, not in OpenOffice. No, I'm talking about OOo of course. It has to be compiled with OLE support, but the downloads from the website are compiled that way. I always use that downloads for ages, but never got this system dialog, only the oo-OLE-Dialog. And yes, Tools/Options/%productname%/General/Use OpenOffice.org dialogs is unchecked. Regards Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 83783
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, not part of OOo. It has a check box Display As Icon. Ah, yes. But this system dialog only appears in MS Office, not in OpenOffice. No, I'm talking about OOo of course. It has to be compiled with OLE support, but the downloads from the website are compiled that way. I always use that downloads for ages, but never got this system dialog, only the oo-OLE-Dialog. And yes, Tools/Options/%productname%/General/Use OpenOffice.org dialogs is unchecked. What do you get if you select Further objects in the Insert OLE Object dialog? Sorry for wasting your time, Niklas. Always looked at Create from file and not Create new because I wanted to insert an *existing file*. Sorry again, Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Issue 83783
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 for all applications. 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 ? Regards Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Dispatching AutoComplete for cell values
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 for that. Shouldn't this service contain a property ViewValueHighlighting too? Here I need the dispatch stuff. These differences are sometimes not clear. Regards Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] View Settings was: Dispatching AutoComplete for cell values
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. Tried in m84 the property ShowCharts=2 without success. ( http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/View_Settings ) Is this documented, but not implemented? Regards Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] XChartDataChangeListener and inserting rows
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 - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] Drawing layer: comments and AWT controls
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 target? Thanks Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] XViewFreezable
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: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Conditional Formatting with newly inserted cellstyle (Java)
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 exists yet, it is visible via GUI. Nevertheless the entry in Format/Conditional Formatting.. is correct. How can I force an update of the style? Are you sure the style contains any format attributes? Remember you have to insert a new style before setting format properties (generally for cell styles, not only for conditional formatting). That's the point, after correcting this, all works fine. Thanks Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Data - Refresh range - deletes formatting
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? Individual cell formats are always removed, because we don't know if the same data row ends up in a cell. But if you set the Keep formatting flag at the database range, formats from the first data row will be extended to the other rows on refreshing. Works fine as much as the autofilter property does, nice feature. Peter - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] ValueHighlighting
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 -- WindowsXP, OpenOffice 2.2 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] interface com.sun.star.util.XSortable, restrictions
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 unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] interface com.sun.star.util.XSortable, restrictions
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. is there an issue about that? At least a note in the DevGuide would be useful. By contrast the FilterDescriptor hasn't the limitation the UI has. Regards Peter - 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 ?
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 *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 This is a known issue (30781), Peter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]