ExcelExample.xlsx (26.6 KB)
I have a file Excel example. In sheet Class List, it have color on each row, by table design format on MS Excel. But when I open the file on Libre, it won’t work, there is no color on this table.
Can anyone help me fix it? Is it a limitation of LibreOffice?
Thanks!
Table layout (banded rows, columns, …) isn’t supported yet.
1 Like
Thank you for your support. In my knowledge, I think when I open a xlxs file on Libre, and then convert it to pdf, the output file will show exactly follow to the file open before. So, How can I convert exactly the file into pdf (same color, same table design) ?
To get exactly the same view of an xlsx file then you must use the same version of software that was used to create it.
There are differences between Calc and Excel and also between Excel files from different versions of Excel. Your xlsx file when opened in Excel 2010 looks the same as it does in Calc so you would need to buy the latest version of Excel probably.
I opened your xlsx in Google Sheets and your alternating rows were OK, sadly almost every cell in Class Schedule had #ERROR in it and no other colour.
If you only want to create alternating rows in Class List you can use conditional formatting. Select the area you want, conditional Formula is MOD(ROW();2) and apply your style ConditionalStyle_16
2 Likes
Thank you for your answer, I’m a Java developer and I want to write a program to export Excel to pdf by LibreOffice, so the answer of @erAck is perfect for me, I think I must find another solution for my problem.
1 Like
I thought there would be more to it as you had plenty of conditional formatting already so that wouldn’t be the problem. Good luck
1 Like