[libreoffice-users] Re: Base questions
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 - but of course, as Sun was mainly running the show, that meant that it had to be multi-OS, thus Java based and a fairly simple, drop-in piece of code with an appropriate licence. One would do well to remember that at the time, the internal Sun Base development team only comprised about 3 members of staff working full-time on the project, thus resources were painfully limited. It turned out to be not so simple after all, but that can be said about many things in software development. The issue of performance was raised even back then, and remains with us today - embedded Java bridging (via UNO JNI) of an in-memory database - loads of things to go potentially wrong at any given instance in the lifecycle of the application, notwithstanding that upgrading to newer versions of the db has always been fraught with complications, so a maintenance nightmare for OOo/AOO/LO developers. It can be done though, Fred Toussi (one of the lead developers on the hsqldb project) has, I believe, provided patches for the integration of an update to the hsqldb version code, but these have not been integrated due to the decision to move to Firebird. Database noobs wanted Access-like functionality and portability and multi-OS operation - the fact that they don't really get that today with LibreOffice Base is due more to lack of functional implementation/integration witn the other parts of LibreOffice than to the type of underlying db. Even MS Access has moved to a separated db/frontend paradigm, as far as I understand. Just to put things in perspective, there are, to my knowledge, currently no full/part time paid-to-work developers within the LibreOffice project that work on Base - everything done is voluntary, spare/free time involvement, so it is hardly surprising that things with Base move a little more slowly than modules such as Writer and Calc, in fact, it is my undestanding that the main voluntary developer spends most of his time in the project undoing the bugs/regressions caused by ongoing code development elsewhere within the LibreOffice project. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Schema in Calc
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 it there are only two possibilities : - import from an existing db connection using the db source/named ranges functionality -this requires a db context/connection and consequently a db driver; - import from a file (XML/UML or other Calc-recognisable file type) that has been obtained by exporting the schema from a database. The second way wouldn't require a db driver, but is more cumbersome IMO than being able to query the db directly for the schema because it requires specific matching of the structure to the internal representation of a Calc file, i.e. implementation of a separate import/export filter. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MAC: 4.3.0.4 Info.plist version confusion
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). Why is this? Just the shorten the version string to 3 digits? And if a future long version will be 4.3.1.3, will the short one be 4.3.1, which is smaller than the older one (4.3.4)? Such things makes automatic software deployment even harder. It might just be an error, or it might be linked to the hope of getting LibreOffice onto the Apple store - I seem to recall that there is some kind of version naming convention for that. The best place to ask your question would be on the dev irc channel or the dev mailing list. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] UK Government adopts Open Document Format
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”. https://gds.blog.gov.uk/2014/07/22/making-things-open-making-things-better/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Page break is not correct with printing
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. You can probably find the correct package most easily by opening your package-manager and then using it's search feature to look for trebuchet verdana comic sans or one of the other slightly unusual fonts. I suspect that searching for Arial or Times New Roman would probably bring up tons of free equivalents instead and those might still have the tiny discrepancy. Another thing to have checked is that; Format - Page - Page really is set to A4 just before you try to print it. The problem is usually the other way around, ie that Windows users are set to US Letter by default and everyone else is set to A4. However it sounds like it might be the other way around for once. At least the person sending out the document is trying to be compatible with other people. The Xls format is usually the one that does work with other programs and suites. Problems usually only happen with XlsX. However all editable formats, especially Microsquish ones, do have slight differences on different machines. Kingsoft is trying to follow along behind Microsquish Office but is always lagging behind and can't innovate or get ahead. That alone could lead it to slowly die through stagnation. Another potential problem with Kingsoft is that if it keeps following MS Office tooo closely then MS might be able to shut it down due to copyright violations. Being based in China might protect them from that but it might become difficult to use or develop (or translate) in the rest of the world. Right now it is a good temporary solution to have alongside LibreOffice. There is nothing forcing you to have only 1, unless your machine is VERY low spec. I think i would use Kingsoft ONLY if i had big problems with a specific document in LO and even then only use it to convert DocX or XlsX into a better format for LO to use. So far i've been fairly lucky. Anyway, glad to hear you fixed the immediate problem! Congrats and regards from Tom :) On 3 August 2014 14:48, Spencer Graves spencer.gra...@prodsyse.com wrote: On 8/3/2014 4:00 AM, Mark Bourne wrote: Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format Page Sheet Scale Fit ... on number of pages 1 2. Format Page Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single
[libreoffice-users] Base problem
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 oStatement As Object , oRequete As Object Dim strSQL As String 'On se connecte à la base de données référencées oDBContext = CreateUnoService(com.sun.star.sdb.DatabaseContext) oDB = oDBContext.getbyName(DocProyectosV1) 'La base est sans login/password oBase = oDB.getConnection(,) 'On prépare la requête oStatement = oBase.createStatement() 'On saisit la requête que l'on stocke dans la chaine strSQL 'A noter, chaque doit être doublé et la requête SQL doit être entre . Dim a as String, b as string b= InputBox (Apunta el nombre de la estanteria que quieres renomar,Nombre actual de la estanteria) a= InputBox (Apunta el nuevo nombre de la estanteria,Nuevo nombre de la estanteria) strSQL= UPDATE Documento SET Estanteria =+a+ WHERE Estanteria=+b 'On exécute la requête SQL oRequete = oStatement.executeQuery( strSQL ) 'On ferme proprement les appels oRequete.Close oStatement.Close oBase.Close oBase.Dispose End Sub Thanks for your help, Have a good day! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] UK Government adopts Open Document Format
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 some of the FUD it would be really great! :) Regards from Tom :) On 4 August 2014 09:21, Andrew Beverley a...@andybev.com wrote: 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”. https://gds.blog.gov.uk/2014/07/22/making-things-open-making-things-better/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] UK Government adopts Open Document Format
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: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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 é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 - but of course, as Sun was mainly running the show, that meant that it had to be multi-OS, thus Java based and a fairly simple, drop-in piece of code with an appropriate licence. One would do well to remember that at the time, the internal Sun Base development team only comprised about 3 members of staff working full-time on the project, thus resources were painfully limited. It turned out to be not so simple after all, but that can be said about many things in software development. The issue of performance was raised even back then, and remains with us today - embedded Java bridging (via UNO JNI) of an in-memory database - loads of things to go potentially wrong at any given instance in the lifecycle of the application, notwithstanding that upgrading to newer versions of the db has always been fraught with complications, so a maintenance nightmare for OOo/AOO/LO developers. It can be done though, Fred Toussi (one of the lead developers on the hsqldb project) has, I believe, provided patches for the integration of an update to the hsqldb version code, but these have not been integrated due to the decision to move to Firebird. Database noobs wanted Access-like functionality and portability and multi-OS operation - the fact that they don't really get that today with LibreOffice Base is due more to lack of functional implementation/integration witn the other parts of LibreOffice than to the type of underlying db. Even MS Access has moved to a separated db/frontend paradigm, as far as I understand. Just to put things in perspective, there are, to my knowledge, currently no full/part time paid-to-work developers within the LibreOffice project that work on Base - everything done is voluntary, spare/free time involvement, so it is hardly surprising that things with Base move a little more slowly than modules such as Writer and Calc, in fact, it is my undestanding that the main voluntary developer spends most of his time in the project undoing the bugs/regressions caused by ongoing code development elsewhere within the LibreOffice project. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Same, same, but different... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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 split model. Any embedded DB engine (HSQL or Firebird or any other) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux 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 they are at it, how about an option to do mariadb or mysql external db instead of just HSQL or Firebird? Dave, -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Access all of your messages and folders wherever you are -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] UK Government adopts Open Document Format
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 james.kn...@rogers.com wrote: 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: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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 creating a db) to use embedded model or the split model. Any embedded DB engine (HSQL or Firebird or any other) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux 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 they are at it, how about an option to do mariadb or mysql external db instead of just HSQL or Firebird? Dave, BIG +1 (or rather +100) I think this is a MUST!! It took me a couple of years to puzzle out what was wrong, (Embedded vs External), and then a few weeks to get it all to work - very little info available - all I could do was step-by-step with the Forum. But once you get it all working the difference is amazing. One year down the line and not one crash or one piece of data lost!!! IanW Pretoria RSA -- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base questions
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 that reason, it was chosen to reduce the dependency on Java code within the LibreOffice project. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base questions
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 to maintain it for running a huge database that gets a serious load of queries and transactions and needs to be fault-tolerant, accessible from the public Internet etc. But for home or small business use cases it's really simple. Plus: MS Office (Pro) has one, so LibréOffice and relatives have to have one. Access is a dangerous heap of junk. I know of Access users who get their database corrupted roughly every four weeks on average. Yes: Such tools should never, ever be used for anything very important. Base looks and feels like a perfectly credible CRUD and reporting frontend for a database. It's just the choice of an embedded database for storage that's a mistery for me. At best, it's useless to include HSQL. At worst, it might discredit LO as a whole. Sincerely, Wolfgang -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base questions
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 they are at it, how about an option to do mariadb or mysql external db instead of just HSQL or Firebird? The database creation wizard (File New Database) already provides for a user to setup a connection a mysql database, either via an ODBC or JDBC driver or, when it is available, via a native C/C++ mysql connector extension, under the Connect to an existing database option. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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 own folder and 'external' would be that the actual database is somewhere else during set-up. In this way, the database (I assume) could easily be copied and re-attached either 'internally' or 'externally'. Am I missing something here? Thanks Paul On 8/4/2014 10:15 AM, 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 creating a db) to use embedded model or the split model. Any embedded DB engine (HSQL or Firebird or any other) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux 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 they are at it, how about an option to do mariadb or mysql external db instead of just HSQL or Firebird? Dave, -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base problem
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 ? - the location of the Base (ODB) file ? You don't mention from where or how (i.e. on which event) in the ODB file your macro is run - this is important (main form, subform, on application open, standalone Writer document, etc). Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base questions
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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base clarity on external internal functionality
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? Does this mean that 'Macro' commands no longer apply? Is there a chart that can add some clarity as to what is functional and isn't between the two? Thanks in advance. Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Sum of multiple cells substring
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 another column with the total sum of OT: AlanOT0,5FOT1FVOT2FFVOT3 6,5 (OT3+OT2+OT1+OT0.5) I have tried with the formula =SUMPRODUCT(MID($B5:$AF5,FIND(OT,$B5:$AF5,3))), but I am not actually sure what I am doing. Thanks. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base clarity on external internal functionality
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 is no longer capable of displaying 'Tables' and their linking? No, it means that it is dependent on the drivers that interface with the db to be precise about what they actually support (keys, constraints, referential integrity, etc). Does this mean that 'Macro' commands no longer apply? Absolutely not, macros work on UI elements, preparedStatement objects, resultSets, rowSets, etc, in fact anything within LibreOffice's API and the corresponding db context. An example, you can set up an standalone Writer form that links to a mysql backend database, and have buttons on it that execute prepared statements or queries and then display the results or alter the content of the form/subform, etc. Is there a chart that can add some clarity as to what is functional and isn't between the two? Not that I know of, as it is dependent on the backend db / db driver configuration. For example, the general rule that binary large objects, other than images, can not be displayed via the default Base forms UI components prevails. Anything else requires programming via macro or scripting magic. A very useful book in this regard, available from Amazon, is Roberto Benitez' book to programming with OpenOffice.org Base. Another useful reference is Andrew Pitonyak's manual. These references give insights and code on manipulating the Base UI in ways akin to what is provided by default in Access, or FileMaker, Approach, etc. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base questions
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 interpretation of 'internal' would be that it is within it's own folder and 'external' would be that the actual database is somewhere else during set-up. The default Base file, with an ODB extension, is a container (zipped). Within that container are files and subfolders, some files describe the structure and content of the database in a form that LibreOffice's embedded hsqldb engine can read when you load the file. The subfolders generally relate to other aspects of the ODB file, such as macros, forms, reports, report definitions (XML), query definitions, etc) When you reference an outside db backend, everything but the actual database content and data defintitions get stored in the ODB file, with simply a reference to that content and how to access it being stored in the ODB. In other words, your data is actually safe somewhere else (on a server, on another part of your hard disk, etc) Utimately, for as long your actual database data is somewhere else, you could screw up your ODB file and still not affect your data. However, you would potentially lose all of your query/report definitions, your macros, forms, etc. Note that forms do not have to be stored within the ODB, they can be stored as standalone documents. The same goes for reports, although the report definitions are always stored within the ODB file (unless someone has found a way to get around that). Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base clarity on external internal functionality
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 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? Does this mean that 'Macro' commands no longer apply? Is there a chart that can add some clarity as to what is functional and isn't between the two? Thanks in advance. Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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 placed inside the same folder. To the user, the interpretation of 'internal' would be that it is within it's own folder and 'external' would be that the actual database is somewhere else during set-up. The default Base file, with an ODB extension, is a container (zipped). Within that container are files and subfolders, some files describe the structure and content of the database in a form that LibreOffice's embedded hsqldb engine can read when you load the file. The subfolders generally relate to other aspects of the ODB file, such as macros, forms, reports, report definitions (XML), query definitions, etc) When you reference an outside db backend, everything but the actual database content and data defintitions get stored in the ODB file, with simply a reference to that content and how to access it being stored in the ODB. In other words, your data is actually safe somewhere else (on a server, on another part of your hard disk, etc) Utimately, for as long your actual database data is somewhere else, you could screw up your ODB file and still not affect your data. However, you would potentially lose all of your query/report definitions, your macros, forms, etc. Note that forms do not have to be stored within the ODB, they can be stored as standalone documents. The same goes for reports, although the report definitions are always stored within the ODB file (unless someone has found a way to get around that). Alex 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 expose the user to data loss between saves. The other issue is that LO Base uses an embedded database, which means that the data files and the GUI, reports, etc. are combined into one file that can be corrupted. The suggestion is to use a split system where the data files are separate from the other files. Correct? If so, at best, the data may be a little safer, but forms, queries, etc. can still be corrupted. A database like MySQL and mariadb cache the updates and then write them to disk every 1/2 to full second (or however configured). Seems like a good idea. So I come back to my suggestion earlier today - LO Base needs to give the user the opportunity to specify what they want - RAM or file based, single file or multiple files. Would that be difficult to do? Yes, I know that you can link to other back-end db's, but LO Base doesn't create those db's - that has to be done ahead of time by someone that is skilled with the particular db. Correct? Dave, -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base questions
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 expose the user to data loss between saves. There are two components here: the DB engine (eg HSQLDB) and the front-end (ie LO-Base). In embedded mode, running Base stats the DB engine and opens the wanted database. In this situation, yes, database updates are set to ram until the database is saved, either voluntarily or when Base is shut down. And yes, any flaw in *any* piece of software running while Base and the DB also run, can create DB loss. The other issue is that LO Base uses an embedded database, which means that the data files and the GUI, reports, etc. are combined into one file that can be corrupted. The suggestion is to use a split system where the data files are separate from the other files. Correct? If so, at best, the data may be a little safer, but forms, queries, etc. can still be corrupted. Yes, this is what split-mode is all about. A database like MySQL and mariadb cache the updates and then write them to disk every 1/2 to full second (or however configured). Seems like a good idea. So I come back to my suggestion earlier today - LO Base needs to give the user the opportunity to specify what they want - RAM or file based, single file or multiple files. Would that be difficult to do? WRT HSQL it's just a couple settings away: (1) in LO global settings (Tools/Options, Advanced page) specify where the external HSQLDB engine is stored (Class Path button) - Add archive: points to the hsqldb.jar - Add Folder: points to the directory where hsqldb.jar is stored (lib dir) Then make sure to check the test button These setings are stored in the user profile /config directory. (2) in Base, DB creation wizard - at step 1 : select JDBC database - at step 2 : specify the DB address settings Datasource URL : hsqldb:file:d:/somedir/mybase/basetest;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false JDBC Driver class: org.hsqldb.jdbcDriver Test with the Test Class button. These settings are stored in the RegistryModifications.xcu file. To me, the main difficulty lies in the backup of these settings (config dir and RegistryModifications.xcu and the .odb file), so that you may change PC without hassle. Unless I'm missing the obvious, it is not the case currently. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] UK Government adopts Open Document Format
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 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 james.kn...@rogers.com wrote: 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: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Sum of multiple cells substring
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,5FOT1FVOT2FF VOT3
I would have another column with the total sum of OT:
AlanOT0,5FOT1FVOT2FF VOT3 6,5
(OT3+OT2+OT1+OT0.5)
Suppose those eleven items are cells A1 to K1. In the result cell, enter
=SUM(IF(LEFT(B1:K1,2)=OT,VALUE(MID(B1:K1,3,99)),0))
But don't press Enter or click the green tick mark; instead press
Ctrl+Shift+Enter to render it an array formula. You will see that the
entire formula displayed in the Input Line has been surrounded by
braces - { } - but note that you cannot achieve the same result by
typing these yourself.
You will presumably need to copy this formula down a column. If so,
you appear to be able to achieve the correct result by copying the
formula from the first cell and pasting it into others (even
wholesale) or by using Edit | Fill, but not by dragging the fill handle.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Intermittent Calc Issues
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 things now and then. I was creating an elaborate spreadsheet file consisting of 13 worksheets to record my wife's and mine different Roth and Traditional IRAs vested in Mutual Funds. Each worksheet shows the DATE, transaction DESCRIPTION, DEBIT, CREDIT, share PRICE, SHAREs obtained, share BALANCE, $ AMOUNT (share PRICE * share BALANCE), percentage of gain or loss both yearly and per investment, all in separate columns. 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 arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As I said, these issues are very inconsistent. They may not happen for days, then after a few days, they may happen several times, then intermittent, or not at all. This all started in early July. I ran anti-malware scanners, anti-virus scanners, cleaned the registry, and defragged. I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. I have installed some new software, some with start up files. Those software programs were not really all that important, so I deleted them, the registry entries, and any start up files. However, the IRA spreadsheet file is all done, and I don't know if I'll still have those issue until I start another spreadsheet project. This is all done on an HP Probook 440 G1 14 notebook with a Jan 2014 UEFI, an Intel dual core I3 2.4Ghz Haswell, 4GB DDR3L, and Windows 7 64 bit home premium purchased late last March. My questions are: Has anyone else experienced the same? Does my reasoning sound feasible? Any ideas? Greg --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Intermittent Calc Issues
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 arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As your problems seem to arise while using the keyboard (the mouse symptom seems related to the shift key being seen as pressed), I'm wondering if your laptop keyboard has no problem. Did you test LO and your spreadsheet on some other hardware? -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
