Why doesn't calc format correctly a simple spreadsheet which opens correctly in Excel 2000? [closed]

asked 2016-02-15 16:12:23 +0200

SEVENHILLS gravatar image

updated 2020-08-02 14:20:58 +0200

Alex Kemp gravatar image

I periodically download a spreadsheet from a financial institution; Calc always prompts me for "Import Options" such as Language and an option to detect special numbers (such as date). After having entered this information I get a spreadsheet with lousy formatting. Columns are all narrow and of equal width (0.89"), everything is aligned center, including both text and numbers, text is not wrapped, cells that should have a background color and different font color don't, the font is Liberation Serif instead of Arial, currency values that are negative are in Red and in Dollars instead of Euros, dates are in mm/dd/yyyy format instead of dd/mm/yyyy. If I open the same spreadsheet in Excel 2000 everything is perfect. Can anybody shed some light?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-20 12:53:36.461532