[libreoffice-users] Re: Base questions

2014-08-04 Thread Alex Thurgood
Le 01/08/2014 12:55, Wolfgang Keller a écrit : I never understood why anyone halfway sane in their minds would use an embedded database anyway or why the developers of StarOffice/LO/OO even considered it. As I recall, at the time of the release of OpenOffice2, it had to be like Access -

[libreoffice-users] Re: Schema in Calc

2014-08-04 Thread Alex Thurgood
Le 31/07/2014 00:08, Paul a écrit : Just out of interest, why would a db driver come into play? This is a spreadsheet we're talking about. The mention of db schema was merely to ask why Calc doesn't have something like it. How else would one obtain the schema in the first place ? As I see

[libreoffice-users] Re: MAC: 4.3.0.4 Info.plist version confusion

2014-08-04 Thread Alex Thurgood
Le 30/07/2014 15:20, Markus Jansen a écrit : Hi Markus, I just wanted to check out the new libreOffice with a Mac and found out that in the Info.plist - file the key CFBundleShortVersionString is 4.3.4 in contrast to the CFBundleGetInfoString which is 4.3.0.4 (see the third digit: zero).

[libreoffice-users] UK Government adopts Open Document Format

2014-08-04 Thread Andrew Beverley
Following on from previous threads, this is good news for LibreOffice: Government documents will use what are known as open standards for document formats. Word processor files will be saved with “.odt” suffixes, rather than “.doc”.

Re: [libreoffice-users] Page break is not correct with printing

2014-08-04 Thread Tom Davies
Hi :) openSuSE probably allows you to install all the basic Microsquish fonts in a single package. In Ubuntu it's called ttf-mscorefonts-installer although i have a feeling that it's renamed in Ubuntu and that all other distros use the same name as each other with only Ubuntu going it's own way.

[libreoffice-users] Base problem

2014-08-04 Thread Yohann Valette
Hello, I have a problem with Base, I created a macro but, if the file location changes, the macro doesn't work, I wanted to know how to fix this problem if possible.. I join you my macro: Sub CambiarNombreEstanteria Dim oDBContext As Object , oDB As Object , oBase As Object Dim

Re: [libreoffice-users] UK Government adopts Open Document Format

2014-08-04 Thread Tom Davies
Hi :) There is already quite a lot of FUD in the comments. Surprisingly only 2 posts about MS formats! I attempted to point out a few blunders in people's comments but my posts were t long and are now getting stuck in the moderators inbox. If anyone else could post SHORT comments to dispell

Re: [libreoffice-users] UK Government adopts Open Document Format

2014-08-04 Thread James Knott
On 08/04/2014 04:21 AM, Andrew Beverley wrote: Word processor files will be saved with “.odt” suffixes, rather than “.doc”. I wonder how many people will try to just change the extension, without saving as the appropriate file type? -- To unsubscribe e-mail to:

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread dave boland
How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when creating a db) to use embedded model or the split model. Dave, On Mon, Aug 4, 2014, at 03:27 AM, Alex Thurgood wrote: Le 01/08/2014 12:55, Wolfgang Keller a

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread Jean-Francois Nifenecker
Le 04/08/2014 14:51, dave boland a écrit : How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when creating a db) to use embedded model or the split model. Any embedded DB engine (HSQL or Firebird or any other)

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread dave boland
On Mon, Aug 4, 2014, at 09:10 AM, Jean-Francois Nifenecker wrote: Le 04/08/2014 14:51, dave boland a écrit : How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when creating a db) to use embedded model or the

Re: [libreoffice-users] UK Government adopts Open Document Format

2014-08-04 Thread Tom Davies
Hi :) Good point! One of the posters, Angus, seems to be pushing people into thinking that is all that's required. I think i have covered that but just 1 voice saying it doesn't carry much weight imo. Or at least it shouldn't, imo. Regards from Tom :) On 4 August 2014 13:14, James Knott

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread Ian Whitfield
On 08/04/2014 04:15 PM, dave boland wrote: On Mon, Aug 4, 2014, at 09:10 AM, Jean-Francois Nifenecker wrote: Le 04/08/2014 14:51, dave boland a écrit : How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 14:51, dave boland a écrit : Hi Dave, How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when creating a db) to use embedded model or the split model. It doesn't, but Firebird wasn't chosen for

Re: [libreoffice-users] Base questions

2014-08-04 Thread Wolfgang Keller
Average end-user is challenged enough just installing an O/S and productivity suite, and learning how to use them, much less a real RDBMS. PostgreSQL is pretty foolproof to install and use. I know what I am talking about since I am the reference fool. It may be something different if you need

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 16:15, dave boland a écrit : That is my point. That is why Base needs to make setting up an external db easy - like when the db is being created. Check one box for the embedded model, another for the split/external model. Appropriate Help infornation will be needed. While

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread Paul D. Mirowsky
Before I begin, I will plead ignorance of how these things really happen. It appears that what should be happening is that the database should always be external, but whether it is placed inside the same folder. To the user, the interpretation of 'internal' would be that it is within it's

[libreoffice-users] Re: Base problem

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 12:57, Yohann Valette a écrit : Hi Yohann, I have a problem with Base, I created a macro but, if the file location changes, the macro doesn't work, I wanted to know how to fix this problem if possible.. Which file location are you talking about : - the location of the macro

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 31/07/2014 21:22, dave boland a écrit : 2. If they are not that reliable, what is the LO Base procedure to create a split database? https://forum.openoffice.org/en/forum/viewtopic.php?t=54254 and the tutorial referred to in this post available from the same OpenOffice.org forum. Alex

[libreoffice-users] Base clarity on external internal functionality

2014-08-04 Thread Paul D. Mirowsky
It has never been clear to me other than external databases are more reliable, what capabilities are gained or lost. It appears that external databases must use SQL to do things and that Base. Does this mean that the front end is no longer capable of displaying 'Tables' and their linking?

[libreoffice-users] Sum of multiple cells substring

2014-08-04 Thread Daniel R. Miguel
Hi, I have a table with cells that may contain OTnum, so it might contain OT0.5, OT1, OT2, OT2.5 et cetera. I would want to sum the number substring of all the cells in a row, so for example if I have this row: AlanOT0,5FOT1FVOT2FFVOT3 I would have

[libreoffice-users] Re: Base clarity on external internal functionality

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 17:26, Paul D. Mirowsky a écrit : It appears that external databases must use SQL to do things and that Base. Not for everything, but your mileage as to what you can get out of LibreOffice's UI varies considerably depending on the db backend. Does this mean that the front end

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 16:41, Paul D. Mirowsky a écrit : Before I begin, I will plead ignorance of how these things really happen. It appears that what should be happening is that the database should always be external, but whether it is placed inside the same folder. To the user, the

Re: [libreoffice-users] Base clarity on external internal functionality

2014-08-04 Thread Tom Davies
Hi :) The Tables of the external back-end should show in Base's Tables display. Regards from Tom :) On 4 August 2014 16:26, Paul D. Mirowsky p_mirow...@bentaxna.com wrote: It has never been clear to me other than external databases are more reliable, what capabilities are gained or lost. It

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread dave boland
On Mon, Aug 4, 2014, at 12:30 PM, Alexander Thurgood wrote: Le 04/08/2014 16:41, Paul D. Mirowsky a écrit : Before I begin, I will plead ignorance of how these things really happen. It appears that what should be happening is that the database should always be external, but whether it is

Re: [libreoffice-users] Re: Base questions

2014-08-04 Thread Jean-Francois Nifenecker
Le 04/08/2014 18:59, dave boland a écrit : I'm getting a little confused. My understanding is that there are really two issues here. One is that LO Base is RAM resident - all updates are held in RAM until saved by the user, or the program is closed. Correct? If so, this situation will

Re: [libreoffice-users] UK Government adopts Open Document Format

2014-08-04 Thread Tim Lloyd
I would like to think that the people behind this will have provided a handy list of dos and donts to make integration a bit easier. If not let me know and I'll volunteer my services :) Cheers On 05/08/14 00:12, Tom Davies wrote: Hi :) Good point! One of the posters, Angus, seems to be

Re: [libreoffice-users] Sum of multiple cells substring

2014-08-04 Thread Brian Barker
At 17:38 04/08/2014 +0200, Daniel R. Miguel wrote: I have a table with cells that may contain OTnum, so it might contain OT0.5, OT1, OT2, OT2.5 et cetera. I would want to sum the number substring of all the cells in a row, so for example if I have this row: AlanOT0,5FOT1FV

[libreoffice-users] Intermittent Calc Issues

2014-08-04 Thread Gregory Forster
Hi, I haven't been on this users group for over two years, primarily because everything worked great, until now. I have an inconsistent and not often issue with Calc. Well, it's more annoying than anything else, because I can easily correct it, but it shouldn't be. Calc does weird

Re: [libreoffice-users] Intermittent Calc Issues

2014-08-04 Thread Jean-Francois Nifenecker
Hi, Le 05/08/2014 05:25, Gregory Forster a écrit : Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional