Description: HI, When I am trying to convert .csv file to pdf , using the below command, soffice.exe is adding the input file name as a heading to the output file. soffice.exe --convert-to pdf statusreport.csv --headless Is there a way to avoid soffice.exe to add the input file name to the output file heading? In our case the input file name is a GUID. So a GUID as heading in the output file is not acceptable for our customer. Hence kindly request you to show us an alternative way to avoid this. Steps to Reproduce: 1.Run this command with any CSV file: soffice.exe --convert-to pdf inputfile.csv --headless 2.The converted output file is appended with input filename as heading 3. Actual Results: The output file with heading Expected Results: Output file without heading Reproducible: Always User Profile Reset: No Additional Info: I could not find any help on this topic. Kindly help.
This behavior is not observed with other libre office file types like .odt
I don't know if it is possible to filter out the file name when it is generated. But in case that is not an option, you might be able to use pdfbox to remove it from the PDF.
Thank you Michael for the suggestion, I will try if pdfbox can solve the issue or not for our product. Thanks, Venkat
There are 3 ways to resolve this: 1. as suggested, automating header removal, which is a workaround; 2. adding option to PDF at least or any export not to use header and footer; 3. turning off header in Calc by default, which is bug 99296. This request will be resolved with 99296 so it could be a duplicate in this particular case, but I'll set New general enhancement for option 2 and rename.
Hi Timur, Thank you so much for the response. I have gone through the bug #99296. I understand that bug 99296 talks about disabling the header/footer by default. I think that in the bug they were talking about the internal sheet name getting added as header. But in our case the file name of the CSV file is getting added as header. And also when I have opened the .csv file using OpenOffice Calc(calclo.dll) v6.4.5.2 , the default header is "Sheet1" , when I tried to delete(selected "none") as header in the Edit -> Header/Footer settings and saved the file with "Keep current format" pop up dialog option selected, and reopened the file, I can see that earlier settings are not getting saved. Kindly note that in my case CSV file name is coming as header and not internal sheet name. So does Bug# 99296 handle this issue? Kindly advice. Thank you, Venkat
If header is turned off, headless convert doesn't show it also. It means that it can be turned off for ODS but not for CSV.
ok, Is there a way to disable header from below commandline? --convert-to pdf input.csv --headless --nodefault or is it possible to take this issue as a new enhancement request? Thank you, Venkat