Hi :) Weirdly i just re-opened that xls and this time it did get the heights correct, even before i tried setting the default font size. I do have a lot of the settings in
Tools - Options "+ Load/Save" set to maximise compatibility with MS Excel. Regards from Tom :) ________________________________ From: El Cico <elcico2...@yahoo.it> To: users@global.libreoffice.org Cc: mrelw...@yahoo.com Sent: Sat, 23 July, 2011 0:42:38 Subject: Re: [libreoffice-users] Incorrect row height when opening a Calc file. >Da: Tom Davies <tomdavie...@yahoo.co.uk> >A: users@global.libreoffice.org >Inviato: Ven 22 luglio 2011, 23:45:30 >Oggetto: Re: [libreoffice-users] Incorrect row height when opening a Calc file. >Hi :) >Yes it's fixable but it shouldn't break in the first place. A double click on >the line between any 2 rows adjusts all the rows to their optimal height once >the entire sheet has been selected with Ctrl A or as described by Joe so it's >very quick to fix but that needs to be done every time the spreadsheet is >opened > > >when saved as xls. >Regards from >Tom :) ________________________________ From: JOE Conner <joeconner2...@gmail.com> To: users@global.libreoffice.org; mrelwood <mrelw...@yahoo.com> Sent: Fri, 22 July, 2011 22:05:59 Subject: Re: [libreoffice-users] Incorrect row height when opening a Calc file. On 7/22/2011 1:24 PM, Tom Davies wrote: > Hi :) > Ouch. That is really inconvenient. Please could you post a bug-report about > it? > http://wiki.documentfoundation.org/BugReport > Regards from > Tom :) > > > > > ________________________________ > From: mrelwood<mrelw...@yahoo.com> > To: users@global.libreoffice.org > Sent: Thu, 21 July, 2011 23:52:02 > Subject: [libreoffice-users] Incorrect row height when opening a Calc file. > > I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file > now on OSX 10.7, OpenOffice shows the document correctly (row height > 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes > about a third of the text to be chopped off. > > The issue appears in about 7% of my .xls files, and on some the text is > chopped just slightly. It's not a big deal to re-adjust the row height for a > few documents, but this might be something the devs would like to look into. > > One of the files with the issue can be found at: > http://db.tt/uBzFayj > > >You can adjust height and width of all rows and columns simultaneously. >Click the space at the corner, top of the row numbers, left of the >column letters (this selects the entire spreadsheet) >next drag the first row bottom line downward as much as you like. It >will adjust all rows. Same for columns. >Joe Conner, Poulsbo, WA USA - - - Hello all, I'm not sure this is what you want, but if you change the character size of your default style, you can open your documents with the right row height. You can do this through the "style and formatting window" (F11), editing --> default (right clic it) and then --> character size. If you just want to use this for certain documents, you can create a model with your desired height. Here is your file with trebuchet size 16 as default. http://dl.dropbox.com/u/9434397/Tapsa%20Kansa%20-%20Paattyneet%20on%20Paivat%20-%20F.xls Namastè! cico :) -- Unsubscribe instructions: E-mail to users+h...@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 -- Unsubscribe instructions: E-mail to users+h...@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
