To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49247 Issue #:|49247 Summary:|Bad formatting of an Excel spreadsheet (attached) Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P1 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|julian1106
------- Additional comments from [EMAIL PROTECTED] Fri May 13 09:37:46 -0700 2005 ------- Attached is a spreadsheet created in Excel that has its formatting completely screwed up in OpenOffice 1.9.m100 running on Windows 2000. The formatting errors are numerous, the easiest way to see them is to open the spreadsheet in Excel (I use Excel 2000 9.0.6926 SP-3 if that matters) and Calc (both at 75% zoom) at the same time and it should be immediately apparent that there is a lot wrong. In case you don't have access to Excel then I think it is still fairly easy to see the problem. It seems to me that the problems are because Calc is rendering the fonts far bigger than Excel is so they aren't fitting into the cells properly. Even more strange, it looks to me as if some cells display the right size but others don't. Look for instance at A27-A30; A27 & A30 look OK but A28 & A29 don't. Also look at A21/22 (merged) and A23/24 (merged); A23/24 looks OK but A21/22 looks wrong. Note also that the problem isn't limited to CGOmega 10 font. Cell A2 is Arial 11 and that is wrong (relative to how Excel displays it). Finally, I did try this spreadsheet on StarOffice7 (not the base OpenOffice I'm afraid, I wasn't sure if installing 2 versions of OpenOffice would mess up my PC). StarOffice renders the test spreadsheet just fine so I'm not sure if maybe something broke between OpenOffice 1 and 2, or maybe it was always broken in OpenOffice but the StarOffice people fixed it. I really hope you can sort this out because it is a bit of a show stopper as far as I'm concerned. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
