[libreoffice-users] Re: ODF 1.x vs 1.2
TomD wrote Presumably it can be done straight from a command-line without even needing a script as such. This is an ideal task for a script. Invoking LO to determine ODF version info is inefficient, especially for multiple files. Here is a basic bash script to do the task under GNU/Linux: #!/bin/bash # extract office:version attribute i.e., ODF version # args: $1 path to search e.g., doc/ # $2 file extension e.g., sxw odt od* for f in $1*.$2; do v=$(unzip -p $f content.xml | xmllint --format - | grep -o office:version=[^\]* | sed -e 's/office:version=//' -e 's///g'); echo $f: $v; done; -- View this message in context: http://nabble.documentfoundation.org/ODF-1-x-vs-1-2-tp4101348p4101478.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 compatibility
On 14/03/2014, Hamida Begum hamida_beg...@hotmail.com wrote: is the program compatible with microsoft office? Please go to m$ and ask if m$office is compatible with the ODF standard of LO -- 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 4.2.3-RC1
Hello, I just downloaded the Linux-deb-Version-32-Bit of LO. It installed fine, however I have a problem with frames. If I want to print a frame without a border, LO ignores the definition (i.e. - thickness and colour of the line). Even if I define no border at all plus pinting in white colour around the frame this gets ignored. Testing further I see that - weird enough - this happens only within a document with variables inserted from a database (in the case tested the DB is a LO-calc-table). Everything works fine under previous versions of LO. To me this is critical and I hope it will be fixed quickly... Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/main/ -- 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 compatibility
nabbler wrote Please go to m$ and ask if m$office is compatible with the ODF standard of LO THAT is exactly the problem! There should never be an ODF standard of LO. If OASIS (the organization that defines the ODF standard) is not able to keep pace and improve on the document's definition to make it a valid open document standard, then the de facto standard will ALWAYS be the MS file formats... On the other hand if LO/TDF keeps improving and pushing the ODF format but OASIS does not publish the specifications, how can you expect any other office suite (including MS Office) to be compatible??? -- View this message in context: http://nabble.documentfoundation.org/Re-LO-compatibility-tp4101492p4101509.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] Re: LO compatibility
On 15/03/14 11:25, Pedro wrote: If OASIS (the organization that defines the ODF standard) is not able to keep pace and improve on the document's definition to make it a valid open document standard, then the de facto standard will ALWAYS be the MS file formats... ODF has a clear path forward, and is actively maintained by OASIS. There is an ODF 1.0 which is an ISO standard, and an ODF 1.2 which is in the process of becoming an ISO standard (backward compatible with ODF 1.0). Standard definitions, by their own nature, are moving slowly. This is the reason why LibreOffice is compatible with both ODF 1.0 and ODF 1.2. Microsoft OOXML, on the other hand, has never been implemented according to the standard ISO definition, and is not even actively maintained by ECMA (because ECMA is not focused on document standards as much as OASIS is). Unfortunately, in the market there are more OOXML documents than ODF documents, but this does not make OOXML format a standard. LibreOffice makes every possible effort to be interoperable with all Microsoft Office proprietary document formats, because this is what users are asking (so, the answer to the original question is YES). On the other hand, Microsoft makes every possible effort to make OOXML not interoperable, which means that maintaining compatibility is like trying to shoot a pheasant while driving a motorbike on a rough path with the eyes shut. -- Italo Vignoli - italo.vign...@gmail.com mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- 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 4.2.3-RC1
Am 15.03.2014 10:25, schrieb Heinrich Stoellinger: I have a problem with frames. If I want to print a frame without a border, LO ignores the definition (i.e. - thickness and colour of the line). Even if I define no border at all plus pinting in white colour around the frame this gets ignored. Testing further I see that - weird enough - this happens only within a document with variables inserted from a database (in the case tested the DB is a LO-calc-table). Everything works fine under previous versions of LO. To me this is critical and I hope it will be fixed quickly... As long as it is unknown to the devs, nothing will happen: Check e.g. this list: https://bugs.freedesktop.org/buglist.cgi?query_format=advancedshort_desc=frame%20bordershort_desc_type=allwordssubstrcomponent=Writerproduct=LibreOffice and if your problem is not in this list, I'd suggest to report it. Nino -- 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: LO compatibility
On Sat, 15 Mar 2014 03:25:43 -0700 (PDT) Pedro pedl...@gmail.com wrote: nabbler wrote Please go to m$ and ask if m$office is compatible with the ODF standard of LO THAT is exactly the problem! There should never be an ODF standard of LO. If OASIS (the organization that defines the ODF standard) is not able to keep pace and improve on the document's definition to make it a valid open document standard, then the de facto standard will ALWAYS be the MS file formats... On the other hand if LO/TDF keeps improving and pushing the ODF format but OASIS does not publish the specifications, how can you expect any other office suite (including MS Office) to be compatible??? -- View this message in context: http://nabble.documentfoundation.org/Re-LO-compatibility-tp4101492p4101509.html Sent from the Users mailing list archive at Nabble.com. Has Urmas changed his username ? makes one wonder Pete . -- Linux 7-of-9 3.13.6-1-ARCH #1 SMP PREEMPT Fri Mar 7 22:47:48 CET 2014 x86_64 GNU/Linux -- 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: LO compatibility
On Sat, 15 Mar 2014 03:25:43 -0700 (PDT) Pedro pedl...@gmail.com wrote: nabbler wrote Please go to m$ and ask if m$office is compatible with the ODF standard of LO THAT is exactly the problem! There should never be an ODF standard of LO. [snip] I read that as compatible with the ODF standard, as implemented in LO. I.e.: LO uses the ODF standard. Does MS Office? Did I read that wrong? Or does LO not properly implement the ODF standard? Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.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
[libreoffice-users] Re: LO compatibility
Hi Jim, all Jim Seymour wrote I read that as compatible with the ODF standard, as implemented in LO. I.e.: LO uses the ODF standard. Does MS Office? Did I read that wrong? Or does LO not properly implement the ODF standard? As Italo mentioned LO is backwards compatible with all ODF specifications. But since LO is pushing the ODF file format, the current LO implementation is more advanced than the current approved OASIS standard (e.g. LO supports font embedding) So it's not a case that LO is not implementing the existing ODF standards but that it is already improving on them (in an open manner, unlike MS XML). So OASIS has to catch up :) Hope this makes it clear ;) -- View this message in context: http://nabble.documentfoundation.org/Re-LO-compatibility-tp4101492p4101566.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] Re: LO compatibility
On Sat, 15 Mar 2014 08:32:27 -0700 (PDT) Pedro pedl...@gmail.com wrote: Hi Jim, all Jim Seymour wrote I read that as compatible with the ODF standard, as implemented in LO. I.e.: LO uses the ODF standard. Does MS Office? Did I read that wrong? Or does LO not properly implement the ODF standard? As Italo mentioned LO is backwards compatible with all ODF specifications. But since LO is pushing the ODF file format, the current LO implementation is more advanced than the current approved OASIS standard (e.g. LO supports font embedding) No offense intended, but that's weasel-word way of saying LO is non-standard. So it's not a case that LO is not implementing the existing ODF standards but that it is already improving on them (in an open manner, unlike MS XML). So OASIS has to catch up :) OASIS establishes the standards, no? If such is the case: What you've written, above, is what we call putting the cart before the horse. And that's putting the best possible light on it. To be clear: I have no problem with LO implementing non-standard behaviour, but that behaviour *must* be optional, with the switches that enable it clearly noted as such. Hope this makes it clear ;) Disappointingly so, if I understood correctly what you wrote, and if what you wrote is accurate. But perhaps I've misunderstood? In which case: Disregard my criticisms. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.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: Thunderbird - too many Address Books
On 3/14/2014 11:20 AM, Tom Davies tomc...@gmail.com wrote: I found some excellent advice from one of the moderators there. Someone with a very familiar name! http://forums.mozillazine.org/viewtopic.php?f=39t=366405sid=f6c8f025bc5fff3f5f634d2a9e4b076f [tips hat to tanstaafi]. Just to be clear, that isn't me - I'm tanstaafl_bh on that forum (because he already had *my* username!?)... ;) -- 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 compatibility
Hi Jim, On 3/15/2014 4:58 PM, Jim Seymour wrote: ... As Italo mentioned LO is backwards compatible with all ODF specifications. But since LO is pushing the ODF file format, the current LO implementation is more advanced than the current approved OASIS standard (e.g. LO supports font embedding) No offense intended, but that's weasel-word way of saying LO is non-standard. Maybe it is just a layman stating what he thinks LO is doing. My understanding as a normal/basic user of LO is that it supports the different ODF standards which exist, some of them approved by OASIS and others not yet approved. E.g. in writer you can select the ODF version standard in Options/Load/Save/General see also: https://help.libreoffice.org/swriter/cui/ui/optsavepage/odfversion?Language=en-USSystem=WINVersion=4.2#bm_id810266 Werner -- 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 compatibility
Jim Seymour wrote No offense intended, but that's weasel-word way of saying LO is non-standard. I can't figure out how calling someone a weasel can be *not* offensive... I'm not affiliated to TDF/LO so this is just my opinion and I don't have any advantage in convincing anyone to use LO/ODF and therefore no need to weasel-word anyone. You have options to save in ODF 1.0, 1.1 and 1.2 (according to OASIS standards) By default LO is set to save in ODF 1.2 (extended) which means that yes, TDF/LO is putting the cart before the horse. Personally, I'm glad it does. Regards, Pedro -- View this message in context: http://nabble.documentfoundation.org/Re-LO-compatibility-tp4101492p4101581.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] Calc: limit number of columns and rows
Dear all, a spreadsheet has thousands of lines and hundreds of columns. Most users (like me) don’t need that many cells. Is there any way to limit the amount of lines and rows in a specific file? Thanks a lot! Lorenzo -- 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: LO compatibility
Hi :) E-letter's post was somewhat confusing. ODF 1.2 is used by many programs and suites and is implemented almost identically in all of them. You can even post bug-reports in the various programs and suites if you do find any difference between implementation and written specification. Errr, except that posting bug-reports against MS products is not so easy. LibreOffice does use the ODF 1.2 and that did become an ISO standard a couple of years ago. I'm sure we celebrated it on this mailing list. It's the ODF 1.2 (extended) that is still being developed by OASIS and is not yet an ISO standard. Apparently that is part of the new standard, presumably due to be called the 1.3 when it gets far enough in it's development process. OASIS is an organisation made from representatives from several hundred different organisations. Each organisation involved is limited to only having fair representation equal to all other organisations involved. So, no single organisation can have too much power or control over OASIS. It's not the type of organisation that allows a single company's reps to become chair-persons of several sub-committees and/or then manipulate meetings to push their own agenda through! Files using a newer version of ODF can be successfully opened in programs and suites that only use the older versions of the standard but will just be missing some of the functionality. Files using an older version of ODF can open just fine in programs and suites using the newer standard. So it's very different from MS's OOXML (such as DocX, XlsX, PptX etc) in both directions! This is another reason why ODF is already rapidly increasing in popularity for longer-term storage of documents. If you go to Tools - Options - Save/Load Then you will see you can change the default format down from ODF 1.2 (extended) to ODF 1.2 or ODF 1.1/1.0 You can also choose to set the default format to MS formats although we generally recommend agaisnt doing that. If you do go for it then please use the older MS format because it's more stable across a wider range of programs and suites whereas OOXML can sometimes be fussy about which version of MS Office it needs to be viewed in. However, as e-letter pointed out, the problems of incompatibility are almost entirely due to MS's apparent inability to implement their own or anyone else's formats. All other suites and programs can happily share files with each other in almost any format. Regards from Tom :) On 15 March 2014 15:58, Jim Seymour jseym...@linxnet.com wrote: On Sat, 15 Mar 2014 08:32:27 -0700 (PDT) Pedro pedl...@gmail.com wrote: Hi Jim, all Jim Seymour wrote I read that as compatible with the ODF standard, as implemented in LO. I.e.: LO uses the ODF standard. Does MS Office? Did I read that wrong? Or does LO not properly implement the ODF standard? As Italo mentioned LO is backwards compatible with all ODF specifications. But since LO is pushing the ODF file format, the current LO implementation is more advanced than the current approved OASIS standard (e.g. LO supports font embedding) No offense intended, but that's weasel-word way of saying LO is non-standard. So it's not a case that LO is not implementing the existing ODF standards but that it is already improving on them (in an open manner, unlike MS XML). So OASIS has to catch up :) OASIS establishes the standards, no? If such is the case: What you've written, above, is what we call putting the cart before the horse. And that's putting the best possible light on it. To be clear: I have no problem with LO implementing non-standard behaviour, but that behaviour *must* be optional, with the switches that enable it clearly noted as such. Hope this makes it clear ;) Disappointingly so, if I understood correctly what you wrote, and if what you wrote is accurate. But perhaps I've misunderstood? In which case: Disregard my criticisms. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.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 -- 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: Thunderbird - too many Address Books
Hi :) Ok, so the helpful guide isn't yours but you are still active over there. So you still deserve the kudos. Regards from Tom :) On 15 March 2014 16:05, Tanstaafl tansta...@libertytrek.org wrote: On 3/14/2014 11:20 AM, Tom Davies tomc...@gmail.com wrote: I found some excellent advice from one of the moderators there. Someone with a very familiar name! http://forums.mozillazine.org/viewtopic.php?f=39t=366405sid=f6c8f025bc5fff3f5f634d2a9e4b076f [tips hat to tanstaafi]. Just to be clear, that isn't me - I'm tanstaafl_bh on that forum (because he already had *my* username!?)... ;) -- 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: LO compatibility
On Sat, 15 Mar 2014 17:12:51 +0100 Werner werner...@gmx.ch wrote: Hi Jim, [snip] My understanding as a normal/basic user of LO is that it supports the different ODF standards which exist, some of them approved by OASIS and others not yet approved. E.g. in writer you can select the ODF version standard in Options/Load/Save/General see also: https://help.libreoffice.org/swriter/cui/ui/optsavepage/odfversion?Language=en-USSystem=WINVersion=4.2#bm_id810266 One would hope the standard behaviour is to write things in the officially standard way. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.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: LO compatibility
On Sat, 15 Mar 2014 09:24:17 -0700 (PDT) Pedro pedl...@gmail.com wrote: Jim Seymour wrote No offense intended, but that's weasel-word way of saying LO is non-standard. I can't figure out how calling someone a weasel can be *not* offensive... [snip] My apologies. Bad choice of terms on an international mailing list :( Using weasel words does not one a weasel make :). It describes a use of language, or phraseology, not the individual. Better phrasing would have been that's just another way of saying... Tho I suppose one who habitually employs weasel-wording might reasonably be suspected of being a weasel :) Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.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: LO compatibility
On 15/03/14 16:58, Jim Seymour wrote: To be clear: I have no problem with LO implementing non-standard behaviour, but that behaviour *must* be optional, with the switches that enable it clearly noted as such. You can select the default ODF document format from the Options menu. You can choose between ODF 1.0/1.1, ODF 1.2 (this is the standard ODF 1.2 implementation), ODF 1.2 Extended Compatibility Mode, and ODF 1.2 Extended with LibreOffice Additional Format Related Features. LibreOffice is the reference ODF implementation, and as such is fully supporting the document standard, and provides compatibility options. -- Italo Vignoli - italo.vign...@gmail.com mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- 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] Calc: limit number of columns and rows
Le 15/03/2014 17:25, Lore a écrit : Dear all, a spreadsheet has thousands of lines and hundreds of columns. Most users (like me) don’t need that many cells. Is there any way to limit the amount of lines and rows in a specific file? what for? AFAIK the software uses only memory necessary for the current used cells. IOW, unused cells cost nothing. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users]
yes, I so agree. And for that reason, I ceased using PPs for videos and found an absolutely delightful gem of a program - VideoPad Video Editor - through Gizmo's [ http://www.techsupportalert.com/ ] From: Dave Liesse dslie...@liessefamily.net Date: Fri, Mar 14, 2014 at 12:21 PM Subject: Re: [libreoffice-users] To: users@global.libreoffice.org Probably the second most critical compatibility issue is that Impress, the presentation software, doesn't tend to play nice with PowerPoint. Basic presentations are fine, but as soon as sound and graphics are involved the incompatibility grows exponentially (in my experience). Dave On 3/13/2014 23:40, Jay Lozier wrote: Hamida, LO can generate files that are MSO compatible. Occasionally, there are problems with MSO files with a complex structure. Also, MSO 2013 will read the ODF files version 1.2 which is the current ODF standard. LO uses ODF as its default format. Do you have a specific requirements that you want addressed? The major compatibility issue is LO does not use the same macro language as MSO (Visual Basic for Applications - VBA). Jay On 03/13/2014 08:50 PM, Hamida Begum wrote: is the program compatible with microsoft office? -- 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: LO compatibility
In data sabato 15 marzo 2014 13:34:01, pete nikolic ha scritto: Has Urmas changed his username ? makes one wonder I think so. In fact, its address is inpost(or)@gmail.com The debunker is back. -- Valter Open Source is better! LibreOffice: www.libreoffice.org KDE: www.kde.org Kubuntu: www.kubuntu.org -- 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] Calc: limit number of columns and rows
Thanks for your reply Jean-Francois. It is actually an usability improvement I’m after. If you are using a mouse with an inertial scrolling (such as an Apple mouse or trackpad) and you want to get to the end of your sheet, you can do a strong stroke with your finger. Problem is, you don’t get to the end of your used field, most of the time you end up in the middle of nowhere among unused cells…. It would be nice to limit the size of your sheet then… Thanks again Lorenzo Il giorno 15/mar/2014, alle ore 18:14, Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net ha scritto: Le 15/03/2014 17:25, Lore a écrit : Dear all, a spreadsheet has thousands of lines and hundreds of columns. Most users (like me) don’t need that many cells. Is there any way to limit the amount of lines and rows in a specific file? what for? AFAIK the software uses only memory necessary for the current used cells. IOW, unused cells cost nothing. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] Calc: limit number of columns and rows
Le 15/03/2014 20:29, Lore a écrit : It is actually an usability improvement I’m after. If you are using a mouse with an inertial scrolling (such as an Apple mouse or trackpad) and you want to get to the end of your sheet, you can do a strong stroke with your finger. Problem is, you don’t get to the end of your used field, most of the time you end up in the middle of nowhere among unused cells…. It would be nice to limit the size of your sheet then… Wouldn't it be much easier to use the keyboard? IE, Ctrl+End will set the active cell to the bottom right angle of the used cell area. I'm fond of keystrokes because, among other qualities, they don't break the workflow... YMMV. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc: limit number of columns and rows
Yes, I guess it would be easier… if no limit can be set… Il giorno 15/mar/2014, alle ore 20:38, Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net ha scritto: Le 15/03/2014 20:29, Lore a écrit : It is actually an usability improvement I’m after. If you are using a mouse with an inertial scrolling (such as an Apple mouse or trackpad) and you want to get to the end of your sheet, you can do a strong stroke with your finger. Problem is, you don’t get to the end of your used field, most of the time you end up in the middle of nowhere among unused cells…. It would be nice to limit the size of your sheet then… Wouldn't it be much easier to use the keyboard? IE, Ctrl+End will set the active cell to the bottom right angle of the used cell area. I'm fond of keystrokes because, among other qualities, they don't break the workflow... YMMV. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc: limit number of columns and rows
At 17:25 15/03/2014 +0100, Lorenzo Noname wrote: a spreadsheet has thousands of lines and hundreds of columns. Most users (like me) don't need that many cells. Is there any way to limit the amount of lines and rows in a specific file? As has been suggested, there is usually no overhead in having so many rows and columns. Until they are used, they exist only in the screen display and are not (explicitly) saved in the document file. At 20:29 15/03/2014 +0100, Lorenzo Noname wrote: It is actually an usability improvement I'm after. If you are using a mouse with an inertial scrolling (such as an Apple mouse or trackpad) and you want to get to the end of your sheet, you can do a strong stroke with your finger. Problem is, you don't get to the end of your used field, most of the time you end up in the middle of nowhere among unused cells . It would be nice to limit the size of your sheet then Someone has already beaten me to the suggestion of Ctrl+End, which moves to the last occupied cell. Another idea is to hide the rows and columns beyond those you are using; this is easily done using Format | Row | Hide and Format | Column | Hide. Ctrl+down-arrow and Ctrl+right-arrow usually move to the last row and column respectively, but will move to the last unhidden row and column if you have hidden the rest. I hope (and believe) that you will find that your mouse action is also limited to the unhidden region of your sheet. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Date Patterns
Hello, Can anyone tell me how I can get the following date pattern in my (writer) document? 15th day of March, 2014 1st day of April, 2014 2nd day of June 2014 etc. Thank you - Andrew -- 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 compatibility
Jim Seymour wrote Pedro wrote: So it's not a case that LO is not implementing the existing ODF standards but that it is already improving on them (in an open manner, unlike MS XML). So OASIS has to catch up :) OASIS establishes the standards, no? If such is the case: What you've written, above, is what we call putting the cart before the horse. And that's putting the best possible light on it. This is not how the ODF standard is developed. As Italo has indicated it happens slowly over a long time, and there are various reasons for this. There is a statement on the OASIS website (which unfortunately I cannot find at present) which indicates that in order for a new feature to be included in ODF-Next by OASIS, it must first be implemented in a few different pieces of software e.g., Apache OO, LO, and AbiWord (2+ or 3+ implementations from memory). ODF needs to be practical (based on real-world use cases) and community-driven rather than a theoretical specification developed in isolation by a chosen few. TomD wrote LibreOffice does use the ODF 1.2 and that did become an ISO standard a couple of years ago. No. The information provided by Italo up-thread is correct: italovignoli wrote ... ODF 1.2 which is in the process of becoming an ISO standard (backward compatible with ODF 1.0). Standard definitions, by their own nature, are moving slowly. Details on milestones in the ISO/IEC approval process here http://en.wikipedia.org/wiki/OpenDocument_standardization#OpenDocument_1.2 . Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/Re-LO-compatibility-tp4101492p4101650.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: Date Patterns
A wrote Can anyone tell me how I can get the following date pattern in my (writer) document? 15th day of March, 2014 As this https://forum.openoffice.org/en/forum/viewtopic.php?f=7t=65620 Apache OO forum thread indicates, ordinal suffixes are not supported in date fields. A format code of: D day of MMM, ... will give you the other elements. Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/Date-Patterns-tp4101649p4101651.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