Created attachment 49536 [details] testdata to be opened in kspread Version: svn (using KDE 4.4.3) OS: Linux Testdata is created using MSOffice 2007. Text in the cells is aligned in Horizontal Center , Vertical Top. Reproducible: Always Steps to Reproduce: 1. Open the attached document in MSOffice 2007 2. Open the same document in KSpread. 3. Observe the alignment of the text in the cells. Actual Results: KSpread is unable to align the text in Horizontal Center and Vertical Top. Horizontal Center is not retained. Expected Results: KSpread should be able to align the text in Horizontal Center and Vertical Top. Horizontal Center should be retained. SOFTWARE VERSION: Kubuntu 9.10 Koffice (svn revision 1154943) Test document (MSOffice 2007): me07_text_alignment_hc_vt_format.xlsx
Created attachment 49537 [details] screenshot of the document in kspread
Created attachment 49876 [details] ods testdata to be opened in kspread Horizontal center alignment is not retained when an ods document is opened using kspread. Attaching the testdata created using OpenOffice.
Created attachment 49877 [details] koconverter converted testdata Converted the xlsx test data to ods by using koconverter. oocalc loads the converted file correctly and retains the horizontal center alignment. Guessing it to be a core issue. Attaching the converted testdata.
SVN commit 1175983 by mkruisselbrink: make center-aligned text work again BUG: 245919 M +2 -0 CellView.cpp WebSVN link: http://websvn.kde.org/?view=rev&revision=1175983
verified in rev 1177329. Thanks!