Re: [libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
On 04/23/2015 10:47 AM, Tom Davies wrote: MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. Those files are probably write only. ;-) -- 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, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Hi :) Yeh, i don't know a good way around that :( other than the way you already use! :)) People used to be quite happy with the idea of downloading Adobe Acrobat to read Pdfs with. It used to be that almost any website that shared any kind of document tended to only have them as Pdfs and also then 'had to' have a button to help people download and install an Adobe Pdf Reader. We hardly see any of that these days but that is quite a recent change. There were objections from people working in the council, or other government offices or in big companies that they couldn't install anything and thus couldn't use the format that everyone else seemed to be using so much. Now they seem to use Pdf more than everyone else, and even demand that other people use it! Regards from Tom :) On 23 April 2015 at 16:08, Ramon Tavarez ramontava...@gmail.com wrote: Hi: Thanks for your attention. The fact with this file is that can't be supported by .XLS format, and my coworkers doesn't work with LibO, and that is the only way I can use to keep in touch with them and their jobs. It may be a pain .. ... ... , but while it work I'll keep using this method to share my jobs with them! In use LibO for every document I create, even I update every version of LibO as the module for my Linux distro: Porteus. On the other hand,I can understand the situation with MSOffice and how they refuse the OpenDocument formats, but I still worry about the big file size for those files not supported by the classical file type. This can lead erroneously, as you said, to people to believe that everyone else made bad spreadsheet programs and everyone should stick with MS. Thanks. *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies tomc...@gmail.com wrote: Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer software might not fare too well on older versions of the same program but with XlsX and the other OOXML formats it even seems to happen the other way around. Save a file in MS Office 2007 and you get the same problems trying to open that file in more recent versions of MS Office. MS keep the specs for their formats secret. There is an ISO definition of OOXML but that doesn't seem to work in any version of MS Office. MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. So pretty much all programs struggle with trying to read or write XlsX or other OOXML files in any reliable way. Which version of MS Office should they aim for? Actually we had a few times where the LibreOffice user in an office has been the only person able to open files from colleagues using different versions of MS Office and has then become a kinda stepping stone for sharing files between those colleagues. Similarly with OpenOffice. Best advice seems to be to use either; 1. the older MS Office format, Xls (without the X on the end), for MS Office Xp/2000 and prior or 2. stick with Ods. Microsoft, in their 2010 version, refused to use the ODF 1.2 format that everyone else was using at the time and stuck with a mangled version of the older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to open just fine but all the formulas got replaced by fixed values. Their apparent failure somehow led to people saying that everyone else made bad spreadsheet programs and everyone should stick with MS. So it is well worth avoiding XlsX and it is probably best to use their older Xls format instead - at least if you want to open the spreadsheet on any machine other than the one with MS Office 2013 on. Regards from Tom :) On 23 April 2015 at 15:03, RamonTavarez ramontava...@gmail.com wrote: Hi: I've experienced the following issue: The file attached is an .ODS file (1,976 KB). When seved as .XLSX file it expands to more than 15 MB. If the new .XLSX files is oppened with MSOffice 2013 it will ask for recovery of information within the file, after that if we save the recovered file to the same file type (.XLSX) the file shrinks to 2,393KB. Why? OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
Re: [libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Hi: Thanks for your attention. The fact with this file is that can't be supported by .XLS format, and my coworkers doesn't work with LibO, and that is the only way I can use to keep in touch with them and their jobs. It may be a pain .. ... ... , but while it work I'll keep using this method to share my jobs with them! In use LibO for every document I create, even I update every version of LibO as the module for my Linux distro: Porteus. On the other hand,I can understand the situation with MSOffice and how they refuse the OpenDocument formats, but I still worry about the big file size for those files not supported by the classical file type. This can lead erroneously, as you said, to people to believe that everyone else made bad spreadsheet programs and everyone should stick with MS. Thanks. *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies tomc...@gmail.com wrote: Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer software might not fare too well on older versions of the same program but with XlsX and the other OOXML formats it even seems to happen the other way around. Save a file in MS Office 2007 and you get the same problems trying to open that file in more recent versions of MS Office. MS keep the specs for their formats secret. There is an ISO definition of OOXML but that doesn't seem to work in any version of MS Office. MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. So pretty much all programs struggle with trying to read or write XlsX or other OOXML files in any reliable way. Which version of MS Office should they aim for? Actually we had a few times where the LibreOffice user in an office has been the only person able to open files from colleagues using different versions of MS Office and has then become a kinda stepping stone for sharing files between those colleagues. Similarly with OpenOffice. Best advice seems to be to use either; 1. the older MS Office format, Xls (without the X on the end), for MS Office Xp/2000 and prior or 2. stick with Ods. Microsoft, in their 2010 version, refused to use the ODF 1.2 format that everyone else was using at the time and stuck with a mangled version of the older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to open just fine but all the formulas got replaced by fixed values. Their apparent failure somehow led to people saying that everyone else made bad spreadsheet programs and everyone should stick with MS. So it is well worth avoiding XlsX and it is probably best to use their older Xls format instead - at least if you want to open the spreadsheet on any machine other than the one with MS Office 2013 on. Regards from Tom :) On 23 April 2015 at 15:03, RamonTavarez ramontava...@gmail.com wrote: Hi: I've experienced the following issue: The file attached is an .ODS file (1,976 KB). When seved as .XLSX file it expands to more than 15 MB. If the new .XLSX files is oppened with MSOffice 2013 it will ask for recovery of information within the file, after that if we save the recovered file to the same file type (.XLSX) the file shrinks to 2,393KB. Why? OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:
Re: [libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer software might not fare too well on older versions of the same program but with XlsX and the other OOXML formats it even seems to happen the other way around. Save a file in MS Office 2007 and you get the same problems trying to open that file in more recent versions of MS Office. MS keep the specs for their formats secret. There is an ISO definition of OOXML but that doesn't seem to work in any version of MS Office. MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. So pretty much all programs struggle with trying to read or write XlsX or other OOXML files in any reliable way. Which version of MS Office should they aim for? Actually we had a few times where the LibreOffice user in an office has been the only person able to open files from colleagues using different versions of MS Office and has then become a kinda stepping stone for sharing files between those colleagues. Similarly with OpenOffice. Best advice seems to be to use either; 1. the older MS Office format, Xls (without the X on the end), for MS Office Xp/2000 and prior or 2. stick with Ods. Microsoft, in their 2010 version, refused to use the ODF 1.2 format that everyone else was using at the time and stuck with a mangled version of the older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to open just fine but all the formulas got replaced by fixed values. Their apparent failure somehow led to people saying that everyone else made bad spreadsheet programs and everyone should stick with MS. So it is well worth avoiding XlsX and it is probably best to use their older Xls format instead - at least if you want to open the spreadsheet on any machine other than the one with MS Office 2013 on. Regards from Tom :) On 23 April 2015 at 15:03, RamonTavarez ramontava...@gmail.com wrote: Hi: I've experienced the following issue: The file attached is an .ODS file (1,976 KB). When seved as .XLSX file it expands to more than 15 MB. If the new .XLSX files is oppened with MSOffice 2013 it will ask for recovery of information within the file, after that if we save the recovered file to the same file type (.XLSX) the file shrinks to 2,393KB. Why? OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Discussion about open formats aside, I've looked at the file and it looks like when saving as xlsx each sheet grow huge (some goes to ~20MB before compression). Could you also post the xlsx file obtained when saving with MSO, for comparison? My guess is that either LO saves *a lot* of empty/dummy cells, or that it saves in an older xlsx format that is less compact. btw this is only a by curiosity request, but it could help the dev pinpoint an issue if my first guess is correct. -- Cley Faye http://cleyfaye.net 2015-04-23 17:28 GMT+02:00 Tom Davies tomc...@gmail.com: Hi :) Yeh, i don't know a good way around that :( other than the way you already use! :)) People used to be quite happy with the idea of downloading Adobe Acrobat to read Pdfs with. It used to be that almost any website that shared any kind of document tended to only have them as Pdfs and also then 'had to' have a button to help people download and install an Adobe Pdf Reader. We hardly see any of that these days but that is quite a recent change. There were objections from people working in the council, or other government offices or in big companies that they couldn't install anything and thus couldn't use the format that everyone else seemed to be using so much. Now they seem to use Pdf more than everyone else, and even demand that other people use it! Regards from Tom :) On 23 April 2015 at 16:08, Ramon Tavarez ramontava...@gmail.com wrote: Hi: Thanks for your attention. The fact with this file is that can't be supported by .XLS format, and my coworkers doesn't work with LibO, and that is the only way I can use to keep in touch with them and their jobs. It may be a pain .. ... ... , but while it work I'll keep using this method to share my jobs with them! In use LibO for every document I create, even I update every version of LibO as the module for my Linux distro: Porteus. On the other hand,I can understand the situation with MSOffice and how they refuse the OpenDocument formats, but I still worry about the big file size for those files not supported by the classical file type. This can lead erroneously, as you said, to people to believe that everyone else made bad spreadsheet programs and everyone should stick with MS. Thanks. *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies tomc...@gmail.com wrote: Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer software might not fare too well on older versions of the same program but with XlsX and the other OOXML formats it even seems to happen the other way around. Save a file in MS Office 2007 and you get the same problems trying to open that file in more recent versions of MS Office. MS keep the specs for their formats secret. There is an ISO definition of OOXML but that doesn't seem to work in any version of MS Office. MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. So pretty much all programs struggle with trying to read or write XlsX or other OOXML files in any reliable way. Which version of MS Office should they aim for? Actually we had a few times where the LibreOffice user in an office has been the only person able to open files from colleagues using different versions of MS Office and has then become a kinda stepping stone for sharing files between those colleagues. Similarly with OpenOffice. Best advice seems to be to use either; 1. the older MS Office format, Xls (without the X on the end), for MS Office Xp/2000 and prior or 2. stick with Ods. Microsoft, in their 2010 version, refused to use the ODF 1.2 format that everyone else was using at the time and stuck with a mangled version of the older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to open just fine but all the formulas got replaced by fixed values. Their apparent failure somehow led to people saying that everyone else made bad spreadsheet programs and everyone should stick with MS. So it is well worth avoiding XlsX and it is probably best to use their older Xls format instead - at least if you want to open the spreadsheet on any machine
[libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Check the post, I've uploaded the requested file. Thanks for your interest. Regards *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail Archive] ml-node+s969070n4147063...@n3.nabble.com wrote: Discussion about open formats aside, I've looked at the file and it looks like when saving as xlsx each sheet grow huge (some goes to ~20MB before compression). Could you also post the xlsx file obtained when saving with MSO, for comparison? My guess is that either LO saves *a lot* of empty/dummy cells, or that it saves in an older xlsx format that is less compact. btw this is only a by curiosity request, but it could help the dev pinpoint an issue if my first guess is correct. -- Cley Faye http://cleyfaye.net 2015-04-23 17:28 GMT+02:00 Tom Davies [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=0: Hi :) Yeh, i don't know a good way around that :( other than the way you already use! :)) People used to be quite happy with the idea of downloading Adobe Acrobat to read Pdfs with. It used to be that almost any website that shared any kind of document tended to only have them as Pdfs and also then 'had to' have a button to help people download and install an Adobe Pdf Reader. We hardly see any of that these days but that is quite a recent change. There were objections from people working in the council, or other government offices or in big companies that they couldn't install anything and thus couldn't use the format that everyone else seemed to be using so much. Now they seem to use Pdf more than everyone else, and even demand that other people use it! Regards from Tom :) On 23 April 2015 at 16:08, Ramon Tavarez [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=1 wrote: Hi: Thanks for your attention. The fact with this file is that can't be supported by .XLS format, and my coworkers doesn't work with LibO, and that is the only way I can use to keep in touch with them and their jobs. It may be a pain .. ... ... , but while it work I'll keep using this method to share my jobs with them! In use LibO for every document I create, even I update every version of LibO as the module for my Linux distro: Porteus. On the other hand,I can understand the situation with MSOffice and how they refuse the OpenDocument formats, but I still worry about the big file size for those files not supported by the classical file type. This can lead erroneously, as you said, to people to believe that everyone else made bad spreadsheet programs and everyone should stick with MS. Thanks. *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=2 wrote: Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer software might not fare too well on older versions of the same program but with XlsX and the other OOXML formats it even seems to happen the other way around. Save a file in MS Office 2007 and you get the same problems trying to open that file in more recent versions of MS Office. MS keep the specs for their formats secret. There is an ISO definition of OOXML but that doesn't seem to work in any version of MS Office. MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. So pretty much all programs struggle with trying to read or write XlsX or other OOXML files in any reliable way. Which version of MS Office should they aim for? Actually we had a few times where the LibreOffice user in an office has been the only person able to open files from colleagues using different versions of MS Office and has then become a kinda stepping stone for sharing files between those colleagues. Similarly with OpenOffice. Best advice seems to be to use either; 1. the older MS Office format, Xls (without the X on the end), for MS Office Xp/2000 and prior or 2. stick with Ods. Microsoft, in their 2010 version, refused to use the ODF 1.2 format that everyone
Re: [libreoffice-users] display
On 2015/04/23 23:06, Paul D. Mirowsky wrote: Screen tearing issue with NVidia may be resolved by changing Vertical Sync to Adaptive. Start video at URL below at 40 seconds. https://www.youtube.com/watch?v=mFRpnQ09_LA The video is from 2013 and may not quite match, but you get the idea. Hope this helps. On 4/22/2015 11:17 AM, Thomas Blasejewicz wrote: Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Am I correct assuming, that this applies ONLY to NVidia graphic cards? My computer has an Intel HD Graphics 4600 and I cannot find anywhere a setting called vertical sync Thomas -- 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] column limit in libreoffice 4.3.something
today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier -- 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] open files
At 03:52 24/04/2015 +0900, Thomas Blasejewicz wrote: Probably another stupid question. There are no stupid questions. With a new computer running Windows8.1 I noticed, that files DO NOT open any longer, when I (double) click on their names or select them and hit ENTER ... as it used to work with all other computers / OSs in the past. I DO HAVE to open Writer, Calc or whatever and then use the open command from within the software. Like any application, LibreOffice cannot get involved until it is started. It's up to your operating system to start whatever application you want to use when you double-click a document file. LibreOffice will have set associations for .odt, .ods, etc. file types in your operating system when you installed it; you may or may not have accepted its offer to set associations for .doc, .xls, etc. file types. Is that something peculiar to Windows? No. Or another so-called improvement like the disabling of the styles menu? No. Can I change this behavior? Yes. One way is to run the LibreOffice installation again, this time accepting the offer to set associations for Microsoft Office document file types (if that is your problem). Otherwise, you can set associations individually and manually. See http://windows.microsoft.com/en-GB/windows-8/choose-programs-windows-uses-default . 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] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
That's interesting. Examining the beginning of one of the big sheets in both case, we see that LibreOffice is *very* verbose with what it save. If I understand it correctly, LO save informations about *every* cells, including empty ones. Which is very odd, since it does not do it with *every* sheets. This does not explain why MSO have to repair the files though. Maybe the devs would be interested in this test case. -- Cley Faye http://cleyfaye.net 2015-04-23 20:12 GMT+02:00 RamonTavarez ramontava...@gmail.com: Check the post, I've uploaded the requested file. Thanks for your interest. Regards *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail Archive] ml-node+s969070n4147063...@n3.nabble.com wrote: Discussion about open formats aside, I've looked at the file and it looks like when saving as xlsx each sheet grow huge (some goes to ~20MB before compression). Could you also post the xlsx file obtained when saving with MSO, for comparison? My guess is that either LO saves *a lot* of empty/dummy cells, or that it saves in an older xlsx format that is less compact. btw this is only a by curiosity request, but it could help the dev pinpoint an issue if my first guess is correct. -- Cley Faye http://cleyfaye.net 2015-04-23 17:28 GMT+02:00 Tom Davies [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=0: Hi :) Yeh, i don't know a good way around that :( other than the way you already use! :)) People used to be quite happy with the idea of downloading Adobe Acrobat to read Pdfs with. It used to be that almost any website that shared any kind of document tended to only have them as Pdfs and also then 'had to' have a button to help people download and install an Adobe Pdf Reader. We hardly see any of that these days but that is quite a recent change. There were objections from people working in the council, or other government offices or in big companies that they couldn't install anything and thus couldn't use the format that everyone else seemed to be using so much. Now they seem to use Pdf more than everyone else, and even demand that other people use it! Regards from Tom :) On 23 April 2015 at 16:08, Ramon Tavarez [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=1 wrote: Hi: Thanks for your attention. The fact with this file is that can't be supported by .XLS format, and my coworkers doesn't work with LibO, and that is the only way I can use to keep in touch with them and their jobs. It may be a pain .. ... ... , but while it work I'll keep using this method to share my jobs with them! In use LibO for every document I create, even I update every version of LibO as the module for my Linux distro: Porteus. On the other hand,I can understand the situation with MSOffice and how they refuse the OpenDocument formats, but I still worry about the big file size for those files not supported by the classical file type. This can lead erroneously, as you said, to people to believe that everyone else made bad spreadsheet programs and everyone should stick with MS. Thanks. *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=2 wrote: Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer software might not fare too well on older versions of the same program but with XlsX and the other OOXML formats it even seems to happen the other way around. Save a file in MS Office 2007 and you get the same problems trying to open that file in more recent versions of MS Office. MS keep the specs for their formats secret. There is an ISO definition of OOXML but that doesn't seem to work in any version of MS Office. MSO 2013 was the first that allowed people to save in strict but the resultant files don't seem to be able to be opened in any version of MS Office. So pretty much all programs struggle with trying to read or write
Re: [libreoffice-users] column limit in libreoffice 4.3.something
On 23-4-2015 20:39, yahoo-pier_andreit wrote: today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier - Please, define 'so low' i see 1024 columns in 4.4.something and also in 4.1.something - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) -- 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] open files
On Fri, 24 Apr 2015 03:52:24 +0900 Thomas Blasejewicz ny...@hb.tp1.jp wrote: Hello Thomas, With a new computer running Windows8.1 I noticed, that files DO NOT open any longer, when I (double) click on their names or select them and hit ENTER ... as it used to work with all other computers / OSs in the past. The clue is .. a new computer.. Chances are that .odf files aren't being associated with LibreOffice so Windows doesn't know what to do with them when you double click. IDK how to associate file types with an app in Windows, but it's probably a right click operation. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Where the grass is green and the girls are pretty Paradise City - Guns 'N' Roses -- 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] open files
Good evening Probably another stupid question. With a new computer running Windows8.1 I noticed, that files DO NOT open any longer, when I (double) click on their names or select them and hit ENTER ... as it used to work with all other computers / OSs in the past. I DO HAVE to open Writer, Calc or whatever and then use the open command from within the software. Is that something peculiar to Windows? Or another so-called improvement like the disabling of the styles menu? Can I change this behavior? Thank you. Thomas -- 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: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Cley Faye wrote: That's interesting. Examining the beginning of one of the big sheets in both case, we see that LibreOffice is *very* verbose with what it save. If I understand it correctly, LO save informations about *every* cells, including empty ones. Which is very odd, since it does not do it with *every* sheets. Yes, I also looked at it, I inspected sheet 7 (and it brought my computer to a grinding halt). It contains all the cells until column IW, which is 231 columns! As this sheet has 10423 rows, that is a lot of data. So the question is: why did it not optimize away the empty cells? -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Hi :) Good work there. Thanks for taking it to the next level Cley! Nicely done :) Posting a bug-report might be a good idea? Ramon can you do that? Regards from Tom :) On 23 April 2015 at 21:45, Cley Faye cleyf...@gmail.com wrote: That's interesting. Examining the beginning of one of the big sheets in both case, we see that LibreOffice is *very* verbose with what it save. If I understand it correctly, LO save informations about *every* cells, including empty ones. Which is very odd, since it does not do it with *every* sheets. This does not explain why MSO have to repair the files though. Maybe the devs would be interested in this test case. -- Cley Faye http://cleyfaye.net snip / On 23 April 2015 at 15:03, RamonTavarez [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=3 wrote: Hi: I've experienced the following issue: The file attached is an .ODS file (1,976 KB). When seved as .XLSX file it expands to more than 15 MB. If the new .XLSX files is oppened with MSOffice 2013 it will ask for recovery of information within the file, after that if we save the recovered file to the same file type (.XLSX) the file shrinks to 2,393KB. Why? OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html snip / http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147063.html snip / -- 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] column limit in libreoffice 4.3.something
I am using LO version 4.3.5.2. Its spreadsheet size is limited to 1G cells (1K columns by 1M rows) per sheet. I don't know how many sheets are allowed. YMMV but I know that these spreadsheet size limits are currently quite sufficient for my needs. I also know that I currently have no desire to use anything bigger since the speed of adding a data value in a single cell at a time was abysmal when I had 4K rows on each of four sheets and used less than 100 columns on any single sheet. I trimmed the document back to about 1200 rows per sheet for now but I expect it will grow to between 4000 and 5000 by the end of the year when I'll start a fresh document with a couple hundred rows. Of course much of the processing time was most likely spent evaluating some reasonably (or maybe unreasonably) complex formulas. I'm working on formula simplification but this is difficult since I often make use of the OFFSET() function to reference dynamically defined ranges of cells. -- Jim -Original Message- From: Luuk luu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 23 Apr 2015 11:54 Subject: Re: [libreoffice-users] column limit in libreoffice 4.3.something On 23-4-2015 20:39, yahoo-pier_andreit wrote: today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier - Please, define 'so low' i see 1024 columns in 4.4.something and also in 4.1.something - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) -- 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] display
Hi :) Just a quick google search gave me a couple results to try out and a forum to post questions in. https://support.mozilla.org/en-US/questions/1013828 http://lifehacker.com/disable-firefoxs-hardware-acceleration-to-fix-slowness-749344037 But i've not tried them yet and my machine is behaving remarkably well today anyway so the result might not be immediately obvious. Thanks and regards from Tom :) On 23 April 2015 at 14:21, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, I've never noticed it with Firefox on linux, but I'll keep an eye on it. Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Thursday 23 April 2015 13:50:53 Tom Davies wrote: Hi :) I'm never convinced that the settings on a new machine are perfect but i agree it is a good idea to stick with them until there is convincing enough reason to try something else. Since there was no barrage of people applauding that part of my idea it's not exactly convincing enough!! The memory part sounds plausible though and is fairly easy to change and get back to approximately default if it doesn't seem to do anything. That hardware acceleration sounds exactly perfect! Well found! I hope Firefox has something similar because that's where i get the same sort of issue on this machine. Regards from Tom :) On 23 April 2015 at 13:23, Ralf Kersanach dmbr...@furg.br wrote: Hi, I must say I have a similar behavior on my linux machine which has a similar configuration as of Thomas (apart from the SSD and windows 8.1). My graphic card is the hybrid one (NVIDIA GT-630M), processor an i7 and 8 GB RAM and 1 TB HD. I boosted my libre office (4.4.2) up to 250 MB, and 50 MB per document) and sometimes even with only one document text tearing happens. I must confess I haven't payed attention a) if the overall system memory was quite low or b) if the limit of the allocated memory usage or the per document memory reached their limit. I'll keep an eye on them to see if such behavior is consistent with low memory. Ralf On Thursday 23 April 2015 02:16:52 Thomas Blasejewicz wrote: On 2015/04/23 0:44, Tom Davies wrote: Hi :) Maybe increase the memory settings in LibreOffice? The defaults tend to be extremely low and on such a high-spec machine you can whack them right up. Tools - Options - Memory It sounds a bit like rendering issues so maybe the drivers for the graphics-'card' are not quite right. I'm very much not sure about any of that though! Regards from Tom :) On 22 April 2015 at 16:17, Thomas Blasejewicz ny...@hb.tp1.jp wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Thank you. Just increasing the memory (from 50 MB to 200 MB for LO) did not work, but while playing around in options, I found View - Use hardware acceleration. For now, that seems to improve things ... Graphics card, its driver etc. are things that have been put there by the manufacturer 2 weeks ago and I did not touch those. Here too I would like to think, that THEY know a lot better than I do ... -- 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
[libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Hi: I've experienced the following issue: The file attached is an .ODS file (1,976 KB). When seved as .XLSX file it expands to more than 15 MB. If the new .XLSX files is oppened with MSOffice 2013 it will ask for recovery of information within the file, after that if we save the recovered file to the same file type (.XLSX) the file shrinks to 2,393KB. Why? OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.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] display
Screen tearing issue with NVidia may be resolved by changing Vertical Sync to Adaptive. Start video at URL below at 40 seconds. https://www.youtube.com/watch?v=mFRpnQ09_LA The video is from 2013 and may not quite match, but you get the idea. Hope this helps. On 4/22/2015 11:17 AM, Thomas Blasejewicz wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. So, I would LOVE to believe, that there cannot be any sort of insufficient power. IS there a trick to convince the display to work smoothly??? Thank you. Thomas -- 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] display
Hi, I must say I have a similar behavior on my linux machine which has a similar configuratio as of Thomas (a part from the SSD and windows 8.1). My graphic card is the hybrid one (NVIDIA GT-630M), processor an i7 and 8 GB RAM and 1 TB HD. I boosted my libre office (4.4.2) up to 250 MB, and 50 MB per document) and sometimes even with only one document text tearing happens. I must confess I haven't payed attention a) if the overall system memory was quite low or b) if the limit of the allocated memory usage or the per document memory reached their limit. I'll keep an eye on them to see if such behavior is consistent with low memory. Ralf On Thursday 23 April 2015 02:16:52 Thomas Blasejewicz wrote: On 2015/04/23 0:44, Tom Davies wrote: Hi :) Maybe increase the memory settings in LibreOffice? The defaults tend to be extremely low and on such a high-spec machine you can whack them right up. Tools - Options - Memory It sounds a bit like rendering issues so maybe the drivers for the graphics-'card' are not quite right. I'm very much not sure about any of that though! Regards from Tom :) On 22 April 2015 at 16:17, Thomas Blasejewicz ny...@hb.tp1.jp wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Thank you. Just increasing the memory (from 50 MB to 200 MB for LO) did not work, but while playing around in options, I found View - Use hardware acceleration. For now, that seems to improve things ... Graphics card, its driver etc. are things that have been put there by the manufacturer 2 weeks ago and I did not touch those. Here too I would like to think, that THEY know a lot better than I do ... -- 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] display
Hi :) I'm never convinced that the settings on a new machine are perfect but i agree it is a good idea to stick with them until there is convincing enough reason to try something else. Since there was no barrage of people applauding that part of my idea it's not exactly convincing enough!! The memory part sounds plausible though and is fairly easy to change and get back to approximately default if it doesn't seem to do anything. That hardware acceleration sounds exactly perfect! Well found! I hope Firefox has something similar because that's where i get the same sort of issue on this machine. Regards from Tom :) On 23 April 2015 at 13:23, Ralf Kersanach dmbr...@furg.br wrote: Hi, I must say I have a similar behavior on my linux machine which has a similar configuration as of Thomas (apart from the SSD and windows 8.1). My graphic card is the hybrid one (NVIDIA GT-630M), processor an i7 and 8 GB RAM and 1 TB HD. I boosted my libre office (4.4.2) up to 250 MB, and 50 MB per document) and sometimes even with only one document text tearing happens. I must confess I haven't payed attention a) if the overall system memory was quite low or b) if the limit of the allocated memory usage or the per document memory reached their limit. I'll keep an eye on them to see if such behavior is consistent with low memory. Ralf On Thursday 23 April 2015 02:16:52 Thomas Blasejewicz wrote: On 2015/04/23 0:44, Tom Davies wrote: Hi :) Maybe increase the memory settings in LibreOffice? The defaults tend to be extremely low and on such a high-spec machine you can whack them right up. Tools - Options - Memory It sounds a bit like rendering issues so maybe the drivers for the graphics-'card' are not quite right. I'm very much not sure about any of that though! Regards from Tom :) On 22 April 2015 at 16:17, Thomas Blasejewicz ny...@hb.tp1.jp wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Thank you. Just increasing the memory (from 50 MB to 200 MB for LO) did not work, but while playing around in options, I found View - Use hardware acceleration. For now, that seems to improve things ... Graphics card, its driver etc. are things that have been put there by the manufacturer 2 weeks ago and I did not touch those. Here too I would like to think, that THEY know a lot better than I do ... -- 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] display
Hi Tom, I've never noticed it with Firefox on linux, but I'll keep an eye on it. Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Thursday 23 April 2015 13:50:53 Tom Davies wrote: Hi :) I'm never convinced that the settings on a new machine are perfect but i agree it is a good idea to stick with them until there is convincing enough reason to try something else. Since there was no barrage of people applauding that part of my idea it's not exactly convincing enough!! The memory part sounds plausible though and is fairly easy to change and get back to approximately default if it doesn't seem to do anything. That hardware acceleration sounds exactly perfect! Well found! I hope Firefox has something similar because that's where i get the same sort of issue on this machine. Regards from Tom :) On 23 April 2015 at 13:23, Ralf Kersanach dmbr...@furg.br wrote: Hi, I must say I have a similar behavior on my linux machine which has a similar configuration as of Thomas (apart from the SSD and windows 8.1). My graphic card is the hybrid one (NVIDIA GT-630M), processor an i7 and 8 GB RAM and 1 TB HD. I boosted my libre office (4.4.2) up to 250 MB, and 50 MB per document) and sometimes even with only one document text tearing happens. I must confess I haven't payed attention a) if the overall system memory was quite low or b) if the limit of the allocated memory usage or the per document memory reached their limit. I'll keep an eye on them to see if such behavior is consistent with low memory. Ralf On Thursday 23 April 2015 02:16:52 Thomas Blasejewicz wrote: On 2015/04/23 0:44, Tom Davies wrote: Hi :) Maybe increase the memory settings in LibreOffice? The defaults tend to be extremely low and on such a high-spec machine you can whack them right up. Tools - Options - Memory It sounds a bit like rendering issues so maybe the drivers for the graphics-'card' are not quite right. I'm very much not sure about any of that though! Regards from Tom :) On 22 April 2015 at 16:17, Thomas Blasejewicz ny...@hb.tp1.jp wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Thank you. Just increasing the memory (from 50 MB to 200 MB for LO) did not work, but while playing around in options, I found View - Use hardware acceleration. For now, that seems to improve things ... Graphics card, its driver etc. are things that have been put there by the manufacturer 2 weeks ago and I did not touch those. Here too I would like to think, that THEY know a lot better than I do ... -- 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, LibO 4.4] Bug on .ODS to .XLSX file conversion?
I think Piet have pointed to the source of the problem. Seems in several sheet there are cells formatted out data range. Sheet 'Análisis Pisos' seems empty but has a lot of empty comments, better delete the sheet. For a first cleaning, to do in every sheet: - Ctrl+End goes to bottom-right corner of range with data in a sheet. - Use Ctrl-M to clear any direct format for the columns right and rows down of it. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147086.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