Bug 148871

Summary:	Cell Alignment Reference edge not exported to xls(x)
Product:	LibreOffice	Reporter:	Pierre <contact>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, contact, ilmari.lauhakangas
Priority:	medium	Keywords:	filter:xls, filter:xlsx
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108254
Attachments:	a) Problem b) Problem fixed c) Problem after saving file this .is a sample xls file for test Simplified test case format cell alignment reference edge inside for xls(x) export

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)

(In reply to Pierre from comment #2)
> 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

I can't get them to correct. I change Horizontal to Center and Vertical to Middle. No effect for the diagonal lines. Is this about the lines being diagonal or something else? It is not clear from the report or the images. The images made me think the diagonal lines are bad.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f1d00da1bb16330bef9316a3e4f04506f9bb862f
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo
Built on 10 January 2023

Comment 5 QA Administrators 2023-07-10 03:14:03 UTC Comment hidden (obsolete)

Dear Pierre,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping

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(?).