Re: [libreoffice-users] Sorting a MySQL Database
Hi Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to the right of the Sort field 6. Then you can choose your sort fields, (LastName and FirstName) 7. Click OK 8. Close Form Properties 9. Save the Form This works with my H2 database. Hopefully it is the same for your MySQL. Thanks for your reply - This is exactly what I was looking for!! BUT I open the Form in Edit Mode and Right-Click on it and there is NO Form in the options that come up!! My LO is version 3.6.5.2 (Build ID: 5b93205) and MySQL is 5.1 thanks anyway 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
Re: [libreoffice-users] Sorting a MySQL Database
Hi Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to the right of the Sort field 6. Then you can choose your sort fields, (LastName and FirstName) 7. Click OK 8. Close Form Properties 9. Save the Form This works with my H2 database. Hopefully it is the same for your MySQL. Just checked on my OLD Base / HSQL Database and there is NO Form option there either - so I guess this is an option only with your H2 engine (??) 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
Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
Dear Marlosv thanks for the reply. Enclosed is sending the file from these problems. I look forward to technical comments from the thing. (I have not yet thrown from my building, but customers may feel happy to push me from the brink, if he does not finish the job :-) ) -- Please : Some Notes details for the use of the file: It is a complete accounting double entry for businesses. The worksheets are to be observed: PROSPETTO CODICI (which contains 2 PivotTable): one for a CODICI DARE and one for CODICI AVERE The origin of the data is in the worksheet PRIMA NOTA. activity 1) If you update the PivotTable CODICI AVERE (red numbers), updating the Codes field disappears and the pivot table does not work. Task 2) If you ask in the Pivot table detail of a code (double click on an amount in AVERE column or DARE column) opens a worksheet regularly with details. If you make the task 1) or 2) in the worksheet named BILANCIO CE columns C (visible column) and F (hidden column) where the functions are written in the cells GETPIVOTDATA refer to 2 Pivot Tables do not contain more results GETPIVOTDATA = function no longer works. Even rewriting the Pivot Tables and rewriting the GETPIVOTDATA function in those cells (the cells before deleting), the function from the results that more has to give. And then the balance is no longer results Oh My God What a disaster! [?] Best Regards. Michele Ras 2013/8/28 mariosv mari...@miguelangel.mobi Hi Michele, can you attach a sample file? No possible do it from your email program, but answering through mail list you can. -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072105.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 -- http://contabilmenteag.wix.com/contabilmenteag-net contabilmenteag@gmail.com contabilment...@hotmail.it Ras Michele Perito Agrario Salita S.Barnaba 24d/18 16136 Genova Ge Tel./Fax.: 010 213059 Tel.Mobile:3201107102 Riservatezza / Confidentiality In ottemperanza al D.Lgs. n. 196 del 30/6/2003 in materia di protezione dei dati personali, le informazioni contenute in questo messaggio sono strettamente riservate ed esclusivamente indirizzate al destinatario indicato (oppure alla persona responsabile di rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso, riproduzione o divulgazione di questo messaggio è vietato. Nel caso in cui aveste ricevuto questo messaggio per errore, vogliate cortesemente avvertire il mittente e distruggere il presente messaggio. According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not the addressee (or responsible for delivery of the message to such person) you are hereby notified that any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited -- 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] Sorting a MySQL Database
Hi Ian, There is another way - 1. After opening your Form in design mode, click on View | Toolbars | and make sure Form Design is ticked 2. On that toolbar, click on Form Navigator (5th from left on my toolbar - it's the one with the 4 point star on it) 3. Right click on your Form name (probably the 2nd item from the top) 4. Choose Properties 5. Continue from point 3 on my first reply If that doesn't work, then someone who uses Forms with MySQL may be able to help you. Noel -- Noel Lodge lodg...@gmail.com On 29 August 2013 17:55, Ian Whitfield whitfi...@telkomsa.net wrote: Hi Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to the right of the Sort field 6. Then you can choose your sort fields, (LastName and FirstName) 7. Click OK 8. Close Form Properties 9. Save the Form This works with my H2 database. Hopefully it is the same for your MySQL. Just checked on my OLD Base / HSQL Database and there is NO Form option there either - so I guess this is an option only with your H2 engine (??) 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: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
Ciao Michele, your attachment has not reached us. To attach a file you can: - register to nabble http://nabble.documentfoundation.org and then going to the right post (mailing list - thread - post; you could find the link in this post's footer); in Nabble's editor there is a More button by clicking on it you can find Upload a file; - use your Dropbox public directory or link the file from the single file share function and give us the simple file link; - use others public web places and give us the simple file link. Hope this help! In addition: have you tried opening and use the sheet on the just released 4.1.1 LibreOffice version? You get the same behavior? http://www.libreoffice.org/download Have a nice day, Carlo -- ing. Carlo Strata - via Botticelli 1/4 30031 Dolo - VE Italia - Italy - tel./fax +39.041.822.0665 cell. +39.347.85.69.824 Skype carlo.strata Google carlo.strata.69 - carlo.str...@tiscali.it PEC: carlo.str...@ingpec.eu - -- ing. Carlo Strata - via Botticelli 1/4 30031 Dolo - VE Italia - Italy - tel./fax +39.041.822.0665 cell. +39.347.85.69.824 skype carlo.strata - carlo.str...@tiscali.it PEC: carlo.str...@ingpec.eu -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072180.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
[libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma
In 4.0 the properties Formula and FormulaLocal give the expected result: cell.Formula = =2.1*2= 4,2 cell.Formula = =2,1*2= #NAME? cell.FormulaLocal = =2,1*2 = 4,2 cell.FormulaLocal = =2.1*2 = #NAME? In 4.1 the both properties Formula and FormulaLocal give the same result: cell.Formula = =2,1*2= 4,2 cell.Formula = =2.1*2= #NAME? cell.FormulaLocal = =2,1*2 = 4,2 cell.FormulaLocal = =2.1*2 = #NAME? Best regards Mindaugas Best regards -- View this message in context: http://nabble.documentfoundation.org/problem-with-formala-inserted-by-macros-when-decimal-separator-is-comma-tp4072059p4072140.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: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?
the birds do it ... the fish do it ... now, the computerists migrate ;-) Does anyone really wish to remain with MSFT?; it's just already programmed into these glorified-typewriter machines ... scary prospect to remove it then install something else -and all alone, nary a soul to even lend a hand ;-) BTW - I thought many of your pubs were called the King's Arms ;-) On Wed, Aug 28, 2013 at 9:44 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Even though this thread went wy off-topic it's ended up being very relevant to a problem many of us have. How to migrate. Given that most people want to stay with MS systems we are a bit stuck in the phase of having to deal with both systems at the same time. Even when the ODF format does become dominant there will probably be a few people still using the ever-changing proprietary format that could disappear any-time at the whim of a single company. It's interesting to hear that Km changed it's base without changing it's size (or may have changed length just a tiny bit that most of us wouldn't have noticed). I quite like the idea of re-measuring a long dead king's arm as it slowly crumbles away but that might be a bit dark for most people! Probably better to just quaff a few ales in the Queens Arms instead. Not sure why so many pubs are called the Queens Arms. Regards from Tom :) From: James Knott james.kn...@rogers.com To: lo LibreOffice users@global.libreoffice.org Sent: Wednesday, 28 August 2013, 15:13 Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? rost52 wrote: The metric system has it is advantage in the factors of 10 or 1/10. I consider this as the reason why most countries adopted the metric system. It was also designed as a logical system, tied to defined physical constants. I recently watched a video about how the new standard for a kilogram was the number of atoms in a precisely measured silicon sphere. The kilometre was originally defined in relation to the distance from the equator to the poles, but is currently determined by the wavelength of light emitted by the kryton-86 items. This shows the metric system is defined in terms of physical constants and not some unmeasurable item such as the length of a long dead king's arm. If a country is serious about a change, than all measures must be provided for a while in both units and after while the old units must disappear. In Canada, when Km and °C came in, there was a switch over date, the road sides had stickers placed over the old speed limit in miles to show in Km. Weather reporting switched to Celsius. As for physical things, there was a date given, where dimensions had to be specified in metric, but this applied to things made after that date and older items could still be sold. However, manufacturers switched production well before that date. The switch over was also phased in, so only one thing changed at a time. -- 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] Download page is inaccesible for me
Hi :) Indeed most of your links don't work. I think the first one did but i wasn't sure. Did you try starting at the main home-page for LibreOffice and navigate from there (or from the downloads page) or where you modifying links that you had used in the past? http://www.libreoffice.org/download Regards from Tom :) From: Julian Yezid Castellanos Pinzón jcastellanospin...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 29 August 2013, 0:05 Subject: [libreoffice-users] Download page is inaccesible for me Hi. I'm trying to download libreoffice 4.1 but no one link is working: http://donate.libreoffice.org/home/dl/deb-x86_64/4.1.0/es/LibreOffice_4.1.0_Linux_x86-64_deb.tar.gz http://download.documentfoundation.org/libreoffice/stable/4.1.0/deb/x86_64/LibreOffice_4.1.0_Linux_x86-64_deb_langpack_es.tar.gz http://download.documentfoundation.org/libreoffice/box/4.1.0/LO-4.1.0_English-NA-DVD_All-Platforms_Multi-Lang_plus-extras.iso Every link i try fail: julian@debian:~$ wget http://download.documentfoundation.org/libreoffice/box/4.1.0/LO-4.1.0_English-NA-DVD_All-Platforms_Multi-Lang_plus-extras.iso --2013-08-28 17:51:16-- http://download.documentfoundation.org/libreoffice/box/4.1.0/LO-4.1.0_English-NA-DVD_All-Platforms_Multi-Lang_plus-extras.iso Resolviendo download.documentfoundation.org (download.documentfoundation.org)... 5.9.148.85, 2a01:4f8:190:3144::2 Conectando con download.documentfoundation.org ( download.documentfoundation.org)[5.9.148.85]:80... falló: Expiró el tiempo de conexión. Conectando con download.documentfoundation.org ( download.documentfoundation.org)[2a01:4f8:190:3144::2]:80... falló: La red es inaccesible. -- Julián Yezid Castellanos Pinzón -- 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: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?
Hi :) Yes, there are a lot of Kings Arms too, i'd kinda forgotten. In Brighton there was one called the Queens Head with it's sign being a painting of Freddy Mercury. Usually the signs are fairly predictable. I saw a Queens Legs once but can't remember where. Actually wrt to removing Windows that is really not necessary at all. It's what the MS world prefer people to do but is absolutely NOT what the OpenSource world recommends. The whole point about using the word migrate is to avoid the idea of switching. Most OpenSource people have a dual-boot (or multi-boot). When they turn on their system they get a boot menu giving a list of the different operating systems on their machine. The commonest is to have 2 options; with one being for Windows and the other being for Mint/Ubuntu/openSuSE/whatever. The usual recommendation from most OpenSource people is to start the migration with the boot-menu defaulting into Windows. Then after some time switch that around making the GnuLinux the default. Almost all my colleagues' machines still default into Windows but i have a few that would default into Ubuntu if their users didn't press the up arrow in time. I give them 10 seconds which is more than enough for most people. I get the impression that MS would rather people switched rather than migrate because it always takes people time to learn a new system. During that learning process there are bound to be times when you don't know how to do something really quite trivial. People often claim the new system can't do something, not because they have exhaustively searched for it - but just because they can't be bothered to poke around for 2 seconds or ask someone. For some reason such morons are usually highly regarded and their opinions widely sought. Anyway if they had been able to quickly reboot back into Windows, complete the task, and then take their time finding out how to do whatever then they would probably find plenty of ways. People who do the switch often end up rejecting the new system and taking it back to the shop and demanding whatever they were used to previously. People who do the migration often end up staying away from Windows more and more. There was the case of a German town council that had been taking advice from the Free Software Foundation and everything was going really smoothly with most councillors much preferring OpenOffice (just before the launch of LO) and the new systems and loving the reduction in license fees. Then a change of personnel at the top led to the IT department suddenly stopping all communication with the FSF and started hiring in MS employees to help them migrate. The MS people said to do a complete switch and get rid of all remaining MS stuff. Within a few months the whole thing had collapsed and the council 'had to' re-purchase all new MS stuff. There was a big newspaper article about how rubbish OpenSource was and how it had ended up costing the council a huge fortune. Meanwhile a Spanish government had put several thousand GnuLinux desktops into schools and following the FSF people's advice found it such a huge success that they put in a lot more similar systems into government offices. All a complete success and a massive saving. So, don't let yourself get pushed into getting rid of Windows because there really is no need to. Just go for the dual-boot and use both. Let yourself be led gently by the hand instead of being dragged kicking and screaming into the 21st century. Gentler option wins. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 29 August 2013, 15:33 Subject: Re: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? the birds do it ... the fish do it ... now, the computerists migrate ;-) Does anyone really wish to remain with MSFT?; it's just already programmed into these glorified-typewriter machines ... scary prospect to remove it then install something else -and all alone, nary a soul to even lend a hand ;-) BTW - I thought many of your pubs were called the King's Arms ;-) On Wed, Aug 28, 2013 at 9:44 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Even though this thread went wy off-topic it's ended up being very relevant to a problem many of us have. How to migrate. Given that most people want to stay with MS systems we are a bit stuck in the phase of having to deal with both systems at the same time. Even when the ODF format does become dominant there will probably be a few people still using the ever-changing proprietary format that could disappear any-time at the whim of a single company. It's interesting to hear that Km changed it's base without changing it's
[libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
Hi :) Yes, as Carlo says. You can also follow the Nabble links in Carlo's or my message to get to the exactly tight thread. Of course security experts say we shouldn't just click on any links in any emails or on unknown websites and should really navigate a safe known path instead. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072195.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] bibliography after endnotes
Thank you very much for this. I am using LO 4.0.2.2, which is the latest build available for Kubuntu 12.04 LTS. I wonder why you do not experience the bug I do. I did upgrade from 3.5 (I think) to my current version and found the same bug. Maybe I should try the .deb from the LibreOffice website. I am wondering though whether sections are needed at all. As long as one inserts the bibliography at the final stage it might be possible to simply press return and copy and paste under the final endnote. Regards, Ryan On 28/08/13 23:18, Krunoslav Šebetić wrote: I don't know which operation system and LO version are you using but on 4.0.5 on Linux the section for main content does the trick - I can put main content in a section, and in a section properties tick Collect at the end of section, Restart numbering, Custom format. Adding an endnote attaches it to a end of a section, and I can do Alt + Enter to exit that (main) section and make manual break with Ctrl + Enter so Bibliography can be added to a new page. It all works with double spaces (for endnotes and main text). Just wonted to tell you that because maybe changing the LO version would solve your problems. Also, see here: http://www.youtube.com/watch?v=gx3K99ehRXI Kruno On 08/28/2013 07:22 PM, Info/UX wrote: Hi, To simplify last night's tale of woe into one issue... The only way of placing the bibliography after the endnotes in correct formatting is to place a section after (technically within) the final endnote. Using a section for the main article causes a crash when double spacing is applied. Does this method bode well for MS Word compatibility? Is there a better method? Many thanks, Ryan -- 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: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?
Hi :) Just found this South Tyrol has announced to migrate 7000 PCs in the public administration to LibreOffice - http://www.provinz.bz.it/lpa/285.asp?redas=yesaktuelles_action=4aktuelles_article_id=428953 (announcement in german) from the marketing list, the post from Christian Lohmaier in response to a question about the best route to take on the way to get from Munich to Milan for LibOCon. I tend to choose routes that either fastest or for best for sight-seeing, NOT by what locals are likely to be using on their computers! :) lol Regards from Tom :) From: Tom Davies tomdavie...@yahoo.co.uk To: anne-ology lagin...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 29 August 2013, 16:22 Subject: Re: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? Hi :) Yes, there are a lot of Kings Arms too, i'd kinda forgotten. In Brighton there was one called the Queens Head with it's sign being a painting of Freddy Mercury. Usually the signs are fairly predictable. I saw a Queens Legs once but can't remember where. Actually wrt to removing Windows that is really not necessary at all. It's what the MS world prefer people to do but is absolutely NOT what the OpenSource world recommends. The whole point about using the word migrate is to avoid the idea of switching. Most OpenSource people have a dual-boot (or multi-boot). When they turn on their system they get a boot menu giving a list of the different operating systems on their machine. The commonest is to have 2 options; with one being for Windows and the other being for Mint/Ubuntu/openSuSE/whatever. The usual recommendation from most OpenSource people is to start the migration with the boot-menu defaulting into Windows. Then after some time switch that around making the GnuLinux the default. Almost all my colleagues' machines still default into Windows but i have a few that would default into Ubuntu if their users didn't press the up arrow in time. I give them 10 seconds which is more than enough for most people. I get the impression that MS would rather people switched rather than migrate because it always takes people time to learn a new system. During that learning process there are bound to be times when you don't know how to do something really quite trivial. People often claim the new system can't do something, not because they have exhaustively searched for it - but just because they can't be bothered to poke around for 2 seconds or ask someone. For some reason such morons are usually highly regarded and their opinions widely sought. Anyway if they had been able to quickly reboot back into Windows, complete the task, and then take their time finding out how to do whatever then they would probably find plenty of ways. People who do the switch often end up rejecting the new system and taking it back to the shop and demanding whatever they were used to previously. People who do the migration often end up staying away from Windows more and more. There was the case of a German town council that had been taking advice from the Free Software Foundation and everything was going really smoothly with most councillors much preferring OpenOffice (just before the launch of LO) and the new systems and loving the reduction in license fees. Then a change of personnel at the top led to the IT department suddenly stopping all communication with the FSF and started hiring in MS employees to help them migrate. The MS people said to do a complete switch and get rid of all remaining MS stuff. Within a few months the whole thing had collapsed and the council 'had to' re-purchase all new MS stuff. There was a big newspaper article about how rubbish OpenSource was and how it had ended up costing the council a huge fortune. Meanwhile a Spanish government had put several thousand GnuLinux desktops into schools and following the FSF people's advice found it such a huge success that they put in a lot more similar systems into government offices. All a complete success and a massive saving. So, don't let yourself get pushed into getting rid of Windows because there really is no need to. Just go for the dual-boot and use both. Let yourself be led gently by the hand instead of being dragged kicking and screaming into the 21st century. Gentler option wins. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 29 August 2013, 15:33 Subject: Re: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? the birds do it ... the fish do it ... now, the computerists migrate ;-) Does anyone
Re: [libreoffice-users] bibliography after endnotes
Hi :) Zotero seems to make the whole thing a lot more flexible and easier to get working the more sensible ways. If you look through the mailing lists archives then you see pretty much all questions about end-notes are magically resolved when the person started using Zotero. Even though i have never used it and don't need end-notes in the types of documents i produce an barely remember it's name until someone else mentions it i still really recommend giving it a go asap. Regards from Tom:) From: Krunoslav Šebetić kruno0...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, 28 August 2013, 23:18 Subject: Re: [libreoffice-users] bibliography after endnotes I don't know which operation system and LO version are you using but on 4.0.5 on Linux the section for main content does the trick - I can put main content in a section, and in a section properties tick Collect at the end of section, Restart numbering, Custom format. Adding an endnote attaches it to a end of a section, and I can do Alt + Enter to exit that (main) section and make manual break with Ctrl + Enter so Bibliography can be added to a new page. It all works with double spaces (for endnotes and main text). Just wonted to tell you that because maybe changing the LO version would solve your problems. Also, see here: http://www.youtube.com/watch?v=gx3K99ehRXI Kruno On 08/28/2013 07:22 PM, Info/UX wrote: Hi, To simplify last night's tale of woe into one issue... The only way of placing the bibliography after the endnotes in correct formatting is to place a section after (technically within) the final endnote. Using a section for the main article causes a crash when double spacing is applied. Does this method bode well for MS Word compatibility? Is there a better method? Many thanks, Ryan -- 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] editing Sharepoint documents
Hi :) There is a video about using an alternative to Sharepoint but i think it is meant to be generic enough that it gives the rough idea for Sharepoint too. http://www.libreoffice.org/home/Discover I was lucky enough to meet the lady whose voice was used in the video but sadly she was too shy to be videoed or even photographed so i just have my failing memory to rely on :( Regards from Tom :) From: Bruce Carlson bruce.carl...@nepean.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, 28 August 2013, 6:13 Subject: [libreoffice-users] editing Sharepoint documents Hi All, I've been trying to find a way to checkout and edit documents from sharepoint libraries. I want to be able to use libreoffice on Ubuntu to edit both Microsoft and open document formats. I am able to checkout from sharepoint but the documents open in libreoffice as readonly. I've been trying to find plugins etc. on the internet but I always end up being directed to a page that does not exist Anyone know how to do this. Thanks, Bruce Carlson. Website: www.nepean.comhttp://www.nepean.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
Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?
Hi :) Yes, or spend it shouting at the stupid potholes that i hadn't noticed and that had given me a flat (or whatever problem i ran into). At least with a push-bike it's reasonably easy to suddenly go off road and push the bike and generally make the most of it Regards from Tom :) From: anne-ology lagin...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: LibreOffice users@global.libreoffice.org Sent: Wednesday, 28 August 2013, 15:21 Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? so some days you spend more time viewing the scenery, huh? ;-) On Tue, Aug 27, 2013 at 1:34 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I think our cars show both too. I think road signs only show miles. Errr, i am a cyclist so any distance away just seems forever away until i reach it. 60 miles might take just a few hours one day but then an 8mile might be unfeasible another. Bit of an exaggeration of course. Regards from Tom :) From: James Knott james.kn...@rogers.com To: LibreOffice users@global.libreoffice.org Sent: Tuesday, 27 August 2013, 19:08 Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? Ruth Ann wrote: Metric just never caught on here in the USA. And I noticed that as the signs were replaced, the news ones just gave the distance in miles again. You can thank Reagan for that one. Peanut Carter had implemented a plan to convert, but Reagan killed it. This was the same period as when Canada switched. Oh, and our cars still do show the speed in both miles per hour and kilometers per hour - but I think that is probably just in case we happen to visit Canada (who has gone metric, I think) :-) Both Canada and Mexico along with every other country an American can drive to, uses Km. The U.S. is stuck with 2 third world countries as the last holdouts. How does it feel to have the U.S. on par with Liberia and Myanmar (Burma). Regardless, thanks to world trade, more and more U.S. companies are having to work with the metric system, if they want to sell elsewhere. -- 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] .ORD files
Hi :) I did a google search about it and found a few proprietary tools that might work or might be dodgy. I hate all that freeware/shareware or low cost dodgy looking proprietary looking stuff. There is just no way of knowing what it's doing and there is a reputation that they do nasty stuff quite often. If you are using the tools on Wine in GnuLinux then you are probably a lot safer than using the same tools in Windows ... On the other hand some of the best-ever tools and games and things have been released that way so it's really difficult to tell if they are just falling foul of the same type of FUD that OpenSource gets tarred with. I used to have an amazing Firewall that also acted as a package manager for updating drivers and everything in Windows Xp. Their company got bought-out and then the product just vanished and i lost my installer. Another was an awesome anti-spyware thing that was maintained by just 1 person but still managed to stay ahead of companies such as Norton/Symantec almost all the time. There seems to be some confusion whether .ord are system config files or something like that or CAD files! Quite a difference! The proprietary tools seemed to deal with .ords that were system files. I'm on a different machine today and haven't googled on here yet and prolly wont have time to sory. Regards from Tom :) From: Tim Lloyd tim.ll...@gmx.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, 27 August 2013, 22:35 Subject: [libreoffice-users] .ORD files Hi, I am going to throw this in for comment. Not expecting much response. I saw a mention on linuxquestions relating to reading a .ord file: ORD is a file format used by OMAX software to store routed tool path information. This is the information that the controller needs in order to machine a part. The guy wants to know whether there is an application which can open this type of file. I guess the question is, has anyone ever heard of this file type before? Cheers -- 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] Sorting a MySQL Database
On 08/29/2013 12:30 AM, Ian Whitfield wrote: Hi Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to the right of the Sort field 6. Then you can choose your sort fields, (LastName and FirstName) 7. Click OK 8. Close Form Properties 9. Save the Form This works with my H2 database. Hopefully it is the same for your MySQL. Thanks for your reply - This is exactly what I was looking for!! BUT I open the Form in Edit Mode and Right-Click on it and there is NO Form in the options that come up!! My LO is version 3.6.5.2 (Build ID: 5b93205) and MySQL is 5.1 thanks anyway IanW Pretoria RSA It seems where you right-click on the form is important. If I click anywhere but the top of the form, then I do not get the Form option. However, if I click near the top edge, I do get the Form option. Don't know why this is, unless it has something to do with the beginning of data. There was something I read about the form being made up of paragraphs, so maybe you need to click near the beginning of the first paragraph to get outside it. Otherwise, you get the paragraph context menu for the right-click. If you don't have the form broken up into paragraphs (I don't), then you have one paragraph. Hope this helps. Girvin Herr -- 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] LibreOffice paragraph styles exported to other software/formats?
Hi :) That helped me find it on Ubuntu 12.04 and gave the package name ttf-mscorefonts-installer so it'd be sudo apt-get install ttf-mscorefonts-installer on a debian (and probably quite a few others) command-line. For Redhat just swap out apt-get with yum? Regards from Tom :) From: Don C. Myers donmy...@myersfarm.com To: users@global.libreoffice.org Sent: Tuesday, 27 August 2013, 1:14 Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? In Ubuntu 13.04, the package in the software center is called: Installer for Microsoft TrueType core fonts Don On 08/26/2013 08:00 PM, Tom Davies wrote: Hi :) There used to be a package called something like ms core fonts which had arial, times new roman, trebuchet, verdana and maybe a couple other things. I must have got the name a bit wrong because i cna't find it in my package manager now. I've copied across a few fonts from Ubuntu to Windows but i should really find a way of being more consistent one day to get all machines on both networks the same as each other. Possibly 1 folder on the file-share and then just dragdrop Regards from Tom :) From: Virgil Arrington cuyfa...@hotmail.com To: Info/UX inf...@gmx.com Cc: Tom Davies tomdavie...@yahoo.co.uk; users@global.libreoffice.org Sent: Tuesday, 27 August 2013, 0:33 Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? I think you've got a good process there. Fonts! It's one problem I see with interaction between Linux and Windows. I have a dual boot Windows/Linux laptop, and the font issue is a constant problem. I've found that many Windows fonts install quite nicely into Linux, but I do want to respect copyrights and licenses, so I tend to use free fonts as much as possible. The URW collection of free fonts is quite nice, as is Linux Libertine, which has some really nice expert effects (old style numbering, true small caps, etc.). Another great free font for book-style work is OFL Sorts Mill Goudy. Virgil -Original Message- From: Info/UX Sent: Monday, August 26, 2013 7:20 PM To: Virgil Arrington Cc: Tom Davies ; users@global.libreoffice.org Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? Thanks a lot for that, Virgil. Based on the information you and Tom have provided, my workflow will go: .ott (with paragraph and page styles) -- .odt (copy and paste .doc content, load style from template, format, save) -- export to PDF -- save as .doc -- send to MS computer -- Manually clean up any problems. I think this should be fine, if a little involved. All the fonts I need are standard MS stuff, which I have installed. I'll spare you the horror stories about preparing a nice document in LO using DejaVU fonts and then later opening in a new*ish* version of MS Word. ;-) Thanks again for the time you took. Think I can get to work now. Regards, Ryan On 26/08/13 23:59, Virgil Arrington wrote: Before answering your question, I did a little test. I loaded a simple .odt two page document in LO. It has some basic paragraph styles, and a few outline styles with automatic numbering, along with a footer with a page number. Basic stuff. I then saved the document as a .doc (Word 2003). I loaded it into the Word Starter Version that came with my Sony Laptop, and it converted *almost* perfectly. There was only a slight deviation in my outline numbering. LO adds more horizontal space after an automatic number, whereas Word adds a tab character. When converting the document, LO added a tab and adjusted the extra horizontal space, but there was still an ever so slight difference in the lining up of the text. It would only bother an obsessive person like me. The page formatting and footer with page number translated perfectly. I'm using LO 3.6.7 and I must say that it's .doc translation is extremely good, much better than I remember from previous versions. Virgil -Original Message- From: Info/UX Sent: Monday, August 26, 2013 6:40 PM To: Virgil Arrington Cc: Tom Davies ; users@global.libreoffice.org Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? Thanks, Virgil. My documents are similar to yours. One last question then I'll give you guys some peace. :-) Would making a page style with page size letter and with a footer be considered LO specific? I don't need anything more intricate than that. Thanks for the tip regarding Atlantis. I only have Linux at home so will probably stick with LO. Thanks again. Your replies have helped a lot. Regards, Ryan On 26/08/13 23:29, Virgil Arrington wrote: My documents tend to be *really* basic in terms of formatting. Typically, they are either legal or academic style papers. I'm a heavy user of
[libreoffice-users] Translating questions and answers
Hi :) Ideally i like to forwards the question to the international translators list fairly quickly. For the parts that appear on this list i try to use Quick translate (or other machine translator tool) but keep it close to the original in whatever language that was in. Not everyone has access to the tools and even if they do they often don't realise. At my own work-place they keep wanting translations and yet they just wont engage with FOSS tools or don't quite realise the capacity FOSS would give them. A few do use Firefox but don't have any translations add-ons [sighs deeply]. Regards from Tom :) - Forwarded Message - From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Monday, 26 August 2013, 7:12 Subject: Re: [libreoffice-users] busca de soluções para Excel At 10:57 25/08/2013 +0100, Tom Davies wrote: Again using Quick Translate but this time from English into Portuguese. Unfortunately machines are not good at speaking human languages so this might be nonsensical. Which is why it's always best to leave messages in the writer's own language and let the recipient manage the translation - as indeed the original questioner did. 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 -- 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] Mobile devices?
Hi :) I just had a glimpse of an Android and it looks like it's got a mini-Usb socket in the top. If that could break-out to a powered usb-hub then surely you could get keyboard, mice, maybe even screens working off the Android? So 1 docking station at work and 1 at home might be enough to do emailing and more serious stuff there and still be able to keep an eye on things when travelling around or out? Or is Android just not yet set-up to do this sort of thing? Regards from Tom :) - Forwarded Message - From: Felmon Davis dav...@union.edu To: users@global.libreoffice.org Sent: Monday, 26 August 2013, 5:21 Subject: Re: [libreoffice-users] Re: Cross Platfrom Support Question **CLOSED Thread** On Sat, 24 Aug 2013, Doug wrote: On 08/24/2013 06:22 PM, Jay Ridgley wrote: To those who responded, I guess the bottom line is that currently LibreOfffice does not and will not without a LOT of work support mobile devices. I am not a mobile user, so I have no frame of reference. It does appear that this feature (mobility) will be required at some future point, however. Thanks, Jay What kind of masochist would wish to do any serious writing--the kind that would require a word-processor--on a mobile phone, or a touch-screen tablet? Get real! --doug you can add a small bluetooth keyboard. some come in a kind of sleeve where you can fold the keyboard and the 10 tablet together held by velcro; you unfold it and the tablet is propped up and the keyboard laid out flat. folded up, it all fits into a woman's purse or a small satchel. the keyboard is pretty easy to use for normal-sized hands and fingers. opposite of masochism. not my taste though - I prefer more power and gear - but perfectly understandable setup for many use-cases. F. -- Felmon Davis Better some of a pudding than none of a pie. -- John Ray -- 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] Mobile devices?
Sounds like the Ubuntu Edge: http://www.indiegogo.com/projects/ubuntu-edge On Thu, 29 Aug 2013 20:23:49 +0100 (BST) Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I just had a glimpse of an Android and it looks like it's got a mini-Usb socket in the top. If that could break-out to a powered usb-hub then surely you could get keyboard, mice, maybe even screens working off the Android? So 1 docking station at work and 1 at home might be enough to do emailing and more serious stuff there and still be able to keep an eye on things when travelling around or out? Or is Android just not yet set-up to do this sort of thing? Regards from Tom :) - Forwarded Message - From: Felmon Davis dav...@union.edu To: users@global.libreoffice.org Sent: Monday, 26 August 2013, 5:21 Subject: Re: [libreoffice-users] Re: Cross Platfrom Support Question **CLOSED Thread** On Sat, 24 Aug 2013, Doug wrote: On 08/24/2013 06:22 PM, Jay Ridgley wrote: To those who responded, I guess the bottom line is that currently LibreOfffice does not and will not without a LOT of work support mobile devices. I am not a mobile user, so I have no frame of reference. It does appear that this feature (mobility) will be required at some future point, however. Thanks, Jay What kind of masochist would wish to do any serious writing--the kind that would require a word-processor--on a mobile phone, or a touch-screen tablet? Get real! --doug you can add a small bluetooth keyboard. some come in a kind of sleeve where you can fold the keyboard and the 10 tablet together held by velcro; you unfold it and the tablet is propped up and the keyboard laid out flat. folded up, it all fits into a woman's purse or a small satchel. the keyboard is pretty easy to use for normal-sized hands and fingers. opposite of masochism. not my taste though - I prefer more power and gear - but perfectly understandable setup for many use-cases. F. -- 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: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
El 29/08/13 10:38, Michele contabilmenteAG escribió: Dear Marlosv thanks for the reply. Enclosed is sending the file from these problems. I look forward to technical comments from the thing. (I have not yet thrown from my building, but customers may feel happy to push me from the brink, if he does not finish the job :-) ) -- Please : Some Notes details for the use of the file: It is a complete accounting double entry for businesses. The worksheets are to be observed: PROSPETTO CODICI (which contains 2 PivotTable): one for a CODICI DARE and one for CODICI AVERE The origin of the data is in the worksheet PRIMA NOTA. activity 1) If you update the PivotTable CODICI AVERE (red numbers), updating the Codes field disappears and the pivot table does not work. Task 2) If you ask in the Pivot table detail of a code (double click on an amount in AVERE column or DARE column) opens a worksheet regularly with details. If you make the task 1) or 2) in the worksheet named BILANCIO CE columns C (visible column) and F (hidden column) where the functions are written in the cells GETPIVOTDATA refer to 2 Pivot Tables do not contain more results GETPIVOTDATA = function no longer works. Even rewriting the Pivot Tables and rewriting the GETPIVOTDATA function in those cells (the cells before deleting), the function from the results that more has to give. And then the balance is no longer results Oh My God What a disaster! Best Regards. Michele Ras Hi Michele. 1) Seems the row field is missing, WHY? I don't know, maybe a bug. Edit the PT add the field Cod. R/D to row fields and PT works again. 2) Calc have been a deep rework on the core for 4.1, seems that the second form of GETPIVOTDATA, what you are using doesn't work, but the first form works for me: in cell BILANCIOCEE.C10: =GETPIVOTDATA(DARE;'PROSPETTO CODICI'.$A$3;'PROSPETTO CODICI'.$A$3;$A10). Saluti. Miguel Ángel. -- 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] .ORD files
Thanks for following up Tom. The guy who posted this question over on LQ seems to have left the building so he either has a solution or he has given up. Anyway, we will know for next time! Cheers On 08/30/2013 03:38 AM, Tom Davies wrote: Hi :) I did a google search about it and found a few proprietary tools that might work or might be dodgy. I hate all that freeware/shareware or low cost dodgy looking proprietary looking stuff. There is just no way of knowing what it's doing and there is a reputation that they do nasty stuff quite often. If you are using the tools on Wine in GnuLinux then you are probably a lot safer than using the same tools in Windows ... On the other hand some of the best-ever tools and games and things have been released that way so it's really difficult to tell if they are just falling foul of the same type of FUD that OpenSource gets tarred with. I used to have an amazing Firewall that also acted as a package manager for updating drivers and everything in Windows Xp. Their company got bought-out and then the product just vanished and i lost my installer. Another was an awesome anti-spyware thing that was maintained by just 1 person but still managed to stay ahead of companies such as Norton/Symantec almost all the time. There seems to be some confusion whether .ord are system config files or something like that or CAD files! Quite a difference! The proprietary tools seemed to deal with .ords that were system files. I'm on a different machine today and haven't googled on here yet and prolly wont have time to sory. Regards from Tom :) From: Tim Lloyd tim.ll...@gmx.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, 27 August 2013, 22:35 Subject: [libreoffice-users] .ORD files Hi, I am going to throw this in for comment. Not expecting much response. I saw a mention on linuxquestions relating to reading a .ord file: ORD is a file format used by OMAX software to store routed tool path information. This is the information that the controller needs in order to machine a part. The guy wants to know whether there is an application which can open this type of file. I guess the question is, has anyone ever heard of this file type before? Cheers -- 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
Fwd: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
-- Forwarded message -- From: Michele contabilmenteAG contabilmenteag@gmail.com Date: 2013/8/29 Subject: Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA To: MiguelAngel mari...@miguelangel.mobi Hola Miguel Angel, 1) true: it's a bug and I know, it is sufficient to re-enter the field of R / D in the PT and this works. But I certainly can not offer people to download this program that works well. Although it is free, the user is in trouble. Is necessary to fix that bug. 2) cells in columns C and F that you see in the file that I sent, retain the right results from the previous version to 4.1.0.4. if you change a code C / R or R / D in the data base (worksheet PRIMANOTA) and then launches the update of the PT in the worksheet PROSPETTO CODICI then the worksheet BILANCIO CE the GETPIVOTDATA function no longer works and not by right results. I have verified, however, that this bug happens using UBUNTU and also going on Windows7. Using XP does not seem to give this problem. Let's see if there are further developments to the question (I hope before my clients make me commit suicide out of the window ) :-) Thanks a lot. Best Regards Michele 2013/8/29 MiguelAngel mari...@miguelangel.mobi El 29/08/13 10:38, Michele contabilmenteAG escribió: Dear Marlosv thanks for the reply. Enclosed is sending the file from these problems. I look forward to technical comments from the thing. (I have not yet thrown from my building, but customers may feel happy to push me from the brink, if he does not finish the job :-) ) --** --**-- Please : Some Notes details for the use of the file: It is a complete accounting double entry for businesses. The worksheets are to be observed: PROSPETTO CODICI (which contains 2 PivotTable): one for a CODICI DARE and one for CODICI AVERE The origin of the data is in the worksheet PRIMA NOTA. activity 1) If you update the PivotTable CODICI AVERE (red numbers), updating the Codes field disappears and the pivot table does not work. Task 2) If you ask in the Pivot table detail of a code (double click on an amount in AVERE column or DARE column) opens a worksheet regularly with details. If you make the task 1) or 2) in the worksheet named BILANCIO CE columns C (visible column) and F (hidden column) where the functions are written in the cells GETPIVOTDATA refer to 2 Pivot Tables do not contain more results GETPIVOTDATA = function no longer works. Even rewriting the Pivot Tables and rewriting the GETPIVOTDATA function in those cells (the cells before deleting), the function from the results that more has to give. And then the balance is no longer results Oh My God What a disaster! Best Regards. Michele Ras Hi Michele. 1) Seems the row field is missing, WHY? I don't know, maybe a bug. Edit the PT add the field Cod. R/D to row fields and PT works again. 2) Calc have been a deep rework on the core for 4.1, seems that the second form of GETPIVOTDATA, what you are using doesn't work, but the first form works for me: in cell BILANCIOCEE.C10: =GETPIVOTDATA(DARE;'**PROSPETTO CODICI'.$A$3;'PROSPETTO CODICI'.$A$3;$A10). Saluti. Miguel Ángel. -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- http://contabilmenteag.wix.com/contabilmenteag-net contabilmenteag@gmail.com contabilment...@hotmail.it Ras Michele Perito Agrario Salita S.Barnaba 24d/18 16136 Genova Ge Tel./Fax.: 010 213059 Tel.Mobile:3201107102 Riservatezza / Confidentiality In ottemperanza al D.Lgs. n. 196 del 30/6/2003 in materia di protezione dei dati personali, le informazioni contenute in questo messaggio sono strettamente riservate ed esclusivamente indirizzate al destinatario indicato (oppure alla persona responsabile di rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso, riproduzione o divulgazione di questo messaggio è vietato. Nel caso in cui aveste ricevuto questo messaggio per errore, vogliate cortesemente avvertire il mittente e distruggere il presente messaggio. According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not the addressee (or responsible for delivery of the message to such person) you are hereby notified that any disclosure, reproduction,
Re: [libreoffice-users] Mobile devices?
Tom Davies wrote: I just had a glimpse of an Android and it looks like it's got a mini-Usb socket in the top. If that could break-out to a powered usb-hub then surely you could get keyboard, mice, maybe even screens working off the Android? So 1 docking station at work and 1 at home might be enough to do emailing and more serious stuff there and still be able to keep an eye on things when travelling around or out? Or is Android just not yet set-up to do this sort of thing? Every mobile device is required to have a USB connection for power. It doesn't have to be used for anything else but generally is. I don't know about keyboards though. However, keyboards are supported via Blutooth. -- 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: problem with formala inserted by macros when decimal separator is comma
Thank you very much, This is exactly what I wanted to know. I was not able to run that test myself. On 08/29/2013 06:21 AM, Mindaugas wrote: In 4.0 the properties Formula and FormulaLocal give the expected result: cell.Formula = =2.1*2= 4,2 cell.Formula = =2,1*2= #NAME? cell.FormulaLocal = =2,1*2 = 4,2 cell.FormulaLocal = =2.1*2 = #NAME? In 4.1 the both properties Formula and FormulaLocal give the same result: cell.Formula = =2,1*2= 4,2 cell.Formula = =2.1*2= #NAME? cell.FormulaLocal = =2,1*2 = 4,2 cell.FormulaLocal = =2.1*2 = #NAME? Best regards Mindaugas Best regards -- View this message in context: http://nabble.documentfoundation.org/problem-with-formala-inserted-by-macros-when-decimal-separator-is-comma-tp4072059p4072140.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: problem with formala inserted by macros when decimal separator is comma
seems that you are not the first to see this bug. Consider adding yourself to the CC list. I dropped an email to the dev list to see if I can figure out who introduced the bug. https://bugs.freedesktop.org/show_bug.cgi?id=67836 On 08/29/2013 10:30 PM, Andrew Douglas Pitonyak wrote: Thank you very much, This is exactly what I wanted to know. I was not able to run that test myself. On 08/29/2013 06:21 AM, Mindaugas wrote: In 4.0 the properties Formula and FormulaLocal give the expected result: cell.Formula = =2.1*2= 4,2 cell.Formula = =2,1*2= #NAME? cell.FormulaLocal = =2,1*2 = 4,2 cell.FormulaLocal = =2.1*2 = #NAME? In 4.1 the both properties Formula and FormulaLocal give the same result: cell.Formula = =2,1*2= 4,2 cell.Formula = =2.1*2= #NAME? cell.FormulaLocal = =2,1*2 = 4,2 cell.FormulaLocal = =2.1*2 = #NAME? Best regards Mindaugas Best regards -- View this message in context: http://nabble.documentfoundation.org/problem-with-formala-inserted-by-macros-when-decimal-separator-is-comma-tp4072059p4072140.html Sent from the Users mailing list archive at Nabble.com. -- 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] Mobile devices?
Motorola's phones have docks to connect any keyword and mouse, even an HDMI television. When docked you have a Desktop very similar to GNOME. First Atrix had a dock shipped with the devise and can use LAPTOP like dock. New models require to buy docks separately. With this kind if devices and a LibreOffice version for it you can have all the power you need for basic work station. El ago 29, 2013 8:06 p.m., James Knott james.kn...@rogers.com escribió: Tom Davies wrote: I just had a glimpse of an Android and it looks like it's got a mini-Usb socket in the top. If that could break-out to a powered usb-hub then surely you could get keyboard, mice, maybe even screens working off the Android? So 1 docking station at work and 1 at home might be enough to do emailing and more serious stuff there and still be able to keep an eye on things when travelling around or out? Or is Android just not yet set-up to do this sort of thing? Every mobile device is required to have a USB connection for power. It doesn't have to be used for anything else but generally is. I don't know about keyboards though. However, keyboards are supported via Blutooth. -- 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
