Cell default format (currency) not saved

[libSW22]

I have a column in several spreadsheets of a libre calc 7.3 .xlsx file that is formatted US$, yet everytime I make a new entry it reverts to date format(12/31/99), which is the format of the cell to the left. This file is for entering the date and amount of financial transactions.

Curious thing is if I enter the transaction dollar amount first then the correct formatting is saved(top cell of attachment). Why is entering the date before the dollar amount affecting the formatting in the currency cell?

Date was entered 1st in bottom cell of attachment.
Thanks

[Hrbrgr]

It could be a compatibility problem between
ODS and XLS / XLSX .

Basically:

Recommendation for clean working with LibreOffice when different Office programs are used.
Always create and save your files in LibreOffice and save them in ODF format (ODT, ODS, etc.).
Always keep these files as their source.
If you need other formats for distribution to partners, you can open an ODF file and save and distribute another format with ″ Save as… ″.
This way, you always have working files available in your system environment.

See:

Edit different file formats in LibreOffice

---

Please report the behavior as a bug in Bugzilla .

See also:

How to Report Bugs in LibreOffice .

Please post the link from the bug here.
format: tdf#nnnnnn (use only the number, not the link)
To do this, edit your initial question. Thank you.

---

You can also try formatting your cells.

Cell Styles in Calc

[mikekaganski]

@libSW22

libre calc 7.3 .xlsx file

Please note that there is no such thing as “Calc XLSX file”. XLSX is a MS file format, and Calc only supports that external file format to some (always incomplete) extent (Calc’s native file format is ODS). Also, there might be some inherent format limitation: not every Calc feature is available in Excel, and thus, in Excel’s file formats. It could be such a thing.

[sokol92]

@libSW22, if you upload your “weird” file, the diagnosis will no doubt be more accurate.

[libSW22]

example.ods (23.9 KB)
@sokol92 uploaded redacted sheet from the file exhibiting the same behavior , in ods format per the other responders to this post (unable to mention both being a new member) .

[sokol92]

Let’s do it together.

1. Open your file.
2. Enter any date in cell A12 (for example, today), press Enter.
3. Enter the number 1 in cell B12, press Enter. I see $1.00 in the cell, do you?

[libSW22]

[Hrbrgr]

[sokol92]

Please try
Menu / Tools / Options / LibreOffice Calc / General. Uncheck option “Expand formatting” in “Input settings”.
See also Expand formatting here.

[libSW22]

I entered the number 1

[sokol92]

Did the recipe from my previous post (edited) help?

[libSW22]

This worked not only for .ods file but .xlsx as well! Thanks!