Forum Discussion

Val M's avatar
Val M
Explorer | Level 3
3 years ago

Dates on spreadsheet showing incorrectly when previewed

I am sharing a spreadsheet prepared in Office Libre with some colleagues. When viewed on the Web dates prior to 1900 are replaced by ******* The dates do show correctly if the sheet is downloaded.
Preview
View
Web
Val M's avatar
Val M
Explorer | Level 3
3 years ago

That was the first thing I thought of but most of the data is in the form dd mm yyyy and when the year is > 1899 it displays.  When the year is earlier than 1900 it doesn't display.  it is not a width problem.   For instance, 16 May 1828 has the same number of characters as 14 Jun 1916.   The first is not shown, the second is.

Walter's avatar
Walter
Icon for Dropbox Community Moderator rankDropbox Community Moderator
3 years ago

Hey Val M, sorry to jump in, but are you still having issues with this?

 

If so, have you tried what Rich suggested perhaps?

About View, download, and export

Node avatar for View, download, and export
Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!