Re: [dev] Removing the ability to write data into ODB files

[Matthias B.]

On 2/14/07, Frank Schönheit - Sun Microsystems Germany
<[EMAIL PROTECTED]> wrote:

Hi Matthias,

> For policy reasons we want to prevent users from storing data directly
> inside ODB files. But we want to retain all of OpenOffice.org features
> for other database types that use external storage. Does anyone have
> an idea how we can achieve this?

Try removing the hsqldb2.dll (resp. libhsqldb2.so) library from the
installation. This is the driver which implements the embedded database.


Okay. That's a piece of information I've been missing. I checked the
Dev Guide but didn't find HSQL listed in the table of drivers and
since the table is prefixed with "Below is a list of all available
drivers." I concluded that storing data directly in ODB files is
special functionality implemented outside of the standard driver
framework. I think I'll file an issue for that omission.


The cleaner solution would be to de-register this driver at the global
service manager. This is needed once, and should be possible with a
Basic macro, but I don't have any code at hand.


The following code will do it
-
Dim oPathSubst as Object
oPathSubst = createUnoService( "com.sun.star.util.PathSubstitution" )
Dim sRegistryLocation As String
sRegistryLocation = oPathSubst.substituteVariables( _
"$(prog)/services.rdb", true )
Dim oRegistry as Object
oRegistry = createUnoService( "com.sun.star.registry.SimpleRegistry" )
oRegistry.open( sRegistryLocation, false, false )
Dim oKey as Object
oKey = oRegistry.getRootKey()
oKey.deleteKey("/IMPLEMENTATIONS/com.sun.star.sdbcx.comp.hsqldb.Driver")
oRegistry.close()
--

However, after executing this code, regview services.rdb still lists
hsql in the instances listed below in the SERVICES subtree. So the
removal is not complete, which I assume will have unwanted side
effects. What do I have to do to get rid of these entries, too?

/ com.sun.star.sdbc.Driver
Value: Type = RG_VALUETYPE_STRINGLIST
   Size = 416
   Len  = 10
   Data = 0 = "com.sun.star.comp.sdbc.calc.ODriver"
  1 = "com.sun.star.comp.sdbc.ODBCDriver"
  2 = "org.openoffice.comp.drivers.MySQL.Driver"
  3 = "com.sun.star.comp.sdbc.MozabDriver"
  4 = "com.sun.star.sdbcx.comp.hsqldb.Driver"
  5 = "com.sun.star.comp.sdbc.JDBCDriver"
  6 = "com.sun.star.comp.sdbc.flat.ODriver"
  7 = "com.sun.star.comp.sdbc.evoab.OEvoabDriver"
  8 = "com.sun.star.comp.sdbc.dbase.ODriver"
  9 = "com.sun.star.comp.sdbcx.adabas.ODriver"

/ com.sun.star.sdbcx.Driver
Value: Type = RG_VALUETYPE_STRINGLIST
   Size = 301
   Len  = 7
   Data = 0 = "com.sun.star.comp.sdbc.calc.ODriver"
  1 = "org.openoffice.comp.drivers.MySQL.Driver"
  2 = "com.sun.star.sdbcx.comp.hsqldb.Driver"
  3 = "com.sun.star.comp.sdbc.flat.ODriver"
  4 = "com.sun.star.comp.sdbc.evoab.OEvoabDriver"
  5 = "com.sun.star.comp.sdbc.dbase.ODriver"
  6 = "com.sun.star.comp.sdbcx.adabas.ODriver"

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] How to build openoffice.org-debian-menus?

[Matthias B.]

On 2/9/07, Rene Engelhard <[EMAIL PROTECTED]> wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Matthias B. wrote:
> When I build OOo I get the debs for OOo itself, but
> openoffice.org-debian-menus is not built. How do I get this to be
> built? Calling dmake in sysui/desktop/debian doesn't work.

It is only built with the right options set.

That's why I need to do the following in debian/rules for the official
Debian package (we base on -debian-menus' contents)

# DPKG is only set on with-EPM build what we don't do and the menu 
stuff# is only built wenn DPKG is set.. Same with PKGFORMAT.
cd $(SOURCE_TREE)/sysui; \
. $(CURDIR)/$(SOURCE_TREE)/*.sh; \
PATH=$(BUILD_PATH) DPKG="dpkg" PKGFORMAT="deb" 
NO_PKG_MANGLE=go-away \
../solenv/bin/build.pl && ../solenv/bin/deliver.pl

Unless you build on Debian (and build with EPM) DPKG is not set and
PKGFORMAT does most probably not contain deb either. Set them and it should
work when you run "build" in sysui.


Well, since I build on Debian I thought package format "native" would
be the same as "deb" (since deb is the native format for Debian) and
in fact the "native" build does produce Debian packages for everything
but the ooo-debian-menus. However, passing --with-package-format=deb
fixed my problem. Now debian-menus.deb is built alongside the other
debs. I don't even need to set DPKG or to manually call build.pl.
Thanks for pointing me in the right direction, though.

Matthias

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] Removing the ability to write data into ODB files

[Frank Schönheit - Sun Microsystems Germa ny]

Hi Matthias,

> For policy reasons we want to prevent users from storing data directly
> inside ODB files. But we want to retain all of OpenOffice.org features
> for other database types that use external storage. Does anyone have
> an idea how we can achieve this?

Try removing the hsqldb2.dll (resp. libhsqldb2.so) library from the
installation. This is the driver which implements the embedded database.

The cleaner solution would be to de-register this driver at the global
service manager. This is needed once, and should be possible with a
Basic macro, but I don't have any code at hand.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [dev] File | Open draft specification

[Allen Pulsifer]

Hello Ciao,

Thank you for your comments.

With regard to this specific point:

> > - The default file type depends on the current application.  For 
> > example, from Writer, File | Open by default displays only Text 
> > documents.  The other types, including "All Files (*.*) can 
> still be 
> > chosen from the File Type drop down list.
> > 
> > Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=67163
> 
> There are strong arguments against it. It would be hard for 
> the user to 
> open a text document while working with a spreadsheet, for 
> instance.

Actually, it would be very easy to open a text document when working with a
spreadsheet.  Select File | Open.  The File Chooser dialog will appear.  For
"File Type", select either "Text documents" or "All Files (*.*)".  Locate
the text document you want to open and click "Open".  That's it.

This is just one more step than the current workflow (you have to explicitly
select the File Type), but it corresponds better with the expectations of
new users.

I don't think it is worth the complexity to make this configurable, but if
others believe it is, then I would not oppose it.

Thanks,

Allen

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] File | Open draft specification

[Caio Tiago Oliveira]

Allen Pulsifer, 13-02-2007 14:44:

I was asked to propose a spec for File | Open, more specifically, for how it
handles file types.

The first draft is at
http://wiki.services.openoffice.org/wiki/File_Chooser_Type_Handling_Specific
ation


Since it's highly requested, it's good to discuss. Thank you for the draft.


Some of the changes from OOo's current behavior:

- The default file type depends on the current application.  For example,
from Writer, File | Open by default displays only Text documents.  The other
types, including "All Files (*.*) can still be chosen from the File Type
drop down list.

Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=67163


There are strong arguments against it. It would be hard for the user to 
open a text document while working with a spreadsheet, for instance. Off 
course this would be valid to be added as a user preference (not enabled 
by default).


Another idea would to use a checkbox or another thing to make easier to 
select only files of that app. I.e., it could be easier (more visible) 
to select to only list formula documents while working with formulas 
(although the default still to list all documents).


To hide well known unsupported file types by default could be a option 
(such as PDF).



- If an type group such as "Spreadsheets" is chosen, OOo will either open
the file in Calc or will fail.  It will not for example open a file as a
Text document when Spreadsheets is selected.

Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=74277


It shouldn't fail... it should open the dialog of CSV import.
The current behaviour is bad.
If you select "Text CSV" it will import to spreadsheet, if you select 
"Spreadsheet" it should do the same, right now it opens as text (as of 
OOF680_m7).



- When attempting to open files in an unsupported format, such as PDF, OOo
will not try to open them as Text documents.

Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=74295



I'm advocate to this.


Please post comments here or at the Wiki talk page.



Maybe you should discuss details with the people at 
http://ux.openoffice.org.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [dev] File | Open default file type

[Allen Pulsifer]

> Yes, that sounds good. I would change it a little bit and 
> offer showing the filter dialog (that also needs a redesign 
> BTW). Only offering to open as text is not enough. Especially 
> text files are detected quite reliably.
> 
> But as in most cases where OOo fails to detect the file it 
> *is* an unknown type showing the filter dialog immediately 
> isn't a good idea. So a message box asking how to proceed as 
> you suggested will help.

Hello Mathias,

I did a preliminary spec at
http://wiki.services.openoffice.org/wiki/File_Chooser_Type_Handling_Specific
ation

I think you may have more insights than me though.  Could you comment
further how the filter dialog should work, vis a vis the draft spec?

Thank you,

Allen

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[dev] File | Open draft specification

[Allen Pulsifer]

I was asked to propose a spec for File | Open, more specifically, for how it
handles file types.

The first draft is at
http://wiki.services.openoffice.org/wiki/File_Chooser_Type_Handling_Specific
ation

Some of the changes from OOo's current behavior:

- The default file type depends on the current application.  For example,
from Writer, File | Open by default displays only Text documents.  The other
types, including "All Files (*.*) can still be chosen from the File Type
drop down list.

Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=67163

- If an type group such as "Spreadsheets" is chosen, OOo will either open
the file in Calc or will fail.  It will not for example open a file as a
Text document when Spreadsheets is selected.

Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=74277

- When attempting to open files in an unsupported format, such as PDF, OOo
will not try to open them as Text documents.

Ref: http://qa.openoffice.org/issues/show_bug.cgi?id=74295

Please post comments here or at the Wiki talk page.

Thank you,

Allen

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[dev] Removing the ability to write data into ODB files

[Matthias B.]

For policy reasons we want to prevent users from storing data directly
inside ODB files. But we want to retain all of OpenOffice.org features
for other database types that use external storage. Does anyone have
an idea how we can achieve this?

Matthias

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] datamatrix 2d barcodes for Calc

[Alessandro Zummo]

On Tue, 13 Feb 2007 13:47:46 +0100
Christian Lohmaier <[EMAIL PROTECTED]> wrote:

> > 
> >  a) cell changes
> >  b) read it, generate barcode, save barcode to file
> >  c) load file and embed image
> 
> Yes, how else should it work?
> 
> What intervals are you talking about? How often does it have to be
> regenerated?

 each time the cell changes. it depends on the user. a barcode
 can hold any kind of data.. for example, the result of a sum
 of a column.

> How did you envision how things should work?

 I would have used graphics primitives to draw
 the object in memory.

-- 

 Best regards,

 Alessandro Zummo,
  Tower Technologies - Torino, Italy

  http://www.towertech.it

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] OOo w/o URE

[Caolan McNamara]

On Tue, 2007-02-13 at 09:54 +0100, Stephan Bergmann wrote:
> FYI: 

Yeah, I'm very much in favour of this myself. Split the build into two
parts the API stable ure stuff, and the rest. I'm trying to home-brew
some hackery to fake this up. 

The current practical problems are of course as listed above and that to
e.g. build the sdk separately from OOo and then to build OOo against
that sdk+ure combination you need to have 
a) config_office, dmake, solenv, instsetoo_native, soltools, scp2 and
readlicense_oo in both the sdk+ure and OOo build trees

b) have bridges, cli_ure, codemaker, cppu, cppuhelper, cpputools,
idlc, io, javaunohelper, jurt, jvmaccess, jvmfwk, offapi, offuh,
rdbmaker, registry, remotebridges, ridljar, sal, salhelper
stlport, stoc, store, udkapi, ure, unoil, xml2cmp, odk, sdk_oo
autodoc, udm, cosv, unodevtools, jut in the ure tree

b) and jvmfwk3rc and unorc are generated in the "ure" tree for both
itself and for the final OOo product, as well as the forementioned .rdb
files so you need to cheat and stick them into a package generated from
the ure build and reuse them from inside the OOo build and then fiddle
with some variables to add the sdk includes and the ure libs to the
SOLARINC and SOLARLIB etc.

So it's certainly kludgy to try and do it right now, but is a very
attractive goal for me to be able to just rebuild the portion of OOo
affected by whatever bug I've just fixed. And a nice thin edge of a
wedge to make OOo more modular at build-time as well as at runtime.

C.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] datamatrix 2d barcodes for Calc

[Christian Lohmaier]

On Tue, Feb 13, 2007 at 11:15:36AM +0100, Alessandro Zummo wrote:
> On Tue, 13 Feb 2007 11:00:04 +0100
> Christian Lohmaier <[EMAIL PROTECTED]> wrote:
> > 
> > If you need to update the barcode, you just delete the old one and embed
> > the new one...
> 
>  the new one must be dynamically generated based on the
>  content of a cell. you are suggesting something like that:
> 
>  a) cell changes
>  b) read it, generate barcode, save barcode to file
>  c) load file and embed image

Yes, how else should it work?

What intervals are you talking about? How often does it have to be
regenerated?

How did you envision how things should work?

ciao
Christian
-- 
NP: nichts

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[dev] OO_Objects

[newbe]

Hi 
I am trying to identify embedded objects in a openoffice doc with out having
to open it. I can enumerate a doc and find object1 , obect2 ect. However I
can not find a way to identify what program the embedded objects belong to
ie impress, calc or even execel if it is a word doc.
Can any one help me out or advise me on what to look at in the API that may
achieve this. I would also be grateful for any examples or links to examples
that would help explain how to do this.

Many thanks 

newbe
-- 
View this message in context: 
http://www.nabble.com/OO_Objects-tf3220016.html#a8942548
Sent from the openoffice - dev mailing list archive at Nabble.com.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] datamatrix 2d barcodes for Calc

[Christian Lohmaier]

On Sun, Feb 11, 2007 at 03:01:02PM +0100, Alessandro Zummo wrote:
> On Sun, 11 Feb 2007 14:44:09 +0100
> Christian Lohmaier <[EMAIL PROTECTED]> wrote:
> 
> > >  I guess this would work, but would also require having a web server
> > >  to generate the image. looks ugly ;(
> > 
> > I think you misunderstool the URL-part. That doesn't mean that you need
> > a webserver. OOo uses URLs for "everything", a local file is
> > file:///tmp/somedir/some.file on linux for example (or
> > file:///c:/tmp/somfile.txt on windows)
> 
>  ok, but the barcode is supposed to change
>  based on the contents of a cell, how can
>  you do that with a file based image?

Huh? What other images are there than "file based" ones?
 
>  If you use a webserver you can maybe add
>  the code to the url and have a cgi generate
>  it, but you can't with a file url.

You still didn't understand what the codesnippets does.
It uses a temporary file and inserts it into the document, so that you
can remove the temporary file afterwards.
Even for internal (embedded) images, there are URLs (special ones that
point into the document-container).

If you need to update the barcode, you just delete the old one and embed
the new one...

ciao
Christian
-- 
NP: nichts

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dev] Window Scrolling Performance with Images

[Thorsten Behrens]

Terry Alexis Lurie <[EMAIL PROTECTED]> writes:

> It looks as though the buffer is blocking and copying in the bitmap
> 100% before switching back to other tasks.  So if the copy is not as
> fast as the scrolling action, then the scroll lags while it
> completes.

[...]

> My thoughts are:
> 
> 1) Find out where the bitmap copy-in operation is and make it
> cancellable. Cancel if further scroll action requested

> 2) You guys have done a good job with the wireframe ZOOM_PANNING
> which is nice and quick. Maybe I could make an option to switch that
> into the scroll action instead.

> 3) A cheap cache with a mem-resident downsampled image. This is what
> Adobe Ilustrator does when scrolling.
> 
> 4) Some combination of those three.
> 
Hi Terry,

great that you want to go fix this! The code doing the bitmap
scaling/setup is in module goodies,
goodies/source/graphic/grfmgr?.cxx, to be specific. There's already
some buffering going on, but it's clearly possible to extend that with
a lo-res bitmap for fast repaint. 

You can poll for pending user input via Application::AnyInput() from
vcl, so, doing that in the bitmap interpolation outer loop should make
that cancellable - problem is to get the GraphicManager code to be
called again eventually, to repaint with the full-blown bitmap. Have a
look at svx/source/svdraw/svdograf.cxx, which implements the
Draw/Impress graphic shape. There's already a timer-based
demand-loading feature, you might borrow from that to have a timer
call the graphic shape again, after the scrolling has finished.

Hope that gets you started, feel free to ask again, on freenode irc
#dev.openoffice.org, here or on the [EMAIL PROTECTED] mailing list!

Cheers,

-- Thorsten

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[dev] OOo w/o URE

[Stephan Bergmann]

FYI: 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[dev] copying/stripping "basic" to "binfilter"

[Frank Schönheit - Sun Microsystems Germa ny]

Hi,

In the course of issue 73329, I copied a stripped version of the "basic"
module to "binfilter" (binfilter/bf_basic, building a bf_sb lib). The
code base used for this was a 680m199.

As a consequence, and as long as the respective CWS (basmgr02) is not
integrated (which might take a while due to QA constraints), I kindly
ask to notify me ([EMAIL PROTECTED]) of any binfilter-relevant
changes you do in "basic".

That is, if you for instance add code in the "basic" module which is
needed to fix a binfilter bug, then I'd need to duplicate this code in
my binfilter/bf_basic.

With every resync of my CWS, I will try to judge the changes which
happened in the master, whether or not they have binfilter-relevance. If
in doubt, I'll ask the developer who did them, but if you could tell me
changes before I encounter them on resync, that'd be nice.

Thanks & Ciao
Frank

-- 
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]