We're making changes to the Community, so you may have received some notifications - thanks for your patience and welcome back. Learn more here.
Forum Discussion
Val M
2 years agoExplorer | Level 3
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.
- Val MExplorer | Level 3
I have made a sample if you go to
you can see it. Sorry, they are hashtags, not asterisks. If you download it, it will show correctly.
Thanks,
Val
- RichSuper User II
Val M wrote:
I am sharing a spreadsheet ... When viewed on the Web dates prior to 1900 are replaced by ******* The dates do show correctly if the sheet is downloaded.
A spreadsheet, whether it's Excel, LibreOffice, etc., typically displays ######## when the content of a cell is wider than the column. The screenshot below shows a preview of an Excel file with dates for 2023 in two columns (same dates in both columns), with the second column widened in Excel to show the full content of the cell. The first column isn't wide enough so the content is replaced with ########.
Since the column width of the preview page is fixed, there's no way to widen the column to show the full content of those cells. In this case, you'll need to widen the cell in LibreOffice before saving, or download the file and open it in LibreOffice to see the full content.
- Val MExplorer | Level 3
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.
About View, download, and export
Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.
Need more support
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 or Facebook.
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!