[libreoffice-users] Base can't open databases

2011-12-14 Thread Michael Bogaerts
Hello;Being my first post to this mailing list i immediately take the opportunity to try and fix my biggest issue with LO; I can't seem to open my database file; i get an error message which i can't get rid of although i've been trying whatever that looked sane to do

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Fernand Vanrie
Michael , We zouden dat in het Nederlands kunnen oplossen, no :-) You must understand that your odb file is just a go between, to make a connection to your original tables main. When you first made your odb file you have to make a choice wath driver to use make the connection. For some

Re: [libreoffice-users] When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Tom Davies
Hi :) Could Google-Docs be useful?  It is already Cloud-based and at the client end is used through a web-browser.  Wrt OpenOffice don't believe everything that people say.  There is a lot of confusion.  Until about 2 years ago it had been managed by Sun for about a decade along with a number

[libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Alex Thurgood
Le 14/12/2011 08:37, Michelle Konzack a écrit : Hi Michelle, I have found an old announcement that OOo will be available as Web-App and I like to know, whether it exist already and where the mailinglist is. Note: It seems the OOo guys will shutdown the OOo site and mailinglists I

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Alex Thurgood
Le 14/12/2011 09:31, Michael Bogaerts a écrit : Hi Michael, with LibOffice.I removed OO.O first and then I installed LibOffice 3.4.4 (the latest release).Since that day i can't open my database files anymore; i can't read the original MDB files, nor can i open my odf

[libreoffice-users] Re: Base Crashes when making listbox droppable

2011-12-14 Thread Alex Thurgood
Le 13/12/2011 18:46, dakiriki a écrit : Hi, Is this abug? It makes Base totaly unusable to me. Thanks in advance Yes, sounds like it, but I think I saw something on bugzilla about this already. You should check with bugzilla to see if it hasn't already been registered, and if not open a

[libreoffice-users] Re: new user

2011-12-14 Thread Tom
Hi :) There is also the Nabble interface. Generally it seems best to join a list and then set your preferences to nomail and then perhaps subscribe to individual threads but i'm still not sure ow best to handle high-traffic lists such as this one. Regards from Tom :) -- View this message in

Re: [libreoffice-users] Finding Dictionaries

2011-12-14 Thread Tom Davies
Hi :) +1 It would be great if the website list knew and recognised the various Dvd projects.  The dictionaries you found are also on the Extensions site so i would be good to have something pointing to there too i guess.  Nicely found!  It's not easy to find this sort of thing at the moment!

Re: [libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-14 Thread Stephan Zietsman
Ian Whitfield wrote: 1) How do I work out what ROW NUMBER a given unique value is on? 2) How do I use this ROW NUMBER to make-up a valid CELL ADDRESS? 3) How do I get the VALUE in that CELL ADDRESS? [...] 2) For the CELL ADDRESS I have a cell that identifies each COLUMN that these values

Re: [libreoffice-users] Change cell border sizes- quickly?

2011-12-14 Thread MiguelAngel
El 14/12/11 5:18, Dave Barton escribió: Original Message From: .pe...@aleksandrsolzhenitsyn.net To: users@global.libreoffice.org Date: Tue, 13 Dec 2011 22:26:01 -0500 I upgraded from Oo 3.2 (I think that was the version) to the following version of LibreOffice; LibreOffice

Re: [libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Michael Bogaerts
Hey Alex, Thanks for the info.. But since i'm using CALC in a production enviroment i don't want to go 'trying' with beta releases ... I could though use a VM and see if it works there ... Also; i thought that the tables were converted to ODF; but clearly they're not when i read your

Re: [libreoffice-users] Change cell border sizes- quickly?

2011-12-14 Thread .
On 12/14/2011 05:45 AM, MiguelAngel wrote: El 14/12/11 5:18, Dave Barton escribió: Original Message From: .pe...@aleksandrsolzhenitsyn.net To: users@global.libreoffice.org Date: Tue, 13 Dec 2011 22:26:01 -0500 I upgraded from Oo 3.2 (I think that was the version) to

Re: [libreoffice-users] Change cell border sizes- quickly?

2011-12-14 Thread Cor Nouws
Hi Alexander, . wrote (14-12-11 13:26) With F11, select Default format, and change there the border. If there is another style non vinculated with default, change it also. Miguel, I tried it with one of the sheets but it had no effect. I tried it with a new sheet but no effect either. That

[libreoffice-users] Syntax Question

2011-12-14 Thread Ian Witty Whitfield
Hi All Can someone help me with some syntax please?? I have a two-sheet Calc Spreadsheet. All my data lives on the first sheet called Data and my Analysis Reports are on Sheet Two. I have the same values in any given Column in my Data Sheet, (ie all my Totals are in Column D), and - as per

Re: [libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Tom Davies
Hi :) You can have a machine with more than 1 version of LibreOffice but it's not trivial to set-up.  This guide can help.  http://wiki.documentfoundation.org/Installing_in_parallel The main advantage is that when you feel like upgrading you can test the new one before committing to it and

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Mark Stanton
It's hard to think of a situation that would truly benefit from the data being in an odb. Specific database engines manipulate their own data much better than... Almost anything. You can do by extracting the data from your current database and putting it into HSQL. I believe Base does

Re: [libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Tom Davies
Hi :) Ouch sorry for double-posting and nothing hugely useful in either.  Base is better when the back-end is separate from the front-end.  Base is a great front-end.  There are a lot of choices for back-ends and i have no idea which is best for a simple small database.  SqlLite, HSql(db?) or

re: [libreoffice-users] Syntax Question

2011-12-14 Thread Gérard FARGEOT
Hi, Message du 14/12/11 14:29 De : Ian Witty Whitfield A : users@global.libreoffice.org Copie à : Objet : [libreoffice-users] Syntax Question Hi All Can someone help me with some syntax please?? I have a two-sheet Calc Spreadsheet. All my data lives on the first sheet called

Re: [libreoffice-users] Finding Dictionaries

2011-12-14 Thread webmaster for Kracked Press Productions
What he was looking for was an Australian dictionary that included the thesaurus, and such. That dictionary is not currently on the LO Extension Center. The key for why most of the dictionaries on the LibreOffice-NA.US site dictionary page[s] are not on the Extension Center list, is simple.

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread webmaster for Kracked Press Productions
The question about a cloud version of LO or OOo was the thread. As for LO having one, well there is a lot of server side work and expense to produce a cloud based application. As for how soon will there be a cloud app that is not so limiting, it is all in the economics of server side

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Caesar
On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote Re Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?: Personally, I do not like the idea of cloud based computing, for security reasons and ownership of files.

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Michael Bogaerts
You are learning me here something ... So odb files aren't real database files or what??? Met vriendelijke groeten, Michael Bogaerts De bij ons als Mark Stanton geidentificeerde tegenpartij wist exact op 14/12/2011

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread webmaster for Kracked Press Productions
On 12/14/2011 10:18 AM, Caesar wrote: On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press Productionswebmas...@krackedpress.com wrote Re Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?: Personally, I do not like the idea of cloud based computing, for

[libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Tom
Hi :) +1 Afaik there are no plans to make LibO into Cloud based apps. Recently there was an announcement that work was starting on making LibreOffice available to directly install on certain mobile devices but it is expected to take months or years to complete. So, it's likely we would have

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Alexander Thurgood
Le 14/12/11 13:20, Michael Bogaerts a écrit : Hi Michael, Also; i thought that the tables were converted to ODF; but clearly they're not when i read your comments... Is there a way to fully convert an MDB to ODF without keeping 'links'??? because actually that's what i wanted to do in the

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Caesar
On Wed, 14 Dec 2011 10:35:51 -0500, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote Re Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?: I was part of the movement. I even saw PCs used as dumb terminals for a time with software like Kermit

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread David S. Crampton
I will speak up a little for the positive case for cloud-based computing and apps. In the IT Manager position I recently left the motivator for looking at web apps was PEOPLE; specifically problems with our in-house people. Making a long story short, I had built an entirely in-house M$

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Joel Madero
Personally I think the priority of a cloud suite is much less than ensuring that there is absolutely no bugs while moving files between Microsoft and LO, if a new user opens a .doc with a few tables, footer, header, TOC, etc... in LO and sees that it doesn't look right, they'll abandon it

Re: [libreoffice-users] Syntax Question

2011-12-14 Thread Ian Whitfield
On 14/12/2011 16:04, Gérard FARGEOT wrote: =INDIRECT(Data.Data.H5Data.M9) with Letters column identifier in Data.H5 and number row identifier in Data.M9 If column identifier is a number, you can use INDIRECT ADDRESS =INDIRECT(ADDRESS(Data.M9;Data.H5;4;;Data)) Thanks Gerard PERFECT -

Re: [libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Steve Edmonds
Hi. Not sure if it would work, but what about the 3.3.4 release? steve On 2011-12-15 01:20, Michael Bogaerts wrote: Hey Alex, Thanks for the info.. But since i'm using CALC in a production enviroment i don't want to go 'trying' with beta releases ... I could though use a VM and see if it

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread toki
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/12/11 16:19, David S. Crampton wrote: looking at web apps was PEOPLE; specifically problems with our in-house people. Migrating to the cloud hides the people problem. It does not remove it. For sensitive data, the cloud merely compounds

[libreoffice-users] LibreOffice Portable

2011-12-14 Thread M Robinson
Hello, What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the downloads start with a file side of 121 MB. -- GnuPG

[libreoffice-users] Re: Change cell border sizes- quickly?

2011-12-14 Thread NoOp
On 12/14/2011 04:26 AM, . wrote: On 12/14/2011 05:45 AM, MiguelAngel wrote: ... With F11, select Default format, and change there the border. If there is another style non vinculated with default, change it also. Miguel Ángel Miguel, I tried it with one of the sheets but it had no

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Mark Stanton
If I'm not mistaken (although I might be and I haven't got the time to go back and check) and odb file is effectively a zip file with various things in it. As Tom said, LO ( Ooo, of course) really doesn't have a database section. It has a gateway to a database, in fact different adapters for

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread NoOp
On 12/14/2011 12:31 AM, Michael Bogaerts wrote: opgegeven URL beschikbaar is.English version;The connection with the datasource 'main' couldn't be made.The connection with the external datasource can't be made because there's no SDBC-driver available for the given URL.The thing is

[libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread Pedro
M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the downloads start with a file side of 121

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread webmaster for Kracked Press Productions
On 12/14/2011 04:33 PM, Pedro wrote: M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread M Robinson
On 12/14/2011 4:33 PM, Pedro wrote: M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the

[libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread NoOp
On 12/14/2011 01:33 PM, Pedro wrote: M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the

[libreoffice-users] Re: Base can't open databases

2011-12-14 Thread Alexander Thurgood
Le 14/12/11 22:05, Mark Stanton a écrit : Hi Mark, If I'm not mistaken (although I might be and I haven't got the time to go back and check) and odb file is effectively a zip file with various things in it. Yes. I believe HSQL is a cut down database, on the basis that a lot of the

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Jay Lozier
On 12/14/2011 02:35 PM, toki wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/12/11 16:19, David S. Crampton wrote: looking at web apps was PEOPLE; specifically problems with our in-house people. Migrating to the cloud hides the people problem. It does not remove it. For sensitive

[libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread NoOp
On 12/14/2011 11:54 AM, M Robinson wrote: Hello, What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the

Re: [libreoffice-users] Re: Change cell border sizes- quickly?

2011-12-14 Thread .
On 12/14/2011 03:15 PM, NoOp wrote: On 12/14/2011 04:26 AM, . wrote: On 12/14/2011 05:45 AM, MiguelAngel wrote: ... With F11, select Default format, and change there the border. If there is another style non vinculated with default, change it also. Miguel Ángel Miguel, I tried it with

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread M Robinson
Thanks, version 3.4.3 installed without issue. I like the remove extra languages option, that was one of the reasons I wanted to download LibreOffice: http://server-support.co/blog/pc/trimming-down-libreoffice-portable/ However, the poster claims he got the LibreOffice foot print down to

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton
Try to turn off your realtime antivirus scanner. Unload it or stop the process. On Wed, 14 Dec 2011 13:33:40 -0800, Pedro pedl...@gmail.com wrote: M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread M Robinson
I'm using Pale Moon 6.0 and also tried it with Avant Ultimate 2012 build 8, Opera 11.51 Build 1087, IE version 9.0.8112.16421, and Chrome 15.0.874.121. I anyone has any idea why I'm having problems let me know, I would like to download LibreOffice Portable version 3.4.4. all downloads stalled

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread M Robinson
That worked. Why does that work? I'm using Avast 6.0.1367, and it hasn't thrown any flags while silently killing ONLY LibreOffice Portable downloads. On 12/14/2011 6:14 PM, David S. Crampton wrote: Try to turn off your realtime antivirus scanner. Unload it or stop the process. On Wed, 14 Dec

[libreoffice-users] Re: Change cell border sizes- quickly?

2011-12-14 Thread NoOp
On 12/14/2011 02:35 PM, . wrote: On 12/14/2011 03:15 PM, NoOp wrote: On 12/14/2011 04:26 AM, . wrote: On 12/14/2011 05:45 AM, MiguelAngel wrote: ... With F11, select Default format, and change there the border. If there is another style non vinculated with default, change it also.

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread M Robinson
On 12/14/2011 5:24 PM, Jay Lozier wrote: On 12/14/2011 02:35 PM, toki wrote: On 14/12/11 16:19, David S. Crampton wrote: looking at web apps was PEOPLE; specifically problems with our in-house people. Migrating to the cloud hides the people problem. It does not remove it. For sensitive

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton
I don't know why. Sorry experience suggested it. I have seen this behavior on 3 different antivirus scanners over the years. All in Windows OS. No useful user feedback. Not even an event registered to event logs. If you download a lot you might see it in other downloads. I answered a

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread M Robinson
It is a first for me, I download OS's and other large files regularly. Thanks, again. On 12/14/2011 7:03 PM, David S. Crampton wrote: I don't know why. Sorry experience suggested it. I have seen this behavior on 3 different antivirus scanners over the years. All in Windows OS. No useful user

Re: [libreoffice-users] Ubuntu Fax Driver Search

2011-12-14 Thread Arthur N. Dunning III
Would manual selection work with an external modem powered by a USB port? That is the kind of modem I'm using. Arthur ** On 12/09/2011 07:51 PM, Jay Lozier wrote: You could try installing your fax card as printer using Printers in the System Settings. I would not be surprised if you had

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread webmaster for Kracked Press Productions
I have seen it before, but it has been a few years ago that I have used Windows as my default OS. Actually it was two laptops XP and Vista back then. But I heard about the same issue and had it happen, or something like that, with me a few times on some of my larger files. I was using

Re: [libreoffice-users] Ubuntu Fax Driver Search

2011-12-14 Thread webmaster for Kracked Press Productions
I know that exist, but I did not know which ones were Linux capable. On 12/14/2011 08:03 PM, Arthur N. Dunning III wrote: Would manual selection work with an external modem powered by a USB port? That is the kind of modem I'm using. Arthur ** On 12/09/2011 07:51 PM, Jay Lozier wrote:

Re: [libreoffice-users] Ubuntu Fax Driver Search

2011-12-14 Thread Arthur N. Dunning III
In my case, the modem I use is a USRobotics USR5637 USB modem. It's compatible with Windows, Mac and Linux. The Linux distro that I'm using is Ubuntu 11.10. Arthur ** On 12/14/2011 07:23 PM, webmaster for Kracked Press Productions wrote: I know that exist, but I did not know which ones

Re: [libreoffice-users] Re: Change cell border sizes- quickly?

2011-12-14 Thread .
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/14/2011 06:53 PM, NoOp wrote: On 12/14/2011 02:35 PM, . wrote: On 12/14/2011 03:15 PM, NoOp wrote: On 12/14/2011 04:26 AM, . wrote: On 12/14/2011 05:45 AM, MiguelAngel wrote: ... With F11, select Default format, and change there the

Re: [libreoffice-users] When will be a Web-Version of OOo/LO available?

2011-12-14 Thread Jean-Baptiste Faure
Hi Michelle, Le 14/12/2011 08:37, Michelle Konzack a écrit : [...] Hello *, since August 2011 I am experimenting with Cloud-Computing using 200 IBM Severs (used) in total and searching for an Office Suit which can be integrated into a Web-Interface. The current Doc-Viewer is WebODF

[libreoffice-users] Unable to use LibreOffice 3

2011-12-14 Thread Sharon L Knoblock
I downloaded LibreOffice 3, selected text document to write a letter. I get a flashing cursor but cannot view what I have typed. I am able to import documents from other programs and work with them from LibreOffice 3. Any help would be appreciated. Sharon -- For unsubscribe instructions