#1

Excel created have word wrap enabled but Libre dont adjust the row height correctly.

The words are overlapped when converted to pdf.

#2

Do you have the font that the spreadsheet uses installed on this computer? If the font box shows the font name in italics then it isnā€™t installed and a substitute font will be used which might have different metrics.

Arial or Times New Roman are normally OK even if not installed as the substitute should match well anyway.

#3

default font is in screenshot

image
image1489Ɨ341 53.5 KB

#4

this is how it looks like after export to pdf

image
image1919Ɨ657 300 KB

#5

Could you upload such a file (or a fragment of a file) that demonstrates the described behavior?

#6

Please find the file
Battery AssemblyNewCheck (1).xlsx (8.0 KB)

#7

Part of the problem is (similar to) tdf#152870 - that the invisible content is visible. Interesting is that itā€™s in Calc, while the bug is for Writer.

Ignoring the optimal row height property in the document is another bugā€¦

1 Like
#8

I guess Iā€™ve seen this also in printing from Calc, but just thought I forgot to set optimal row height. Iā€™ll have to try to find that fileā€¦

#9

ā€¦ which is even a regression in LO 3.6.

tdf#157468

1 Like
#10

Thank you. The reasons for the problem are explained above.
Workaround - Select rows 1-9, select ā€œOptimal heightā€ from the context menu and OK.

#11

@sokol92 As I am using headless to convert to pdf hence will not be able to make any change in the document before convert .

#12

Actually, if we are talking about the possibility of a workaround (until the mentioned bug is fixed), then it will actually be possible to make

1 Like
#13

This was in fact tdf#123026, fixed in v.24.2 (next Feb).

#14

Do I need to wait till feb 2023? OR can you please suggest workaround for headless conversion of such files into pdf?

#15

See the previous comment by JohnSUN. Youā€™d have to trigger running a macro from the command line.

#16

ā€¦and this macro will set the desired row height, possibly change some other parameters (for example, page parameters for export) and export the file to PDF.

#17

Can you please explain more with example?

#18

For example, in the Standard library, in the My Macros section, you create a module XlsxToPDF and place a procedure there that looks something like this:

Option Explicit 

Sub cvrtToPDF(sFileName As String)
Dim oSheets As Variant, oSheet As Variant
Dim i As Long
Dim oDoc As Variant
Dim oCursor As Variant, aTemp As Variant
Dim aArgs(0) As New com.sun.star.beans.PropertyValue
	GlobalScope.BasicLibraries.LoadLibrary("Tools")
	If Not FileExists(sFileName) Then Exit Sub 
	sFileName = ConvertToURL(sFileName)
	aArgs(0).Name  = "Hidden"
	aArgs(0).Value = True

	oDoc = OpenDocument(sFileName, aArgs)
	If IsNull(oDoc) Then Exit Sub 
	oSheets = oDoc.getSheets()
	For i = 0 To oSheets.getCount()-1
		oSheet = oSheets.getByIndex(i)
		oCursor = oSheet.createCursor()
		oCursor.gotoEndOfUsedArea(True)
		oCursor.VertJustify = 1	' Hope that it will be enough`
	Next i
	aTemp = Split(sFileName, ".")
	aTemp(UBound(aTemp)) = ".pdf"
	sFileName = Join(aTemp,".")
	aArgs(0).Name  = "FilterName"
	aArgs(0).Value = "calc_pdf_Export"
	oDoc.StoreToUrl(sFileName,aArgs)
	oDoc.close(True)
End Sub

And now the command line like

"<path to LibreOffice folder\program\soffice.exe"  --headless --nologo "macro:///Standard.XlsxToPDF.cvrtToPDF("""full path\Battery AssemblyNewCheck (1).xlsx""")

will do the job

2 Likes