Issue 95324 - .XLS: Cell formatting "reference edge" not saved
Summary: .XLS: Cell formatting "reference edge" not saved
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.0
Hardware: PC All
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-10-22 17:13 UTC by jenf
Modified: 2014-07-25 15:58 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description jenf 2008-10-22 17:13:37 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.
Comment 1 Regina Henschel 2008-10-22 20:49:58 UTC
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.
Comment 2 thackert 2008-10-30 19:05:48 UTC
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.
Comment 3 kennedy1ed 2008-11-04 02:24:37 UTC
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.
Comment 4 lendo 2009-06-10 10:53:11 UTC
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.
Comment 5 dymaxion 2009-07-26 10:14:33 UTC
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
Comment 6 gibi 2010-06-24 17:53:59 UTC
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
Comment 7 Rainer Bielefeld 2014-03-14 19:03:36 UTC
Is that feature supported by excel?
Comment 8 Rainer Bielefeld 2014-04-24 14:31:06 UTC
Back to UNCONFIRMED because proof that EXCEL supports that feature is missing.
Comment 9 m.valverde 2014-07-25 15:58:09 UTC
I used that feature since Office 2003.