fpspreadsheet, Excel-specific workbook properties
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
HHick123 · 2016-11-30 08:49

Hi,
fpspreadsheet works very well for me. :-)

Unfortunately I have a view remaining requirements, that I could not
solve until now. But I think maybe the are out of scope at
fpspreadsheet (and should be because they are Excel-specific).

In an xlsx file saved by fpspreadsheet...
(a)  ...I would like to automativcally set an Excel-Autofilter-Row

(b)  ...I would like to automativcally hide some Columns
(b)  ...I would like to automativcally set "worksheet protection" such
that the user cannot modify some cells

Has anyone got an idea?
Maybe there are other solutions beside fpspreadsheet (but an Excel
installation must not be required)?

Regards, Helmut

----------------------------------------------------------------------
wp · 2016-11-30 10:00

At the moment I don't have plans to implement these features.

Did you try this: http://avemey.com/zexmlss/index.php?lang=en ?

----------------------------------------------------------------------
SeregaKR · 2018-05-14 09:56

Quote from: HHick123 on November 30, 2016, 09:49:01 am
(b)  ...I would like to automativcally set "worksheet protection" such
that the user cannot modify some cells

It's already there) At least in current svn version