Re: [libreoffice-users] Randomly lost sheet
On 14/06/15 10:38, Andrea Venturoli wrote: Which version of MS Office was used to generate the files? Hard to tell... I'd have to ask my customer and I'm not sure she knows. It's even possible in some cases [Libre|Open|Neo]Office was used. In any case I believe they've been working for some time with LibreOffice 4.3 only, and I'm sure some of the files were last saved by LO 4.3 (Mac or Windows). You should never generate XLSX files with LibreOffice, unless you need to exchange them with MS Office users. In this case, you must save the file in ODS format (more stable), and use XLSX only for interoperability. With MS Office 2013 users, you can use ODS files. You have a choice between the following formats: ECMA OOXML for MS Office 2007, Transitional OOXML for MS Office 2010, Transitional OOXML for MS Office 2013, and Strict OOXML for MS Office 2010. Each file format has peculiarities. Is there any way to tell by opening/unzipping/looking at the files? Of course not, this is part of the lock in strategy applied to pseudo standard formats. You can possibly understand it from the namespaces (which are different, but undocumented, for every version). -- Italo Vignoli - Marketing PR mobile +39.348.5653829 - email / jabber it...@libreoffice.org hangout / jabber italo.vign...@gmail.com - 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: Randomly lost sheet
Am 14.06.2015 um 12:40 schrieb Italo Vignoli: On 14/06/15 10:38, Andrea Venturoli wrote: You should never generate XLSX files with LibreOffice, unless you need to exchange them with MS Office users. In this case, you must save the file in ODS format (more stable), and use XLSX only for interoperability. With MS Office 2013 users, you can use ODS files. In fact LibreOffice should not offer to store OOXML for 2 reasons: 1) LO is not ready yet. It may produce very disappointing results or even lose data (although I don't believe in this subject line). 2) Every single OOXML file strengthens the position of the enemy who introduced OOXML for the only reason to fight our ODF standard. Microsoft Office fully supports the old doc/xls/ppt format. LibreOffice supports these file formats very well. So this is _the_ exchange format if (and only if) collaboration with MS Office users is required. Otherwise PDF is the way to go. Since rescent versions of MS Office do support our ODF formats, we should confront their customers as often as possible with our format to turn the tables on them. -- 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] Randomly lost sheet
On 06/12/15 09:59, Italo Vignoli wrote: XLSX files are always tricky, as they change for every version of MS Office. I know (and already suggested they switch to ODS). Which version of MS Office was used to generate the files? Hard to tell... I'd have to ask my customer and I'm not sure she knows. It's even possible in some cases [Libre|Open|Neo]Office was used. In any case I believe they've been working for some time with LibreOffice 4.3 only, and I'm sure some of the files were last saved by LO 4.3 (Mac or Windows). You have a choice between the following formats: ECMA OOXML for MS Office 2007, Transitional OOXML for MS Office 2010, Transitional OOXML for MS Office 2013, and Strict OOXML for MS Office 2010. Each file format has peculiarities. Is there any way to tell by opening/unzipping/looking at the files? bye Thanks av. -- 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] Inserting RTF on Template, bug?
Hi, I'm using LO 4.4.3.2 on Linux and found something that looks like a bug when inserting the attached rtf file while using the test_template.ott template (also attached). If I open LO Writer, then go to Insert - Document... - cabecera.rtf I get the result you can see in correct.png file. But, if after opening LO Writer, I open the template test_template.ott (btw an empty template), then go to Insert - Document - cabecera.rtf, the tabs on the 1nst line of the rtf are removed, getting the image shown in wrong.png. Does anyone know if there's a way to workaround this?. Is this a bug?. Regards, -- Leonardo M. Ramé http://leonardorame.blogspot.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] Inserting RTF on Template, bug?
On 14/06/15 14:18, Leonardo M. Ramé wrote: Hi, I'm using LO 4.4.3.2 on Linux and found something that looks like a bug when inserting the attached rtf file while using the test_template.ott template (also attached). If I open LO Writer, then go to Insert - Document... - cabecera.rtf I get the result you can see in correct.png file. But, if after opening LO Writer, I open the template test_template.ott (btw an empty template), then go to Insert - Document - cabecera.rtf, the tabs on the 1nst line of the rtf are removed, getting the image shown in wrong.png. Does anyone know if there's a way to workaround this?. Is this a bug?. Regards, Sorry, looks like the attached files were stripped. Here you can download them: http://45.55.143.127/lo/ -- Leonardo M. Ramé http://leonardorame.blogspot.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] Randomly lost sheet
On 06/14/15 12:40, Italo Vignoli wrote: You should never generate XLSX files with LibreOffice, unless you need to exchange them with MS Office users. *I* know (and never use anyhing else but OpenDocument). My customers know (if they listen to me and trust me). Then again, whether this knowledge has any practical effect or they still use XLS[X] is another matter... Still, besides format wars, we have a serious bug here. If XLSX is supported, it should work; losing data because it doesn't work properly is not a good thing :-( With MS Office 2013 users, you can use ODS files. MSO2013's support of ODS is still far from optimal (this of course falls again in their lock in strategy). Besides there are still many 2010s, 2007s and even some 2003 around. Is there any way to tell by opening/unzipping/looking at the files? Of course not, this is part of the lock in strategy applied to pseudo standard formats. You can possibly understand it from the namespaces (which are different, but undocumented, for every version). Thanks anyway. If I understand it correctly 4.4 is about to be published: I'll try whether this bug is gone. Still, I'm open to reports from other people who might have seen the same problem, suggestions where to look and what for, tests to do, etc... bye av. -- 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] Inserting RTF on Template, bug?
At 15:30 14/06/2015 -0300, Leonardo M. Ramé wrote: On 14/06/15 15:17, Brian Barker wrote: Your template contains a definition of paragraph style P1 including style:tab-stops / and later the reference to it: text:p text:style-name=P1 / . I'm guessing that this is why the first paragraph of your inserted file loses its tab stop and inherits the default arrangement of tab stops. Thanks!. I can't see that style in Styles and Formatting, where is it?. Neither can I - but it appears in the content.xml file in the template. o Construct a new (emptier?) template without the presumably unwanted paragraph style definition. This is what I'll do when I figure out where's the offending style. If I create a template with header and footer, I don't get any P1 and the later reference is text:p text:style-name=Standard / . Then the document imports correctly. I can't guess how you are creating P1. Are you inheriting the template from somewhere? 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] Inserting RTF on Template, bug?
On 14/06/15 15:17, Brian Barker wrote: At 14:18 14/06/2015 -0300, Leonardo M. Ramé wrote: I'm using LO 4.4.3.2 on Linux and found something that looks like a bug when inserting the attached rtf file while using the test_template.ott template (also attached). If I open LO Writer, then go to Insert - Document... - cabecera.rtf I get the result you can see in correct.png file. But, if after opening LO Writer, I open the template test_template.ott (btw an empty template), ... I don't think you can ever describe a template as empty: if it had no contents or function, you would not be using it. You are right, this empty template was just an example as clean as possible for you to test. The real template should contain a custom header and/or footer. ... then go to Insert - Document - cabecera.rtf, the tabs on the 1st line of the rtf are removed, getting the image shown in wrong.png. Your template contains a definition of paragraph style P1 including style:tab-stops / and later the reference to it: text:p text:style-name=P1 / . I'm guessing that this is why the first paragraph of your inserted file loses its tab stop and inherits the default arrangement of tab stops. Thanks!. I can't see that style in Styles and Formatting, where is it?. Does anyone know if there's a way to workaround this? o Reinsert the missing tab stop? (You can easily copy the tab stop from a subsequent paragraph - possibly using the Format Paintbrush.) I can't do that, the purpose of this it to be used in a Libreoffice headless workflow. o Construct a new (emptier?) template without the presumably unwanted paragraph style definition. This is what I'll do when I figure out where's the offending style. Is this a bug? Don't know. I trust this helps. Brian Barker -- Leonardo M. Ramé http://leonardorame.blogspot.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] Inserting RTF on Template, bug?
On 14/06/15 15:54, Brian Barker wrote: At 15:30 14/06/2015 -0300, Leonardo M. Ramé wrote: On 14/06/15 15:17, Brian Barker wrote: Your template contains a definition of paragraph style P1 including style:tab-stops / and later the reference to it: text:p text:style-name=P1 / . I'm guessing that this is why the first paragraph of your inserted file loses its tab stop and inherits the default arrangement of tab stops. Thanks!. I can't see that style in Styles and Formatting, where is it?. Neither can I - but it appears in the content.xml file in the template. o Construct a new (emptier?) template without the presumably unwanted paragraph style definition. This is what I'll do when I figure out where's the offending style. If I create a template with header and footer, I don't get any P1 and the later reference is text:p text:style-name=Standard / . Then the document imports correctly. I can't guess how you are creating P1. Are you inheriting the template from somewhere? No, just open LibreOffice Writer, then Save As - Select ODF Text Document Template (*.ott), assign a name and click Save. Uncompressed the ott file and no P1 style found. Then, I added a footer, saved as template, checked again and no P1 style found. Then added a PNG image to the footer, checked again and also no P1 style found. So, the ott file was fixed. But, I was still facing the removed tab issue, and found an error in my Python UNO script (I'm batch processing those documents using UNO scripting). Fixed my error and everything is rendering as expected. Thank you very much Brian. -- Leonardo M. Ramé http://leonardorame.blogspot.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] Randomly lost sheet
On 14/06/15 19:25, Andrea Venturoli wrote: Still, besides format wars, we have a serious bug here. If XLSX is supported, it should work; losing data because it doesn't work properly is not a good thing :-( Of course, this should not happen, and developers are working hard at looking after these problems. Unfortunately, trying to improve support of OOXML files can create side effects, generated by the complexity of the file format. Looking at the file would definitely help. Is there any chance of getting a clean copy of the file? -- Italo Vignoli - Marketing PR mobile +39.348.5653829 - email / jabber it...@libreoffice.org hangout / jabber italo.vign...@gmail.com - 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] Trouble saving from .ODS to .XLS(X)
Hi: The next file is an .ODS file: Spreadsheet_from_LibO.ods http://nabble.documentfoundation.org/file/n4151561/Spreadsheet_from_LibO.ods when I save it to .XLS(X) file format it grows ten times the file size, compared to the same file type saved with MSO: Spreadsheet_from_MSO.xlsx http://nabble.documentfoundation.org/file/n4151561/Spreadsheet_from_MSO.xlsx Is it a bug? -- View this message in context: http://nabble.documentfoundation.org/Trouble-saving-from-ODS-to-XLS-X-tp4151561.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] Inserting RTF on Template, bug?
At 14:18 14/06/2015 -0300, Leonardo M. Ramé wrote: I'm using LO 4.4.3.2 on Linux and found something that looks like a bug when inserting the attached rtf file while using the test_template.ott template (also attached). If I open LO Writer, then go to Insert - Document... - cabecera.rtf I get the result you can see in correct.png file. But, if after opening LO Writer, I open the template test_template.ott (btw an empty template), ... I don't think you can ever describe a template as empty: if it had no contents or function, you would not be using it. ... then go to Insert - Document - cabecera.rtf, the tabs on the 1st line of the rtf are removed, getting the image shown in wrong.png. Your template contains a definition of paragraph style P1 including style:tab-stops / and later the reference to it: text:p text:style-name=P1 / . I'm guessing that this is why the first paragraph of your inserted file loses its tab stop and inherits the default arrangement of tab stops. Does anyone know if there's a way to workaround this? o Reinsert the missing tab stop? (You can easily copy the tab stop from a subsequent paragraph - possibly using the Format Paintbrush.) o Construct a new (emptier?) template without the presumably unwanted paragraph style definition. Is this a bug? Don't know. 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
Re: [libreoffice-users] Randomly lost sheet
So this is an intermittent problem that is not even reliably reproducible using the same file? -- Jim -Original Message- From: Andrea Venturoli m...@netfence.it To: users@global.libreoffice.org Sent: Fri, 12 Jun 2015 0:53 Subject: [libreoffice-users] Randomly lost sheet Hello. A customer of mine reported this problem to me on Windows 7/64b with LO 4.4.3. When she opens some XLSX file (which contains from a few to a lot of sheets), sometimes one of the sheet is blank (i.e. all the cells are empty as if it was a new sheet). This is very critical, since if she does not realize this, that data is lost forever when she saves. Closing the document and reopening it usually does not show the problem again. I searched bug tracking but found no issue which seems to be like this (but perhaps I don't know what to look for exactly). Any suggestion? bye Thanks av. -- 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