Create autofilter / insert table
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
zobook · 2023-02-13 13:20

Hi, I'm trying to use FPSpreadSHeet to export a TStringGrid to Excel
(instead a plain CSV that may suffer issues with separators) and was
wondering if its posible to do the equivalent in Excel to convert
Range to Table, so when i open the XLSX file you already have the
filters/sorting enabled in the header of the range so you dont have to
do a select all -> insert -> table.

Thanks in advance.

----------------------------------------------------------------------
wp · 2023-02-13 13:24

Sorry, this is not supported, at least at the moment (and I don't have
plans to implement it in the near future unless somebody submits a
patch for it).

----------------------------------------------------------------------
zobook · 2023-02-13 13:31

Thanks. It saves me a lot of time searching for an answer that don't
exists.
 
Great tool you have made!!