[libreoffice-users] Re: LO compatibility
Owen Genat wrote 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. Interesting. This means that ODF 1.2 is an OASIS approved standard since 2011 but isn't yet an ISO standard... So, I apologize to OASIS :) It's the ISO standard that takes ages... This just proves my point (going back to the comment by nabbler) that it if the bureaucracy takes so long, you can't really blame MS (or any other vendor) for not being 100% compatible. In fact it is impossible that any other office suite produces 100% compatible ODF documents since by definition LO is one of the products defining the ODF characteristics... Absurdly Microsoft (as an OASIS member) could also legitimately be producing another ODF 1.2 extended file format (valid under OASIS) but completely different from the one in LO... So, the question if m$office is compatible with the ODF standard of LO doesn't make sense ;) -- View this message in context: http://nabble.documentfoundation.org/Re-LO-compatibility-tp4101492p4101661.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] Calc: limit number of columns and rows
Brian, correct me if I’m wrong but it looks like hiding the unwanted cells makes the scrolling really slow… Thanks Lorenzo Il giorno 15/mar/2014, alle ore 20:56, Brian Barker b.m.bar...@btinternet.com ha scritto: 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 -- 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 16/03/14 09:01, Pedro wrote: This just proves my point (going back to the comment by nabbler) that it if the bureaucracy takes so long, you can't really blame MS (or any other vendor) for not being 100% compatible. No. Compatibility is measured against the standard (ISO ODF 1.0 / OASIS ODF 1.2). and not with the ODF 1.2 Extended provided by LibreOffice. Microsoft ODF implementation in MS Office 2013 is a very good one, and no one is blaming Microsoft for this. On the contrary, Microsoft can be blamed for their intentional ODF 1.1 - which has never been considered a standard, not even at OASIS - implementation in Microsoft Office 2010, because this was done to kill interoperability with OOo. In addition, Microsoft is providing a different implementation of their non standard OOXML document format for every Microsoft Office release, and this is also intentional to kill imteroperability. -- 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: Calc: limit number of columns and rows
On 16-3-2014 10:18, Lore wrote: Il giorno 15/mar/2014, alle ore 20:56, Brian Barker b.m.bar...@btinternet.com ha scritto: 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 Brian, correct me if I’m wrong but it looks like hiding the unwanted cells makes the scrolling really slow… Thanks Lorenzo not it does not make thing slow, at least it does not in my test.. How many rows/columns are in your situation? And how many cells have forumulas in them (which should not make a difference...) ? -- 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
On 16-3-2014 5:23, Owen Genat wrote: 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. It's really strange that the format '1st quarter 14' is supported and that '16th day of march' is NOT supported Please, someone, file a bug about this?!! -- 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/2014, Jim Seymour jseym...@linxnet.com wrote: 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? It seems that only yourself and IV (in terms of responses, of course!) understood correctly. Once again, these types of questions expose a strategic weakness of those seeking to see open source software increase in popularity. The original question asked whether LO is compatible with m$, hence the reciprocal question as the answer. It is not known why the original poster (HB) asked this (silly) question: is (s)he an m$ fan, read elsewhere that LO is compatible with m$ the therefore concludes that LO is a m$ to create perfect m$ documents without having to pay the m$ tax (licence fee)? If the answer is (hopefully) no, then the poster should ask LO about compatibility with m$, but instead compatibility with odf (and also ask m$ the same question!). If the original poster and other m$-fans want perfect m$ documents (a laughable concept, considering the poor quality of m$o, but that's another discussion), they should please stop complaining, stop asking and simply pay for a legal copy of m$!!! LO is not an m$-clone! It (rightly) has nothing to do with m$! The native file format of LO is odf, _not_ m$!!! It was amazing to read that there should never be an odf standard, because LO is so perfect with the rapid introduction of gratuitous new features (10-year bugs? Who cares about quality, when we have a new feature to rush out now!). This is the exact strategy of m$, netscape, etc. in the past: embrace (the standard); extend (the standard); extinguish (kill the standard!). Apparently, Oasis are at fault for being slow, methodical and serious about standards development (by definition, a rigourous, tedious and necessarily time-consuming job); therefore LO should continue to improve. As commented elsewhere, such an opinion is ignorant of the concept of the standard development process... If the default behaviour of LO is to produce documents _beyond_ the current odf standard, it's a bad idea, equivalent to the extend the standard mentality as described previously. If LO wants to see the development of odf (not necessarily the increase in LO usage: the two objectives are not equal!), so that the strategic benefit of true document compatibility is maintained, the odf standard must be the default. Users must then be made aware of any non-standard features (writing a list of these new features in the release notes is not enough and merely an expedient action). Those interested in the odf standard for future document compability and flexibility want to be able to write an odf text document today in lowriter, an openformula compliant ods spreadsheet tomorrow in localc and be able to use (in theory, not confirmed) odf-compliant gnumeric, or abiword, or kwrite, etc. 10 years from now to open those documents. Otherwise, what is the purpose of the odf standard? -- 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 10:18 16/03/2014 +0100, Lorenzo Noname wrote: Il giorno 15/mar/2014, alle ore 20:56, Brian Barker ha scritto: 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. correct me if I'm wrong but it looks like hiding the unwanted cells makes the scrolling really slow I don't find this problem. Do others? (I see already that one contributor doesn't.) Is the behaviour you see perhaps unique to your particular scrolling technique? 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
Re: [libreoffice-users] Re: LO compatibility
On Sat, 15 Mar 2014 20:49:32 -0700 (PDT) Owen Genat owen.ge...@gmail.com wrote: [snip] 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. [snip] Given the way OASIS is organized (I'm assuming the description given previously is essentially accurate in the important aspects): developed in isolation by a chosen few is a non-issue, right out of the gate. Practical implementations of a proposed standard are wonderful, but, before it's part of the standard, documents written with such extensions are, _by definition_, non-standard formats. In my opinion: LibréOffice ought not be writing documents, by default, in non-standard formats. I am disappointed to find that it does :( To add insult-to-injury: 1.2 Extended is, in my opinion, misleading. It does not clearly indicate that what it really means is 1.2 with new and improved, but non-standard, features. I'm an IT guy with many, many years experience, and, even had I noticed that buried option on my own, it would not have occurred to me to wonder I wonder if that means it's non-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
Re: [libreoffice-users] Re: LO compatibility
On Sun, 16 Mar 2014 01:01:38 -0700 (PDT) Pedro pedl...@gmail.com wrote: [snip] In fact it is impossible that any other office suite produces 100% compatible ODF documents since by definition LO is one of the products defining the ODF characteristics... [snip] Once again: Putting the cart before the horse. LO does not define the standard. OASIS or ISO (depending upon one's perspective, I suppose) defines the standard. LO's responsibility is to faithfully *implement* the standard. LO might reasonably also play testbed for proposed new standards, but that ought to be optional behaviour, explicitly chosen by the user(s), not default, out-of-the-box behaviour. At least in *my* opinion. 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] Windows-Mac compatibility
Dear all, I'm interested in experiences for cross compatibility between Windows and Mac for Calc. Is it fully compatible or only partially? I have a file on dropbox and I’m wondering if I’d be able to edit it both from my work pc and my personal mac with the same version of libreoffice. I know the best and clever way would be to try it myself, fact is my file has quite some sheets and I would like to avoid to start saving it with both machines and eventually find out in a month or so that something went bad in the process. Thanks a lot Lorenz -- 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 Sun, 16 Mar 2014 14:43:09 + e-letter inp...@gmail.com wrote: [snip] The original question asked whether LO is compatible with m$, hence the reciprocal question as the answer. It is not known why the original poster (HB) asked this (silly) question: ... [snip] I don't think the OP's original question silly. I think he or she wanted to know if LibréOffice's support for MS Office formats was compatible with those of MS Office's. A reasonable question, in my view. The poor guy or gal, rather than getting an answer to his or her question, instead ran into a buzz saw of anti-proprietary-formats sentiment, criticisms of Microsoft's behaviour and arguments about LO's implementation of non-standard standards. So, to answer the OP's original question (at least as I believe it to have meant): Kind of more-or-less. Probably more more than less :). I use the LibréOffice suite *exclusively*, and encounter few problems with the documents generated by my MS-Office-using colleagues. In fact: The only problem I've run into recently was attempting to export an MS Word document into PDF. LibréOffice Writer mangled the output. I had to resort to MS Office on my company laptop, booted into MS-Windows, accomplish the task. My experience is limited to .doc/.docx and .xls/.xlsx files. I do no PowerPoint (tho I did once do a presentation in LO's native presentation format), nor do I use the database application (Base). Is Draw able to read/write Visio files? Never even thought about that. I don't do much of that kind of thing, either. 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] Calc: limit number of columns and rows
Yes, that is possible as I'm using inertial and continuous scrolling... I guess if you scroll in steps you don't see this... Il giorno 16/mar/2014, alle ore 16:45, Brian Barker b.m.bar...@btinternet.com ha scritto: At 10:18 16/03/2014 +0100, Lorenzo Noname wrote: Il giorno 15/mar/2014, alle ore 20:56, Brian Barker ha scritto: 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. correct me if I'm wrong but it looks like hiding the unwanted cells makes the scrolling really slow… I don't find this problem. Do others? (I see already that one contributor doesn't.) Is the behaviour you see perhaps unique to your particular scrolling technique? 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
Re: [libreoffice-users] Windows-Mac compatibility
Hi, I can't vouch for Mac compatibility, but using the same version of LO on both Windows and Linux never gave me any trouble, except for fonts issues. If you are careful about using only fonts available on all your systems (or if you don't care much about this point) you can expect a smooth transition between both OS. -- Cley Faye http://cleyfaye.net 2014-03-16 15:11 GMT+01:00 Lorenzo Pii pii.lore...@gmail.com: Dear all, I'm interested in experiences for cross compatibility between Windows and Mac for Calc. Is it fully compatible or only partially? I have a file on dropbox and I’m wondering if I’d be able to edit it both from my work pc and my personal mac with the same version of libreoffice. I know the best and clever way would be to try it myself, fact is my file has quite some sheets and I would like to avoid to start saving it with both machines and eventually find out in a month or so that something went bad in the process. Thanks a lot Lorenz -- 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 03/16/2014 12:24 PM, Jim Seymour wrote: On Sun, 16 Mar 2014 14:43:09 + e-letter inp...@gmail.com wrote: [snip] The original question asked whether LO is compatible with m$, hence the reciprocal question as the answer. It is not known why the original poster (HB) asked this (silly) question: ... [snip] I don't think the OP's original question silly. I think he or she wanted to know if LibréOffice's support for MS Office formats was compatible with those of MS Office's. A reasonable question, in my view. The poor guy or gal, rather than getting an answer to his or her question, instead ran into a buzz saw of anti-proprietary-formats sentiment, criticisms of Microsoft's behaviour and arguments about LO's implementation of non-standard standards. So, to answer the OP's original question (at least as I believe it to have meant): Kind of more-or-less. Probably more more than less :). I use the LibréOffice suite *exclusively*, and encounter few problems with the documents generated by my MS-Office-using colleagues. In fact: The only problem I've run into recently was attempting to export an MS Word document into PDF. LibréOffice Writer mangled the output. I had to resort to MS Office on my company laptop, booted into MS-Windows, accomplish the task. My experience is limited to .doc/.docx and .xls/.xlsx files. I do no PowerPoint (tho I did once do a presentation in LO's native presentation format), nor do I use the database application (Base). Is Draw able to read/write Visio files? Never even thought about that. I don't do much of that kind of thing, either. Regards, Jim My initial impression was the question was vague because there are several MSO formats especially when you included the ones deprecated by MS. I was not sure if original question was badly phrased out of ignorance or to troll. I could understand that many do not understand that MS has several MSO formats and a simple question could lead to it being misunderstood. Which formats are important to the user. I still must use MSO XP formats because many people I need to send spreadsheets are still using MSO XP not the newer formats. -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Windows-Mac compatibility
On 2014-03-17 03:11, Lorenzo Pii wrote: Dear all, I'm interested in experiences for cross compatibility between Windows and Mac for Calc. Is it fully compatible or only partially? I have a file on dropbox and I’m wondering if I’d be able to edit it both from my work pc and my personal mac with the same version of libreoffice. I know the best and clever way would be to try it myself, fact is my file has quite some sheets and I would like to avoid to start saving it with both machines and eventually find out in a month or so that something went bad in the process. Thanks a lot Lorenz Hi. I have Linux and macs and have no cross-compatibility issues with LO. With my work colleagues there is no compatibility issues windows-Linux. I do however standardise fonts across machines, for instance I found the Arial on mac was different to the one on Linux causing text to flow differently, so I copied my Linux font to my mac. Steve -- 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] Windows-Mac compatibility
Steve Edmonds wrote: On 2014-03-17 03:11, Lorenzo Pii wrote: Dear all, I'm interested in experiences for cross compatibility between Windows and Mac for Calc. Is it fully compatible or only partially? I have a file on dropbox and Im wondering if Id be able to edit it both from my work pc and my personal mac with the same version of libreoffice. I know the best and clever way would be to try it myself, fact is my file has quite some sheets and I would like to avoid to start saving it with both machines and eventually find out in a month or so that something went bad in the process. Thanks a lot Lorenz Hi. I have Linux and macs and have no cross-compatibility issues with LO. With my work colleagues there is no compatibility issues windows-Linux. I do however standardise fonts across machines, for instance I found the Arial on mac was different to the one on Linux causing text to flow differently, so I copied my Linux font to my mac. Steve Have you tried the Embed fonts in the document option under the Font tab of the document Properties dialog? In some cases this can bloat the file size, but I have found it useful. Dave -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Clarification about ODF Extended
ODF as implemented by OpenOffice and then LibreOffice has always been the extended version, and not the strict standard version, although it has always been possible to choose the latter. ODF become a standard in 2006, based on OOo 2.0 (2005) file format, but OOo was already shipping some additional features which have been integrated in ODF 1.2 (consolidated in 2008, and standardized in 2011). Today, LibreOffice integrates some additional features in ODF 1.2, which will hopefully become part of ODF 1.3 (like font embedding). In general, saving as ODF 1.2 Extended does not create problem to users of other ODF compatible software, as the format is backward compatible (so font embedding will not create problems, but will not be recognized by other software). This is the reason why LibreOffice suggests ODF 1.2 Extended, and not the ODF 1.2 strict version. Being the format XML based, the tags will not be recognized if they belong to ODF 1.2, but this will not create problems to the document. -- 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] Windows-Mac compatibility
On 2014-03-17 07:32, Dave Barton wrote: Steve Edmonds wrote: On 2014-03-17 03:11, Lorenzo Pii wrote: Dear all, I'm interested in experiences for cross compatibility between Windows and Mac for Calc. Is it fully compatible or only partially? I have a file on dropbox and Im wondering if Id be able to edit it both from my work pc and my personal mac with the same version of libreoffice. I know the best and clever way would be to try it myself, fact is my file has quite some sheets and I would like to avoid to start saving it with both machines and eventually find out in a month or so that something went bad in the process. Thanks a lot Lorenz Hi. I have Linux and macs and have no cross-compatibility issues with LO. With my work colleagues there is no compatibility issues windows-Linux. I do however standardise fonts across machines, for instance I found the Arial on mac was different to the one on Linux causing text to flow differently, so I copied my Linux font to my mac. Steve Have you tried the Embed fonts in the document option under the Font tab of the document Properties dialog? In some cases this can bloat the file size, but I have found it useful. Dave I might just hold of on that for a while. The version we run doesn't support embedding, and from discussions on the list back in 2011, embedding fonts for use in editing documents was pretty much not going to happen. When it is included in the ISO certified standard for ODF I might decide to rely on it but want to wait for any repercussions on inclusion and sharing of of non licensed fonts through ODF. steve -- 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] Problems with mail merge
ubuntu 12.04 I created a google spreadsheet and downloaded it as a CSV file. I used that as the source of my mailmerge data (presumably using base is the only way to use the CSV file, so that's what I did). I used an existing MS Word file sent to me by a colleague, as my starting document, opened in Writer. I then entered various Fields from this CSV file (now converted to a base file by the mail merge wizard) into my Writer document for purposes of mail merge. The end result mail merge post processed document has the field names, no values. The original document with the fields, does not act as if it has fields - in other words, it's just plain text, not the fields I inserted. Example: I inserted Sellers Aggregate1.Sheet1.Owner's Street Address (a real field) as a field into the doc, and instead of acting like a field, it acts like normal text. I thought perhaps the spaces, periods, apostrophes and/or the length of the field name are causing the problem, but then I realized I did have one field that did not have any of those things, just a simple one word field (other than the additional things added by the mail merge/database mechanism itself). This is a critical problem for me. Thank you in advance - 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] No menus for LibreOffice install on Chrubuntu
Hi Everyone, I recently just bought an Acer Chromebook C-720, and used Chrubuntu to install Ubuntu 13.10 on it. On my other Linux machines when I do a clean install I completely purge the system of the Ubuntu LO version, and then install The Document Foundation version. I'm presently running 4.2.2.1 on them. Once Chrubuntu was installed on the Chromebook, I purged it of the Ubuntu version, which was 4.1.3.x and installed Libreoffice 4.2.2.1. However, unlike with the installs on my other machines, none of the LO apps show up in dash at all. LO does show up in synaptic. It is like before LO had the menus as part of the install where there were not any menus without installing them separately. I'm sure there are not many people doing this, but any and all suggestions would be greatly appreciated. Don -- ** -- 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: Automatically sizing cells vertically to fit contents
I'm sure that I could set automatic sizing of cells to fit their contents in Excel. I want them to increase in height as more text is typed into them. Does anybody know how to do this? I searched Nabble and Help but couldn't come up with any answers. Regards, Hedley -- Unit 2, 15 Allambee Avenue, Camberwell VIC 3124, Australia hedley.fin...@gmail.com Telephone 03 9836 4635 Mobile 0412 461 558 -- 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: Automatically sizing cells vertically to fit contents
On 2014-03-17 15:29, Hedley Finger wrote: I'm sure that I could set automatic sizing of cells to fit their contents in Excel. I want them to increase in height as more text is typed into them. Does anybody know how to do this? I searched Nabble and Help but couldn't come up with any answers. Regards, Hedley Hi. In LO here the cell automatically re-sizes. I turn on wrap automatically in FormatcellsAlignment. Ctl-Entre produces a new line in a cell. Steve -- 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: Automatically sizing cells vertically to fit contents
I have Wrap Text Automatically turned on but the cells are not increasing in height as more text is typed. Regards, Hedley -- Unit 2, 15 Allambee Avenue, Camberwell VIC 3124 Typed laboriously on my Samsung Galaxy S2 On 17/03/2014 1:43 PM, Steve Edmonds steve.edmo...@ptglobal.com wrote: On 2014-03-17 15:29, Hedley Finger wrote: I'm sure that I could set automatic sizing of cells to fit their contents in Excel. I want them to increase in height as more text is typed into them. Does anybody know how to do this? I searched Nabble and Help but couldn't come up with any answers. Regards, Hedley Hi. In LO here the cell automatically re-sizes. I turn on wrap automatically in FormatcellsAlignment. Ctl-Entre produces a new line in a cell. Steve -- 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] No menus for LibreOffice install on Chrubuntu
Hi Tom, In my conventional laptop, where LibreOffice works perfectly, if I enter soffice in the terminal, I get the following: The program 'soffice' is currently not installed. You can install it by typing: sudo apt-get install libreoffice-common In the Chromebook I get command not found. Maybe I will need to try PPA version. Everything else so far seems fine. Since I first posted, I found it doesn't want to install the repository version of Wine because of missing dependencies. On the positive side, it is blazingly fast. From boot to a fully loaded Ubuntu 13.10 in 15 seconds! Don On 03/16/2014 10:36 PM, Tom Davies wrote: Hi :) Can you get to a command-line and open LibreOffice from there? Ctrl Alt t should open a terminal console. Then the command soffice should open LIbreOffice. If it doesn't (or maybe even if it does) then hopefully the command-line should show some error messages which might give some clue about what's gone wrong. Regards from Tom :) On 17 March 2014 01:02, Don C. Myers donmy...@myersfarm.com wrote: Hi Everyone, I recently just bought an Acer Chromebook C-720, and used Chrubuntu to install Ubuntu 13.10 on it. On my other Linux machines when I do a clean install I completely purge the system of the Ubuntu LO version, and then install The Document Foundation version. I'm presently running 4.2.2.1 on them. Once Chrubuntu was installed on the Chromebook, I purged it of the Ubuntu version, which was 4.1.3.x and installed Libreoffice 4.2.2.1. However, unlike with the installs on my other machines, none of the LO apps show up in dash at all. LO does show up in synaptic. It is like before LO had the menus as part of the install where there were not any menus without installing them separately. I'm sure there are not many people doing this, but any and all suggestions would be greatly appreciated. Don -- ** -- 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