LGS Member Licensed User Longtime User Nov 1, 2022 #1 Hello everyone. I am using XLUtils , where the cells with data I put the corresponding borders. But I haven't found how to programmatically hide excel grid lines. To show it like this: I appreciate the support
Hello everyone. I am using XLUtils , where the cells with data I put the corresponding borders. But I haven't found how to programmatically hide excel grid lines. To show it like this: I appreciate the support
Solution Erel Nov 1, 2022 B4X: sheet.PoiSheet.As(JavaObject).RunMethod("setDisplayGridlines", Array(False)) sheet.PoiSheet.As(JavaObject).RunMethod("setPrintGridlines", Array(False))
B4X: sheet.PoiSheet.As(JavaObject).RunMethod("setDisplayGridlines", Array(False)) sheet.PoiSheet.As(JavaObject).RunMethod("setPrintGridlines", Array(False))
Erel B4X founder Staff member Licensed User Longtime User Nov 1, 2022 #2 B4X: sheet.PoiSheet.As(JavaObject).RunMethod("setDisplayGridlines", Array(False)) sheet.PoiSheet.As(JavaObject).RunMethod("setPrintGridlines", Array(False)) Upvote 0 Solution
B4X: sheet.PoiSheet.As(JavaObject).RunMethod("setDisplayGridlines", Array(False)) sheet.PoiSheet.As(JavaObject).RunMethod("setPrintGridlines", Array(False))