Apache OpenOffice (AOO) Bugzilla – Issue 95324
.XLS: Cell formatting "reference edge" not saved
Last modified: 2014-07-25 15:58:09 UTC
1) Create a new file 2) Write anything in any cell 3) Fill the cell with any background color 4) Format the cell with Alignment | Text orientation | Reference edge | "Text extension from lower cell border", add 45 degrees orientation 5) The cell should now have a 45 degrees tilted background color and text 6) Save the file and close it 7) Open the file 8) The background color is no longer tilted. It has reset to the default reference edge "Text extension inside cell" This happens every time you do it.
I cannot confirm it. After reload the cell has the same formatting as before saving. But I'm not sure whether it is correct at all, that the background is slanted and crosses the borders.
Hello jenf, regina, I cannot confirm it either with OOo 3.0 under Debian SID/Experimental AMD64 @regina: Maybe this is because of the 45° orientation? But I am not sure about it ... :( @jenf: Could you be so kind to attach an document to this issue, so we can have a look at it? TIA Thomas.
I (also) cannot confirm it, i.e. after reload the cell has the same formatting as before saving. FYI, after playing with the Alignment | Text orientation | Reference edge | "Text extension from lower cell border", I believe that it does look correct (i.e. to me, it looks good, it is useful, and I like it) with the background color slanted and crossing the borders.
I can *not* conform this defect. It works properly at my version: OOo 3.1/German/WinXP and it looks correct. jenf, do you still have your described problem? So, this issue should have the status WORKSFORME.
CONFIRIMED: This is true of imported XLS files and newly created files saved as XLS. Not a problem when saving as native ODF format. Steps to replicate: =================== - Create new Calc spreadsheet - insert text into cell - Adjust cell format -> alignment - rotate text -> Set reference edge to "lower cell border" / bottom - Save file (test.odf) ODF format - close file & reopen (no problem) - Save as --> test.xls (MS Office format) - close file & reopen (text.xls) file - Test is misaligned (using cell center reference) I'm using OpenOffice 3.1.0 (OOO310m11 build 9399) in Linux / Fedora 11 (ver: 3.1.0-11.3.fc11) Cross Reference this bug http://qa.openoffice.org/issues/show_bug.cgi?id=102640
So keeping this one opened as i102640 only deals with xls IMPORT and this one is about xls SAVE-EXPORT and changing Subcomponent. Confirmed also with DEV300m83 Linux X64 en-US on Mandriva 2010.0
Is that feature supported by excel?
Back to UNCONFIRMED because proof that EXCEL supports that feature is missing.
I used that feature since Office 2003.