[libreoffice-users] LO Base/MySQL questions
Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Thanks for any help 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: What do you think of AndrOpenOffice? (nm)
Le 27/12/2013 21:32, Jeffrey Deutsch a écrit : I found the Base module to be fairly unstable, as in, it crashes a lot, but the other modules are fairly usable on both my Nexus 7 and Asus Transformer Pad, the advantage of the latter being that I have a real keyboard ;-) The UI does need some work though, but kudos to the people (person) who managed to get this to run in the first place. I didn't have any problem navigating to other folders to save documents, I can also confirm that by default, Writer files at least are password protected (haven't checked out Calc files yet), and I have to remember to turn this off when I do my testing. 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] how to tell m$ about ods formula behaviour failure
On 07/02/2014, Dennis E. Hamilton dennis.hamil...@acm.org wrote: I no longer follow these lists, so I'm of limited help. If gnumeric produces an ods file, Excel 2013 should attempt to read it. However, the format you gave as an example is not ODF and I am doubtful. I don't have gnumeric, so I can't check that case. Correct, the output provided previously was the native format; gnumeric was one of the first spreadsheets to use xml as a native file format. Below is an extract of the gnumeric output when the spreadsheet is saved as gnumeric ods (without foreign elements, a gnumeric option): table:table table:name=Sheet1 table:style-name=ta-v-lr table:table-column table:default-cell-style-name=ACE-0x8a4a468 table:style-name=ACOL-0/ table:table-column table:default-cell-style-name=ACE-0x8a4a468 table:style-name=ACOL-0 table:number-columns-repeated=255/ table:table-row table:style-name=AROW-0 table:table-cell table:style-name=ACE-0x8a4a468 office:value-type=float office:value=3 text:p3/text:p /table:table-cell table:table-cell table:number-columns-repeated=255 table:style-name=ACE-0x8a4a468/ /table:table-row table:table-row table:style-name=AROW-0 table:table-cell table:style-name=ACE-0x8a4a468 office:value-type=float office:value=5 text:p5/text:p /table:table-cell table:table-cell table:number-columns-repeated=255 table:style-name=ACE-0x8a4a468/ /table:table-row table:table-row table:style-name=AROW-0 table:table-cell table:style-name=ACE-0x8a4a468 office:value-type=float office:value=3 text:p3/text:p /table:table-cell table:table-cell table:number-columns-repeated=255 table:style-name=ACE-0x8a4a468/ /table:table-row table:table-row table:style-name=AROW-0 table:table-cell table:style-name=ACE-0x8a4a468 table:formula=of:=([.A1]*[.A2])/[.A3] office:value-type=float office:value=5 text:p5/text:p /table:table-cell table:table-cell table:number-columns-repeated=255 table:style-name=ACE-0x8a4a468/ /table:table-row table:table-row table:style-name=AROW-0 table:table-cell table:number-columns-repeated=256 table:style-name=ACE-0x8a4a468/ /table:table-row table:table-row table:style-name=AROW-0 table:number-rows-repeated=65531 table:table-cell table:number-columns-repeated=256 table:style-name=ACE-0x8a4a468/ /table:table-row /table:table Similarly, gnumeric output ods with foreign elements: table:table table:name=Sheet1 table:style-name=ta-v-lr table:table-column table:default-cell-style-name=ACE-0x9882780 table:style-name=ACOL-0/ table:table-column table:default-cell-style-name=ACE-0x9882780 table:style-name=ACOL-0 table:number-columns-repeated=255/ table:table-row table:style-name=AROW-0 table:table-cell table:style-name=ACE-0x9882780 office:value-type=float office:value=3 text:p3/text:p /table:table-cell table:table-cell table:number-columns-repeated=255 table:style-name=ACE-0x9882780/ /table:table-row table:table-row table:style-name=AROW-0 table:table-cell table:style-name=ACE-0x9882780 office:value-type=float office:value=5 text:p5/text:p /table:table-cell table:table-cell table:number-columns-repeated=255 table:style-name=ACE-0x9882780/ /table:table-row table:table-row table:style-name=AROW-0
Re: [libreoffice-users] L.O. 4.0.5 pb enregistrement fichier
Le 7 février 2014 10:14, emmauel73 emmanuel.bel...@savoie.gouv.fr a écrit : Bonjour, je viens de déplacer, via l'utilitaire robotcopy, des fichiers vers un nouveau serveur de fichier. L'ouverture des fichiers Libre Office sur ce nouveau serveur ne pose pas de problème, en revanche il m'est impossible de les sauvegarder après modifications. J'obtiens un message du type 'erreur lors de l'enregistrement du document . Accès refusé. Je précise que les droits utlisateurs sont correctes et que si je sauvegarde le fichier sous un autre nom au même endroit cela fonctionne. Enfin jusqu'à la prochaine sauvegarde car le problème se répète. Seule solution que j'ai trouvé pour l'instant : ouvrir un nouveau fichier et effectuer un copier coller. Là ca fonctionne correctement. Mais cette solution n'est pas satisfaisante étant donnée le nombre de fichier LO. J'ajoute que le problème n'existe pas sur des fichiers autres que LO (MSOffice, PDF, txt ) Si quelqu'un à une idée, je suis preneur. Comment les fichiers sont-ils accessibles ? Il est possible qu'il y ait un problème entre un partage réseau et la façon dont LO verrouille les fichiers ouverts. -- 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] LO Base/MySQL questions
On 02/07/2014 02:38 AM, Ian Whitfield wrote: Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) The advantage of HSQL is that it creates a single file and you do not need to run a database daemon in the background (I am assuming that the MySQL connector uses that rather than knowing how to read the MySQL files directly). In other words, it does serve a need. The disadvantage of HSQL, (speculation, so assume half of what I am about to say is wrong) is that it sounds less stable, if you crash Base, it is more likely to lose data, and everything stays in memory. Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) Are you using Windows or Linux? Try looking under something like: C:\Program Files\MySQL\MySQL Server #.#\my.ini Look in that file for the basedir and datadir variables. And now I see I need to run. 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Thanks for any help IanW Pretoria RSA. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] LO Base/MySQL questions
On 02/07/2014 08:40 AM, Andrew Douglas Pitonyak wrote: On 02/07/2014 02:38 AM, Ian Whitfield wrote: Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) The advantage of HSQL is that it creates a single file and you do not need to run a database daemon in the background (I am assuming that the MySQL connector uses that rather than knowing how to read the MySQL files directly). In other words, it does serve a need. The disadvantage of HSQL, (speculation, so assume half of what I am about to say is wrong) is that it sounds less stable, if you crash Base, it is more likely to lose data, and everything stays in memory. I think the other reason for using HSQL is it is easier to use as an embedded database while MySQL/MariaDB, PostgreSQL, etc. require the separate install of the database. The others are designed as stand-alone databases that one can connect to using a variety of tools. Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) Are you using Windows or Linux? Try looking under something like: C:\Program Files\MySQL\MySQL Server #.#\my.ini Look in that file for the basedir and datadir variables. And now I see I need to run. 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Storing the link to the photo should make the database query run faster because the text string is orders of magnitude smaller than the photo. One problem is one must be very carefully about naming the photos. Thanks for any help IanW Pretoria RSA. -- Jay Lozier jsloz...@gmail.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] LO Base/MySQL questions
Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again -- 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] LO Base/MySQL questions
Hello, On 2/7/2014 9:07 AM, Ian Whitfield wrote: Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 Do you know the path of the installation directory for MySQL? There should be a my.cnf file somewhere in it. If you can't find it, you can run sudo find / -name my.cnf in your terminal. Once you find the path, open the file. You can run sudo cat /path/to/my.cnf (where /path/to/my.cnf is the path you found earlier to your my.cnf file) in your terminal. Once opened, you should find a key called datadir, which has the location of the data directory for MySQL. However, MySQL data usually has to be read by the server itself, since the data cannot be gathered easily. You could just execute the SQL query SELECT * FROM database with database being the database name. You could move the data directory to somewhere in /home (like you asked) and change the datadir in my.cnf. I don't know if you could move your database to another server; maybe if the MySQL version was the same, you could the data directory, but there are other files that might have to be copied. Even transferring to a server with another operating system could be a difficult task. A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again Regards, xmlhttprequest.o...@gmail.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] LO Base/MySQL questions
On 02/07/2014 09:07 AM, Ian Whitfield wrote: Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again Ian, I do not know if HSQL is only intended for prototyping and thus is not suitable for production work. I would say as a MySQL/MariaDB user is that HSQL is probably intended for lighter production work where a small office needs a database. In this scenario the data requirements are modest, maybe a couple GB of data, but their data is complex enough to need the querying features of a relational database. -- Jay Lozier jsloz...@gmail.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
[libreoffice-users] Autoupdate formula result in Calc cell in Impress
We want an Impress presentation to run on a continuous loop (24/7). We have one page where we would like to count the number of days from a specific date. How can I do this without having to edit the object every day? Best Regards, Justin Barker Contractor TEMA - Production Engineering +1.859.372.2582 -- 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] LO and Coreldraw
I had a number of files in CorelDraw format (.cdr) which I had opened and edited in LO. I then saved these as .odg files. This worked fine until I installed LO 4.2. Since then I have not been able to open either CorelDraw files nor LO files converted from CorelDraw. LO tries to open the file and then gives me the error message that LO has stopped working and then shuts down. Can anyone tell me if this is a bug in 4.2 or if 4.2 has specifically been designed not to work with these files. Thanks, Paddy -- 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] LO Base/MySQL questions
Hello, This instability of HSQL is worrying when using the same database year after year, e.g. an address or a bibliographic database. For my part, all my data remain in separate external tables in dbf format, linked to Base. Reasons are: - compatibility with many programmes and readability of old archives, even in case of change of database program ; - stability in the long run; - format compatible with GIS software; - when the tables are not merged in one file, the loss is limited when one of the tables gets corrupted. The main drawback is the impossibility to make a relational database. In fact, the good integration of the office suite with a database was one of the main reason's why I began to use OO in 2007 or 2008. To my great satisfaction indeed: it works very well, except for two instances, several years ago, where the dbf file got corrupted (luckily, recovery from backups was easy). Since then it works fine without any failure (except, rarely, for some data in memo fields, which can lose the right connection with other data (dbt file connection to dbf file)). Nevertheless, the impossibility of making relations between tables is rather frustrating. One solution is to migrate to a mySQL/Base or preferably Postgresql (because of PostGIS). It's my intention but I fear to waste a lot of time in migrating. What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Paul Lens Le 7/02/2014 15:07, Ian Whitfield a écrit : Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again -- 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] LO Base/MySQL questions
On 02/07/2014 10:29 AM, Lens Paul wrote: Hello, This instability of HSQL is worrying when using the same database year after year, e.g. an address or a bibliographic database. For my part, all my data remain in separate external tables in dbf format, linked to Base. Reasons are: - compatibility with many programmes and readability of old archives, even in case of change of database program ; - stability in the long run; - format compatible with GIS software; - when the tables are not merged in one file, the loss is limited when one of the tables gets corrupted. The main drawback is the impossibility to make a relational database. In fact, the good integration of the office suite with a database was one of the main reason's why I began to use OO in 2007 or 2008. To my great satisfaction indeed: it works very well, except for two instances, several years ago, where the dbf file got corrupted (luckily, recovery from backups was easy). Since then it works fine without any failure (except, rarely, for some data in memo fields, which can lose the right connection with other data (dbt file connection to dbf file)). Nevertheless, the impossibility of making relations between tables is rather frustrating. One solution is to migrate to a mySQL/Base or preferably Postgresql (because of PostGIS). It's my intention but I fear to waste a lot of time in migrating. What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Paul Lens Paul PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of MySQL and many Linux distros install it instead of MySQL. Both can be used as a single user database. IMHO MariaDB is easier to use in a single user environment. With both you can use Base or database specific GUI (pgAdmin, MySQL Workbench). If the data can be exported to csv files migrating should not be difficult, only time consuming. Jay Le 7/02/2014 15:07, Ian Whitfield a écrit : Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again -- Jay Lozier jsloz...@gmail.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
[libreoffice-users] Re: L.O. 4.0.5 pb enregistrement fichier
les fichiers sont accessibles via un lecteur réseau monté par GPO \\nom du serveur\partage$\ je viens d'essayer de puger le profil libre office mais sans résultat. -- View this message in context: http://nabble.documentfoundation.org/L-O-4-0-5-pb-enregistrement-fichier-tp4095992p4096047.html Sent from the Users mailing list archive at Nabble.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] LO Base/MySQL questions
Hi :) A quick back of an envelope risk-analysis might suggest that although the effects can be fairly devastating the likelihood of that occurring is fairly low so it might be acceptable. It might be something like that which led Ian's MySql expert to say it was fine only for proto-typing, or it might be that the expert needs people to all move to MySql and has a sales-pitch against each different type of other non-MySql program. The argument against MariaDb might be that it doesn't work on Macs. The LO marketing team keep insisting on pretending that the internal database is ok. Most of the rest of us seem to have to pick up the pieces when/if that goes wrong so we seem to generally advise people to move to an external back-end asap (within reason). However it's very rare that people do run into the problem so maybe it is being over-stated. Plus, how hard can it be to back-up a single file! On the other hand the effects are TOO devastating and far beyond what most of us on this list would find acceptable Just to add 2 extra layers of complexity 1. the internal (embedded) database 'back-end' is apparently likely to be switched from Hsql to something else 'soon'. 2. Hsql is a separate 3rd party project and it's possible to download and install their latest version on 'your computer' (or server or anything) and use that in much the same way you use any other external back-end. Apparently the only reason the the internal back-end is sometimes unstable is because Sun paid-devs insisted on locking in a now ancient version and they heavily tweaked it. Apparently this was fine back in the day but nowadays means that the internal back-end is. Also apparently when the neweruntweaked versions of Hsql are being used as an external back-end then it's quite excellent and very stable. So i don't think it's really fair to blame Hsql. It's be a bit like saying that OOo 1.0 is a bit ancient and not great nowadays. Regards from Tom :) On 7 February 2014 15:44, Jay Lozier jsloz...@gmail.com wrote: On 02/07/2014 10:29 AM, Lens Paul wrote: Hello, This instability of HSQL is worrying when using the same database year after year, e.g. an address or a bibliographic database. For my part, all my data remain in separate external tables in dbf format, linked to Base. Reasons are: - compatibility with many programmes and readability of old archives, even in case of change of database program ; - stability in the long run; - format compatible with GIS software; - when the tables are not merged in one file, the loss is limited when one of the tables gets corrupted. The main drawback is the impossibility to make a relational database. In fact, the good integration of the office suite with a database was one of the main reason's why I began to use OO in 2007 or 2008. To my great satisfaction indeed: it works very well, except for two instances, several years ago, where the dbf file got corrupted (luckily, recovery from backups was easy). Since then it works fine without any failure (except, rarely, for some data in memo fields, which can lose the right connection with other data (dbt file connection to dbf file)). Nevertheless, the impossibility of making relations between tables is rather frustrating. One solution is to migrate to a mySQL/Base or preferably Postgresql (because of PostGIS). It's my intention but I fear to waste a lot of time in migrating. What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Paul Lens Paul PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of MySQL and many Linux distros install it instead of MySQL. Both can be used as a single user database. IMHO MariaDB is easier to use in a single user environment. With both you can use Base or database specific GUI (pgAdmin, MySQL Workbench). If the data can be exported to csv files migrating should not be difficult, only time consuming. Jay Le 7/02/2014 15:07, Ian Whitfield a écrit : Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again -- Jay Lozier jsloz...@gmail.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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
[libreoffice-users] Re: LO Base/MySQL questions
On 07/02/2014 16:29, Lens Paul wrote: What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Play around with the new experimental integrated Firebird db in LO 4.2. You need to switch on the experimental features to be able to create tables, etc. Be warned, it is still very much in its infancy and lots of useful things that a user would want to do are not yet supported by the user interface. However, Firebird is as solid a db engine as they come. 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: L.O. 4.0.5 pb enregistrement fichier
2014-02-07 emmanuel73 emmanuel.bel...@savoie.gouv.fr: les fichiers sont accessibles via un lecteur réseau monté par GPO \\nom du serveur\partage$\ je viens d'essayer de puger le profil libre office mais sans résultat. Un vieux problème similaire, dont je ne sais pas si il est résolu, était lié à l'extension pour l'explorateur. Vous pouvez essayer l'installation sans l'extension shell pour voir. -- 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: LO Base/MySQL questions
On 07/02/2014 08:38, Ian Whitfield wrote: Hi Ian, For some reason, your question shows up in Thunderbird in the thread about Andropenoffice, hoping that you haven't hijacked it... 1) Where does MySQL store the Database? (I think it's in the root somewhere) It is usually (but not always) stored somewhere in /var on a Linux system. On Ubuntu based systems, it seems to be located in /var/lib/mysql 2) Is it easy to move it into the /home directory? If you know how to : - change your my.cnf - change the ownership and privileges of the new directory to correspond to those of the user mysql process (i.e. the user that runs the mysqld daemon) 3) Where do I find the LO front-end form? In your ODB file. Unzip it and have a look, it'll be in there in a subdirectory. 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? No, mysql doesn't work as a single file that you just copy from one place to another. It takes more work than that. Use a dump (sql file), or setup the new mysql server on the second machine to be a replicant of the first - this presupposes that the two machines can be connected together over the internet or a local LAN, but if you have two machines on the same subnet, better to just allow the second machine to access your first machine's mysql server. Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Only possible with a macro that takes the location and name of the image file stored in the database as a string, and then convert that to a link for you on your form and provide some way of displaying it (e.g. shell function to an outside viewer or loading the file into an image control). Provided that you don't go and change the name of the file or its location, the image will always be up to date even if you modify the image itself. 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] LO and Coreldraw
Hi :) I think it's probably best to 1. post a bug-report about it and leave it to QA (bug squad) to triage and 2. revert your own system to 4.1.4 or something or install the more stable-branch alongside the feature-rich branch. It might take us a while before we respond to something like this on this mailing-list but it was kind of you to try us first. Thanks and regards from Tom :) On 7 February 2014 15:09, Pat Brown mistyha...@gmail.com wrote: I had a number of files in CorelDraw format (.cdr) which I had opened and edited in LO. I then saved these as .odg files. This worked fine until I installed LO 4.2. Since then I have not been able to open either CorelDraw files nor LO files converted from CorelDraw. LO tries to open the file and then gives me the error message that LO has stopped working and then shuts down. Can anyone tell me if this is a bug in 4.2 or if 4.2 has specifically been designed not to work with these files. Thanks, Paddy -- 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: L.O. 4.0.5 pb enregistrement fichier
Hi :) I also often find that LibreOffice doesn't let me save over the top of files stored on our network file-shares. It only does seem to work if using the same computer. When i go to a different machine i use that as an opportunity to add/upodate a version number to the end of the document name and move the old version into a back-ups folder. It seems to work quite well but maybe because we only have a small number of files active at any particular time. It is probably something to do with a ~lockfile in the network folder or in the backups folder inside the User Profile of LO on whichever machine you happen to be trying to save from. Sorry i can't write that in French! My translation tool is stuck in English! :( Regards from Tom :) On 7 February 2014 13:29, emmanuel73 emmanuel.bel...@savoie.gouv.fr wrote: J'ajoute pour être complet utliser des terminaux leger et terminal service. -- View this message in context: http://nabble.documentfoundation.org/L-O-4-0-5-pb-enregistrement-fichier-tp4095992p4096049.html Sent from the Users mailing list archive at Nabble.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 -- 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: LO and Coreldraw
On 07/02/2014 16:09, Pat Brown wrote: Pat, I had a number of files in CorelDraw format (.cdr) which I had opened and edited in LO. I then saved these as .odg files. This worked fine until I installed LO 4.2. Since then I have not been able to open either CorelDraw files nor LO files converted from CorelDraw. LO tries to open the file and then gives me the error message that LO has stopped working and then shuts down. Can anyone tell me if this is a bug in 4.2 or if 4.2 has specifically been designed not to work with these files. Remove LO 4.2 and go back to a previous version. You're not on Windows or Mac by any chance ? There appears to be an issue with Draw, at least on Windows, and possibly on Mac (to be confirmed). 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: low traffic lately?
Ouch! Who would-a thought my simple apology would start this firestorm? -- Jim Then, would you please consider the pros vs. cons of this list as well as all the users of this list who are seeking help then offering help. Here are more logical steps of top-posting vs. bottom-posting (much has been on this list previously, but ... ... ... ) -- 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] MS Office woes
Just a rant here from someone who is reasonably sophisticated at both LO/OO and MS Office. I've had to use MS Office for work lately, and I've run into a TON of frustrations. Biggest recent frustrations: 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. And if I get a formula wrong, it won't let me leave it in the cell for later troubleshooting (with a #NA value as LO/OO does). I have to either fix it or erase it. But what if I can't fix it before I have to move on to other things? 2. The smart text select system, which tries to anticipate what you want to select, forces me to select the period of the previous sentence when trying to move a sentence to a new location. I used to be able to de-select the period by selecting the text from the end to the beginning, then moving the cursor back off of the period toward the sentence I want to move. Not working right now. 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. -- Carl Paulsen Dover, NH 03820 -- 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] All of the messages in Nabble are suddenly going into the AndrOpen Office thread!
null wrote: Hello, Well, if this appears as a separate subject (in the Users archive on Nabble), then the problem was fixed. It seems as if all of the posts (even different subjects and conversations) are going into the What do you think of AndrOpen Office? thread on Nabble. A conversation about LibreOffice Base and MySQL (with a different subject) went into the AndrOpen Office thread on Nabble. Is this able to be fixed? I don't know if it's the case here, but people do sometimes reply to an existing email to the list and just change the subject line (presumably to save looking up the address for the list). That isn't enough to make it a different thread - there are separate headers in the email which link messages into threads - so the new message shows up as part of the original thread. Another disadvantage of doing this is that some other people use mail clients or news readers which they can set to automatically ignore any further messages in threads they're not interested in or can't help with. So those people wouldn't see the messages asking about a different problem in an existing thread, when they might otherwise have been able to help with that new problem. So it can be in the asker's best interest to create a new thread rather than replying in an existing one. To do that, they need to create a completely new email and send it to the list address (users AT global.libreoffice.org in this case). Mark. -- 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] All of the messages in Nabble are suddenly going into the AndrOpen Office thread!
You said / Você disse: I don't know if it's the case here, but people do sometimes reply to an existing email to the list and just change the subject line (presumably to save looking up the address for the list). That isn't enough to make it a different thread - there are separate headers in the email which link messages into threads - so the new message shows up as part of the original thread. Mark. I found this out the hard way. Went to nabble to do some searching, and noticed that my email discussion, with which I'd done exactly as you mentioned, was included in the previous subject discussion. *Sigh* -- J. Randal Matheny • http://randal.us/ -- 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] What do you think of AndrOpenOffice?
Why isn't there a libreoffice version ??? -- -- 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] What do you think of AndrOpenOffice?
This site seems to explain the difference - http://liliputing.com/2013/12/andropen-office-is-a-full-office-suite-for-android-based-on-apache-openoffice.html From this, I would guess these are for different machines - LO for PCs and this, AndrOO, for those smaller text things ;-) FWIW - here's my 2cent's worth - I sure hope PCs remain, because I would never be able to text ... or know which acronym was what ... ... ... I like the keyboard; I find it hard enough to touch the keys on the cell phone (nails get in the way ;-) From: Daniel dan...@onvol.net Date: Fri, Feb 7, 2014 at 1:38 PM Subject: [libreoffice-users] What do you think of AndrOpenOffice? To: users@global.libreoffice.org Why isn't there a libreoffice version ??? -- 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] MS Office woes
Can you go into the properties to turn off the auto-fills? - that's always been my solution. [see further comments interspersed below] From: Carl Paulsen carlpaul...@comcast.net Date: Fri, Feb 7, 2014 at 1:04 PM Subject: [libreoffice-users] MS Office woes To: users@global.libreoffice.org users@global.libreoffice.org Just a rant here from someone who is reasonably sophisticated at both LO/OO and MS Office. I've had to use MS Office for work lately, and I've run into a TON of frustrations. Biggest recent frustrations: 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. And if I get a formula wrong, it won't let me leave it in the cell for later troubleshooting (with a #NA value as LO/OO does). I have to either fix it or erase it. But what if I can't fix it before I have to move on to other things? [if you're able to turn off those 'auto's then you should be able to work as you desire] 2. The smart text select system, which tries to anticipate what you want to select, forces me to select the period of the previous sentence when trying to move a sentence to a new location. I used to be able to de-select the period by selecting the text from the end to the beginning, then moving the cursor back off of the period toward the sentence I want to move. Not working right now. [I'm not sure I understand but if you're attempting to copy, or move, then paste elsewhere, then there must be a 'bug' in the system ;-) ] 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? [haven't a clue here] Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. [I agree] -- Carl Paulsen Dover, NH 03820 [very pretty area - especially in the colourful fall] -- 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] LO and Coreldraw
Maybe you should try converting the Corel Draw [which version?] files to the .svg format that Inkscape and other use. Maybe LO 4.2 can open them. I am slowly converting my Corel Draw 11 files to .svg, since I use Ubuntu and Inkscape now. Have to open up an older laptop to run Corel Draw 11 and Inkscape [Win7]. Yes, revert back to 4.1.4, since 4.2.0 is the first of the line and may have a lot of bugs in it, or at least till 4.2.4 comes out. On 02/07/2014 11:14 AM, Tom Davies wrote: Hi :) I think it's probably best to 1. post a bug-report about it and leave it to QA (bug squad) to triage and 2. revert your own system to 4.1.4 or something or install the more stable-branch alongside the feature-rich branch. It might take us a while before we respond to something like this on this mailing-list but it was kind of you to try us first. Thanks and regards from Tom :) On 7 February 2014 15:09, Pat Brown mistyha...@gmail.com wrote: I had a number of files in CorelDraw format (.cdr) which I had opened and edited in LO. I then saved these as .odg files. This worked fine until I installed LO 4.2. Since then I have not been able to open either CorelDraw files nor LO files converted from CorelDraw. LO tries to open the file and then gives me the error message that LO has stopped working and then shuts down. Can anyone tell me if this is a bug in 4.2 or if 4.2 has specifically been designed not to work with these files. Thanks, Paddy -- 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] What do you think of AndrOpenOffice?
On 02/07/2014 02:38 PM, Daniel wrote: Why isn't there a libreoffice version ??? There is some movement to make a LibreOffice for Android, but there are a lot of work in that. Converting to Android means you must strip down a lot of functions OR it will be too large to run on all but the most powerful Android tablets. It is not easy to do the fork to a new platform, like Android, Chrome OS, iPad OS, etc., etc.. You may need to rewrite a whole lot of things. Then there is the on-screen keyboard, vs the attached keyboard. Most Android tablets are used with the on-screen keyboard. I tested a OOo/AOO for Android package on my Android tablet, but it would not work with the on-screen keyboard. -- 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] LO and Coreldraw
Hi Paddy, Pat Brown schrieb: I had a number of files in CorelDraw format (.cdr) which I had opened and edited in LO. I then saved these as .odg files. This worked fine until I installed LO 4.2. Since then I have not been able to open either CorelDraw files nor LO files converted from CorelDraw. LO tries to open the file and then gives me the error message that LO has stopped working and then shuts down. Can anyone tell me if this is a bug in 4.2 or if 4.2 has specifically been designed not to work with these files. There might be two errors mixed. I can open a .cdr file, if I use file open, but not via Insert Image. A crash with Draw have been reported several times, but it is not totally clear, in what environments it crashes. I suggest to go back to version 4.1 till the crash problem is fixed. Kind regards Regina -- 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] All of the messages in Nabble are suddenly going into the AndrOpen Office thread!
Hi :) Another way is to use Forward and then copypaste back to the list. When you notice a thread has been hijacked it's quite a neat way of breaking the new subject out into a new thread of it's own. Regards from Tom :) On 7 February 2014 20:14, J. Randal Matheny ran...@fastmail.fm wrote: You said / Você disse: I don't know if it's the case here, but people do sometimes reply to an existing email to the list and just change the subject line (presumably to save looking up the address for the list). That isn't enough to make it a different thread - there are separate headers in the email which link messages into threads - so the new message shows up as part of the original thread. Mark. I found this out the hard way. Went to nabble to do some searching, and noticed that my email discussion, with which I'd done exactly as you mentioned, was included in the previous subject discussion. *Sigh* -- J. Randal Matheny * http://randal.us/ -- 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] MS Office woes
On 2/7/14 4:24 PM, anne-ology wrote: Can you go into the properties to turn off the auto-fills? - that's always been my solution. True enough. But my point is it's set up to work oddly. 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. [if you're able to turn off those 'auto's then you should be able to work as you desire] Actually, it's more than the auto-fill. The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each time. When they are so terribly long, with many layers of nested functions, losing them is a disaster. Yet Excel prevents you from saving them unless they work. BAH! 2. The smart text select system, [I'm not sure I understand but if you're attempting to copy, or move, then paste elsewhere, then there must be a 'bug' in the system ;-) ] It's a bit specific, and not a bug (it has behaved this way for many releases and is, I think, intended as a function, though it acts more like a bug to me). Yes, it's copy and move. Take this paragraph text and copy to MSO. Then highlight one sentence from before the first letter to the last. It will highlight not just the sentence intended, but also the proceeding period. At least that's how it works with my two-spaces between sentence style (which is the original standard for all typing, which MSO has chosen to dictate is no longer necessary, but which really does help to define sentence and paragraph structure IMHO). 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? [haven't a clue here] Yes, and that's the point. Excel apparently hasn't a clue either. Take a spreadsheet file, save as CSV (the Excel version, not the plain text or Mac version), then open again with Excel. Roughly 50% of the times Excel fails to open these. I don't have a clue what's going on, but it seems like Excel should understand the format that it just saved the file to, so that it can re-open it. Especially for something as simple as a CSV file. Note too that I tried to open another CSV file today, slightly different situation, and Excel chose to ignore the CSV format and open it as if it were one column/field of data, ignoring the commas and quotes delineating the different fields. Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. Dover, NH 03820 [very pretty area - especially in the colourful fall] Indeed! SNOWY and cold now though (which is good if you're willing to get out in it as I am). -- Carl Paulsen Dover, NH 03820 -- 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] MS Office woes
On 02/07/2014 02:04 PM, Carl Paulsen wrote: Just a rant here from someone who is reasonably sophisticated at both LO/OO and MS Office. I've had to use MS Office for work lately, and I've run into a TON of frustrations. Biggest recent frustrations: 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. And if I get a formula wrong, it won't let me leave it in the cell for later troubleshooting (with a #NA value as LO/OO does). I have to either fix it or erase it. But what if I can't fix it before I have to move on to other things? 2. The smart text select system, which tries to anticipate what you want to select, forces me to select the period of the previous sentence when trying to move a sentence to a new location. I used to be able to de-select the period by selecting the text from the end to the beginning, then moving the cursor back off of the period toward the sentence I want to move. Not working right now. 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. Have you seen MS Office 2013 yet? They have removed all the color from the ribbon and menu bars. Everything is white background with quite light gray icons. Even the scroll bar is difficult to find. MS is lost in the concept of making all interfaces look the same on Windows Phone, Surface, and desktop. MS Office 2013 totally ignores the setting and scheme that you have on your desktop. I'm talking serious eye strain. People have been complaining about it for more than a year but MS says they have no plans to change it. LibreOffice is so much better in many respects. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- 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] MS Office woes
Hello, I thought I should add to the rant: If you think Microsoft Excel not being able to import formats it exports is bad, consider Microsoft's disastrous OpenXML standards. Notice I said standards, not standard. .docx, .pptx, and other files with x at the end are stored in the Microsoft OpenXML format. There are three different standards--for the same file type! Depending on the operating system and Microsoft Office version, a different XML standard is used. This can cause a .docx file, for example, not to render correctly in Microsoft Word 2013 if it were saved using 2010; even the operating system is a factor in which XML standard is used. So, sometimes, Microsoft Office can't open Microsoft Office files. Not to mention the extra features that don't work, no one uses, and takes up valuable disk space, such as PDF Reflow. When will Microsoft realize that you can't reflow a PDF? The implementation for each OpenXML standard is nearly 6,000 pages long! So, it really doesn't do what Microsoft said it would do; they made the system so complex to try to force more people to using Microsoft Office, and now their products can't read files. Regards, xmlhttprequest.o...@gmail.com On 2/7/2014 9:10 PM, Carl Paulsen wrote: On 2/7/14 4:24 PM, anne-ology wrote: Can you go into the properties to turn off the auto-fills? - that's always been my solution. True enough. But my point is it's set up to work oddly. 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. [if you're able to turn off those 'auto's then you should be able to work as you desire] Actually, it's more than the auto-fill. The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each time. When they are so terribly long, with many layers of nested functions, losing them is a disaster. Yet Excel prevents you from saving them unless they work. BAH! 2. The smart text select system, [I'm not sure I understand but if you're attempting to copy, or move, then paste elsewhere, then there must be a 'bug' in the system ;-) ] It's a bit specific, and not a bug (it has behaved this way for many releases and is, I think, intended as a function, though it acts more like a bug to me). Yes, it's copy and move. Take this paragraph text and copy to MSO. Then highlight one sentence from before the first letter to the last. It will highlight not just the sentence intended, but also the proceeding period. At least that's how it works with my two-spaces between sentence style (which is the original standard for all typing, which MSO has chosen to dictate is no longer necessary, but which really does help to define sentence and paragraph structure IMHO). 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? [haven't a clue here] Yes, and that's the point. Excel apparently hasn't a clue either. Take a spreadsheet file, save as CSV (the Excel version, not the plain text or Mac version), then open again with Excel. Roughly 50% of the times Excel fails to open these. I don't have a clue what's going on, but it seems like Excel should understand the format that it just saved the file to, so that it can re-open it. Especially for something as simple as a CSV file. Note too that I tried to open another CSV file today, slightly different situation, and Excel chose to ignore the CSV format and open it as if it were one column/field of data, ignoring the commas and quotes delineating the different fields. Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. Dover, NH 03820 [very pretty area - especially in the colourful fall] Indeed! SNOWY and cold now though (which is good if you're willing to get out in it as I am). -- 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] MS Office woes
Mark LaPierre wrote: MS is lost in the concept of making all interfaces look the same on Windows Phone, Surface, and desktop. MS Office 2013 totally ignores the setting and scheme that you have on your desktop. I'm talking serious eye strain. People have been complaining about it for more than a year but MS says they have no plans to change it. I guess they forgot that some people, with poor vision, need high contrast to see things. My vision is fine, but I find some people have no concept of making things readable. For example I have seen grey text on light blue background that was a real struggle to read. -- 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] MS Office woes
On 2/7/2014 9:10 PM, Carl Paulsen wrote: The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each time. When they are so terribly long, with many layers of nested functions, losing them is a disaster. Yet Excel prevents you from saving them unless they work. BAH! I have no experience with M$O specifically, and have no interest in making excuses for its failings, but with those s.sheets that I do use, all you have to do in this situation is put a quote at the start of the formula, thereby making it text. The formula should then be preserved as text, and can be saved as such, until you want to work on it again; removing the quote makes it back into formula. Isn't that a reasonable work-around for their unreasonable default action? -- 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] MS Office woes
OK, to this and other recent posts, please note that my intent wasn't to open a rant-fest. I have found myself wondering about the claims about file structure being a problem even for MSO itself. My original post was intended to provide one example of a case where Excel saved a specific file but then couldn't re-open it without throwing a warning (unusual enough that some users might well panic about it). That plus a few other specific issues I've encountered that make me like LO/OO even more than I did before. While I've read about the issue of the OpenXML standard issues, I hadn't experienced it yet, nor have I read of specific cases where someone had that experience (and I don't mean second hand or less). If anyone wants to add to this, may I humbly suggest you provide specific examples of issues _you've_ had (not that you've read or heard about). E.g., I saved a file as CSV, and within 5 minutes tried to reopen it but Excel failed to do so. It gave me the following error: That provides a specific situation that others can test. The more specific the better. But to say the open XML standard changes so that Excel can't open it just doesn't translate to the general user, even if it IS true. Again, specific examples help. Carl On 2/7/14 10:47 PM, null wrote: Hello, I thought I should add to the rant: If you think Microsoft Excel not being able to import formats it exports is bad, consider Microsoft's disastrous OpenXML standards. Notice I said standards, not standard. .docx, .pptx, and other files with x at the end are stored in the Microsoft OpenXML format. There are three different standards--for the same file type! Depending on the operating system and Microsoft Office version, a different XML standard is used. This can cause a .docx file, for example, not to render correctly in Microsoft Word 2013 if it were saved using 2010; even the operating system is a factor in which XML standard is used. So, sometimes, Microsoft Office can't open Microsoft Office files. Not to mention the extra features that don't work, no one uses, and takes up valuable disk space, such as PDF Reflow. When will Microsoft realize that you can't reflow a PDF? The implementation for each OpenXML standard is nearly 6,000 pages long! So, it really doesn't do what Microsoft said it would do; they made the system so complex to try to force more people to using Microsoft Office, and now their products can't read files. Regards, xmlhttprequest.o...@gmail.com -- Carl Paulsen Dover, NH 03820 -- 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] MS Office woes
I suppose you're right. With some work I could have found a workaround, and I appreciate your idea. My issue is much more about the way MSO is set up by default, and changes to that are not especially apparent. But your point is well taken. Carl On 2/7/14 11:26 PM, marianne-x wrote: On 2/7/2014 9:10 PM, Carl Paulsen wrote: The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each time. When they are so terribly long, with many layers of nested functions, losing them is a disaster. Yet Excel prevents you from saving them unless they work. BAH! I have no experience with M$O specifically, and have no interest in making excuses for its failings, but with those s.sheets that I do use, all you have to do in this situation is put a quote at the start of the formula, thereby making it text. The formula should then be preserved as text, and can be saved as such, until you want to work on it again; removing the quote makes it back into formula. Isn't that a reasonable work-around for their unreasonable default action? -- Carl Paulsen Dover, NH 03820 -- 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
