I want to export a .xml file into LibreOffice Calc from an AcuCobol program.
Export happened perfectly for string and numeric values. However, the date fields have a thick border around them. How can I get rid of the thick border? (I don’t want to lose the date property by converting that into a string). Please advise.
Thanks,
Aji Cherian
Hello @acherian,
Can you edit your question, and share a sample file showing what you are writing? Just leave a cell with a date with the thick border. Thanks.
Also can share the .xml file to test the import in Calc.
There could be a parent style for the “s40” style, that has the border.
Note the double end tag: </Style></Styles>.
Thanks for the suggestion. I am working on it and will keep you posted on the developments.
I stopped s40 from inheriting . After this, the cell is displayed without any border.
Then I added the below lines for all four sides.
“”
“<Border ss:Position=”“Bottom”" ss:LineStyle="
“”“Continuous”" ss:Weight="“1"”/>"
The cell with the border resurfaced again. I tried with Weight = 0, no change to the output. However, with weight 2, the thickness of the border increased. I am working on it.
I am able to generate the expected output. Thanks for the support.