Created attachment 182009 [details]
file where the problem happens

NOT REPRODUCED

Steps Followed
1.to enter libreOffice-Calc
2.given Data randomly (by our choice)
3.To Save the File in our System
4.Re-open the Saved File.
5.Checking The given data 
6.No changes in the data
7.No bug founded in our version.
 


ENVIRONMENT: LibreOffice7.4.0_win_X64_msi.

No problem here. Do you still see it with a newer version? Has the attached file been saved in LibreOffice before? Was it created by Microsoft Office (which version)?

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 52ebc632b3cfa122dcb178cf28d8dbc7c7c57007
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
Built on 3 February 2023

I downloaded attachment 182009 [details] posted in comment 1.

1. Open xls file in LO.
2. Save As XLS file with different name.
3. Close files and reopen them.
4. By visual comparison between both files, some cells have different background colors; e.g. S29, N30:N39 and others. In the downloaded file, these cells have background color, in the saved-as file there is no background color for these cells.

Repeating the whole set of steps, but saving as XLSX file generate the same results (but I haven't checked whether the exact same range of cells are affected).

There seems to be some FILESAVE / exporting issue.

Since my environment (OS) is different than the OP, and the other questions posted in comment 3 are still relevant, I'm leaving NEEDINFO.

Version: 7.4.4.2 (x64) / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL

(In reply to ady from comment #4)
> I downloaded attachment 182009 [details] posted in comment 1.
> 
> 1. Open xls file in LO.
> 2. Save As XLS file with different name.
> 3. Close files and reopen them.
> 4. By visual comparison between both files, some cells have different
> background colors; e.g. S29, N30:N39 and others. In the downloaded file,
> these cells have background color, in the saved-as file there is no
> background color for these cells.
> 
> Repeating the whole set of steps, but saving as XLSX file generate the same
> results (but I haven't checked whether the exact same range of cells are
> affected).
> 
> There seems to be some FILESAVE / exporting issue.
> 
> Since my environment (OS) is different than the OP, and the other questions
> posted in comment 3 are still relevant, I'm leaving NEEDINFO.
> 
> Version: 7.4.4.2 (x64) / LibreOffice Community
> Build ID: 85569322deea74ec9134968a29af2df5663baa21
> CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
> Locale: en-US (es_AR); UI: en-US
> Calc: CL

For me even Windows is fine, but I guess we have to set to NEW as we have a reproduction. I also tested with 7.4 on Linux with no issue.

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a834bbad8295cba0ca88a91a524aad48640271ec
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded

Using LO 7.4.4 (see later for newer version)...

In the same cells where there is different background color (i.e. color in the original vs. no color in the newly saved xls(x) file), there seems to be also a different Text Alignment.

Text Alignment in Cell S29:

For attachment 182009 [details] in comment 1 opened in LO 7.4.4:
Horizontal: Left
Vertical: Default

From originally downloaded, Re-saved as xls with LO 7.4.4:
Horizontal: Default
Vertical: Default

From originally downloaded, Re-saved as xlsx with LO 7.4.4:
Horizontal: Default
Vertical: Bottom

So, different export for xls, and (another) different for xlsx.



Now, using:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d8e6b488ceaff7c88856ebcfcfec14d2d8cd7652
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL threaded

Here there seems to be no change in background color (yea!) when comparing to the original (meaning that I export from the original again, using this alpha version), but there are other changes.

1. Some column width is not the same as in the original when exporting / re-saving as xlsX. This was also notable when exporting using LO 7.4.4. This difference in column width is _not_ notable when exporting to xls.

2. Cell S29 has the following Text Alignment:

For attachment 182009 [details] in comment 1 opened in this 7.6 alpha+:
Horizontal: Left
Vertical: Default

From originally downloaded, Re-saved as xls with this 7.6 alpha+:
Horizontal: Left (compare to 7.7.4, yea!)
Vertical: Default

From originally downloaded, Re-saved as xlsx with this 7.6 alpha+:
Horizontal: Left (compare to 7.7.4, yea!)
Vertical: Bottom (this seems to be forcing "Bottom" over "Default"?)

So, apparently the difference in color background seems to be solved (at some point) since 7.4.4, but the same attachment 182009 [details] in comment 1 can trigger another export difference that is not yet solved, in Vertical Text Alignment.

BTW, opening files in this 7.6.alpha seems slower than in 7.4.4.

> So, apparently the difference in color background seems to be solved (at
> some point) since 7.4.4, but the same attachment 182009 [details] in comment
> 1 can trigger another export difference that is not yet solved, in Vertical
> Text Alignment.
> 
> BTW, opening files in this 7.6.alpha seems slower than in 7.4.4.

... and column width difference. (Sorry, I forgot.)

Great, let's close, then. I created bug 153390 and bug 153391 for the other minor issues.