Bug 148871 - Cell Alignment Reference edge not exported to xls(x)
Summary: Cell Alignment Reference edge not exported to xls(x)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: Format-Filters
  Show dependency treegraph
 
Reported: 2022-04-30 23:04 UTC by Pierre
Modified: 2023-07-11 20:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
a) Problem b) Problem fixed c) Problem after saving file (510.89 KB, application/vnd.rar)
2022-05-01 02:14 UTC, Pierre
Details
this .is a sample xls file for test (305.50 KB, application/vnd.ms-excel)
2022-05-22 01:28 UTC, Pierre
Details
Simplified test case format cell alignment reference edge inside for xls(x) export (10.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-07-10 09:10 UTC, ady
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre 2022-04-30 23:04:05 UTC
Description:
Steps to see what is going wrong :
1. Open a file
2. set Format - Alignment - (text orientation) - Text extension inside : format is  modified.
3. Save File
4. Open file and discover it is as it was at step 1 : setting had not been saved.

Steps to Reproduce:
See steps at description section
Libreoffice has been uninstalled, and re installed.
Problem is unchanged.

Actual Results:
Format change is not saved 

Expected Results:
nothing


Reproducible: Always


User Profile Reset: No



Additional Info:
It should save the file as modified and retrieve it as it was saved.
Comment 1 Pierre 2022-05-01 02:14:29 UTC
Created attachment 179870 [details]
a) Problem b) Problem fixed c) Problem after saving file

3 Files in archive :
2022-04-29-1 Problem
2022-04-29-2 Fixing method
2022-04-29-3 Fixed (before saving file)
Comment 2 Pierre 2022-05-22 01:28:17 UTC
Created attachment 180290 [details]
this .is a sample xls file for test

1. Open the file
2. select K5:AQ6
3. set Format - Cell - Alignment - (text orientation) - Text extension inside : OK
4. see datas correctly displayed
5. Save and close file
6. Reopen the file and see it is as at step 1 : setting has not been saved !

Repeat steps 1 to 6 as many times you want. The result is the same.
Comment 3 Pierre 2022-05-22 01:35:21 UTC
problem is unchanged with version 7.3.3. x64
Comment 4 Buovjaga 2023-01-10 12:59:24 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2023-07-10 03:14:03 UTC Comment hidden (obsolete)
Comment 6 ady 2023-07-10 09:10:35 UTC
Created attachment 188291 [details]
Simplified test case format cell alignment reference edge inside for xls(x) export

I am attaching an ods file for a simplified test case.

Note: in recent Dev versions, the behavior is worse, even before saving, so ATM it cannot be really tested adequately; this should be a new bug report. Current LO 7.4 (and older) can still replicate the problem reported in this bug 148871.

STR:
1. Open newly attached ods file. Cell A1 is inclined, reference edge inside.
2. Save as xls or as xlsx.
3. Close and reopen the new xls(x) file.

Actual results:
Cell A1 > Menu Format > Cell > Alignment > (Reference edge) > should be "inside edge" as the ods file, but it is not.

Expected results (*):
Cell A1 > Menu Format > Cell > Alignment > (Reference edge) > "Inside edge" should be correctly exported when saving as xls(x).


(*) Having said that, I am not sure there is an exact 1-to-1 equivalent attribute in xls(x) format. Maybe a similar result can be achieved by setting/exporting other/alternative attributes in Excel(?).