Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VfpxWorkBookXlsx
Message
From
03/10/2020 21:34:19
 
 
To
03/10/2020 09:13:26
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01676306
Message ID:
01676451
Views:
70
>>>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
Map
View

Click here to load this message in the networking platform