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 -- 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
