[dev] Re: macros emulation poor man's database

Interesting questions so I copied them back to the Dev list I am adding answers in-line. Uwe Brauer wrote: Hello The OO database is unfortunately no as comfortable as the scalc. Do you know about a macro which could do protect rows in a scalc document against partial sorting. Original ta

[dev] toolbar context menu

Hi Can someone please help with a macro problems in OpenOffice.org 1.1.4 under Linux. I'm tried asking for answer on the forums, but to no avail. The Problem. I need to provide to controlled locked down openoffice environment for my users. To do this i've hidden the menubar, created a custom

Re: [dev] setting OptimalWidth in TextTable with UNO

Hi Florian, From the "Useful Macro Information For OpenOffice" By Andrew Pitonyak It's in Office Basic, but you can translate that to C++. = 7.22.2 Setting the optimal column width My book, OpenOffice.org Macros Explained, discusses text

Re: [dev] setting OptimalWidth in TextTable with UNO

Hi, So is there another way to set the "OptimalWidth" property programmatically ? cheers Flo Joachim Lingner wrote: Hi, The API does not support columns. As I was told, the tables are organized in rows and cells. That would explain, why the Any.Value cannot be casted to a XPropertySet, b

Re: [dev] Saving document creates a lot of network traffic

Saku Seppälä wrote: Hi again, I just did some testing and found out that it is the hyperlinks that make saving my 109Kb .odt document to a network drive cause 33,8 Mb of network traffic. It appears that when OO is parsing the document for saving, each hyperlink it comes across causes it to go op

[dev] How to open Data Source Browser

I'd like to open the DSB from a script. However, all code I could find (including the code created by recording a macro for the "F4" key) toggles it between on and off. But I want to turn it on unconditionally, i.e. if it is already open it should STAY open and not close again. Thanks for your hel

[dev] Toolbar context menu

Hi Can anyone tell me how to disable or capture the event of the context menu on the toolbar. I've created a custom toolbar and de-selected all standard toolbars, however, if a user right clicks on my toolbar they get a context menu that allows them to re-select standard toolbars, de-select

[dev] cannot drop view in ooo (mysql-odbc)

hi folks! i didnt want to register for bugzilla, so i post here. if this is already known, then please ignore this mail (i checked bugzilla, but havent found a bug for this) i found an error with OOo 1.9.113 MyODBC-3.51.11-2-win mysql-5.0.7-beta-win32 i CAN create a table and i CAN create a vie

Re: [dev] setting OptimalWidth in TextTable with UNO

Hi, The API does not support columns. As I was told, the tables are organized in rows and cells. That would explain, why the Any.Value cannot be casted to a XPropertySet, because it is not implemented. This does not work in Java either. So the Developer's Guide is right, saying that getByInd

[dev] Can 2.0 use response files?

Please excuse the cross postiing. I am not certain which team can answer. Now my question. Since installing 1.1.x with response files is and was an option, the use of native installers with 2.0 appears to preclude this option/ Is it still available? If not then what option(s) is available to dupli

Re: [dev] setting OptimalWidth in TextTable with UNO

Hi! > Have you checked the type within the Any: > > Type t = Any.Type; -- System.Type type = cols.getByIndex(i).Type; Console.WriteLine(type.ToString()); -- Yields: System.Object OOo2 did not install anything into the assembly cache on my pc. So I'm using the assemblies in the ./OpenOffice.or

Re: [dev] basic macro to uno package

Hi, the best way is to define your Basic macro in a new Basic library. Once you have Basic library you can simple put these library in a UNO package and the last thing is to define the package descriptor. descriptor should look like name: META-INF\manifest.xml 1.0//EN" "Manifest.dtd"> http

Re: [dev] Saving document creates a lot of network traffic

Hi again, I just did some testing and found out that it is the hyperlinks that make saving my 109Kb .odt document to a network drive cause 33,8 Mb of network traffic. It appears that when OO is parsing the document for saving, each hyperlink it comes across causes it to go open and close the fold

Re: [dev] setting OptimalWidth in TextTable with UNO

Have you checked the type within the Any: Type t = Any.Type; If it is XPropertySet type, then there seems to be bug. Could you then provide a stripped down (but still buildable) example that lets me reproduce this problem? BTW, I assume you are NOT using the assemblies which were once provid