General information
Category:
Third party products
>>>I tested the beta version 10 (on my PC). It works. The only thing I see differently (between this version and the previous one) is that the XLSX file created with Beta 10 does not show the vertical and horizontal lines separating the columns and rows. That is, the spreadsheet does not look like it has cells; but more like a report.
>>Is this by design?
>>
>>That is a new feature added to the method that was requested, to show or hide the cell lines. I added another parameter to the method, tlShowGridLines as the 6th parameter. Set this to True.
>Regarding the new parameter, wouldn't it be better if the parameter was tlHideGridLines, or if PCount() was checked and the parameter only used if it's there? That way everyone won't experience the same confusion when the grids disappear and then they find they have to change everywhere they use the code to get the original look back.
Thank you for the feedback and good suggestion. I have changed the code that adds a sheet to the workbook to default this value to True (Show Grid Lines). This was an oversight on my part -- why I am keeping this class as a beta at this time. There are a lot of changes to the code and I want to be fairly certain that it is bug free as much as possible. In the beta version there are two new methods for setting or getting this setting.
Actually this new parameter is only for the method that saves a grid (it takes the value from the grid itself) and not a table directly. So the correction above will retain the grid lines.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only