Do you want to: Report a bug?
OS version: Win 10 Pro 22H2
App version: 7.5.0.127 (x64 exe)
Downloaded from: ONLYOFFICE website
I was trying to save a spreadsheet as a PDF.
But it is not working well as the date fields always end up as “########” irrespective of the amount of space provided in the column.
I do this every year, annual tax & auditing requirements, but I don’t think I used OO last year, it was probably Excel or Libre, in any case, the spreadsheet was originally from one of them, and gets copied and data replaced for the new year.
On screen, I see;
which shows ample space for the dates.
But when I view the resultant PDF, I see;
The result is the same whether I use “Export to PDF”, "Save as PDF’, or “Print to PDF”.
Even the preview display in the Print dialogue shows some sense.
Now here’s the interesting part…
After I saved the file from OO Spreadsheet, Recycled OO, re-opened the spreadsheet, and tried again, the date columns rendered as dates as expected.
Conclusion?
A discrepancy between Excel Data date storage, and OO Spreadsheet Data format data storage? No enough to prevent display, but enough to complicate PDF rendering.
I have no idea exactly what transpired here. Does anyone else?
@MKVRC
Did you originally create the spreadsheet in MS word too?
In my case, as I mentioned at the end, the issue resolved itself after the spreadsheet had been saved, closed, re-opened in OO.
That made me suspect that the date print format is related to some subtle conversion.
The conversion idea came when I created a new OO speadsheet, filled it with date data, and it rendered in PDF perfectly in the first instance.
@MKVRC
Interesting.
Although not identical environmental conditions, the fact that you had perfect PDF output on first load into OO from Excel without an intervening reload would certainly indicate more investigation is required.
I’ve seen and documented instances where OO Word rewrote a significant portion of the MS Word data when it saves that kind of document, I suspect it may be doing the same with spreadsheets.
But that level of investigation is quite time consuming, and I haven’t started yet. So I was more curious if the incident had precedence.
But given time, I may still look into the details in depth as Numbers →Excel→OO Sheet on MacOS may not be identical to Excel→OO Sheet on WinOS.
You are welcome and thanks for additional details…please see my response inline.
Although not identical environmental conditions, the fact that you had perfect PDF output on first load into OO from Excel without an intervening reload would certainly indicate more investigation is required.
I tried “Export to PDF” and "Save as PDF’ options few times to test and outcome was fine every time.
I’ve seen and documented instances where OO Word rewrote a significant portion of the MS Word data when it saves that kind of document, I suspect it may be doing the same with spreadsheets.
This is new info to me and I have not come across this situation so far…
But given time, I may still look into the details in depth as Numbers →Excel→OO Sheet on MacOS may not be identical to Excel→OO Sheet on WinOS.
Well so far majority of excel (.XLSX) what I have, were initially created in Mac Numbers in Numbers format (Mac spreadsheet format) then exported them to excel format (.XLSX), for a while I used MS excel to work on these and then used Libraoffice and SoftMaker Office (all on Mac OS)
And have reported whatsoever issues seen in these excels with respect to onlyoffice so far….
Once you are done with your detailed analysis do share more details….thanks
… and you probably never will unless you go looking for it. OO Word wasn’t changing any of the content of the document, just adjusting the XML containers that surround every piece of content. One doesn’t see any of this unless you dismantle the document into its various sub-components, of which there are many. Lots of many
Got a similar issue here:
during PDF-export some numbers get rendered as ###### even though the columns are wide enough. Even some text is just cut off so have the cell is rendered empty/white.
Document was not imported but directly created with OO Version 7.5.0.127 on Manjaro
Any ideas appreciated.
This is the document:
(I can only upload one picture)
