Tag Archives: officewriter 8.3

Q&A with Product Owner Alison on What’s New in OfficeWriter 8.3

What’s New in OfficeWriter 8.3

We sat down with our Product Owner Alison to give you a more detailed overview of the features released in OfficeWriter 8.3. Covering topics of CopySheet to Azure to Pivot Tables, she lays out what went on behind-the-scenes in this latest release.

Bonus: A sneak preview of what is on the horizon for OfficeWriter 8.4. Watch below:

For more information on how to become a reviewer for our Power Pivot API please contact us at contact@softartisans.com or throw a tweet our way @officewriter.

To leave user feedback, check out our latest site, OfficeWriter Asks, where we ask you what you’d like to see in future product releasesOfficeWriter Asks

New in OfficeWriter 8.3: Auto Filters and More!

OfficeWriter 8.3 is filled with exciting new features. Here are some of our favorites:

Auto filters in ExcelApplication

Auto filters are an easy way to view and filter data in a worksheet, and now you can add them programmatically with ExcelApplication in XLSX and XLSM files!

All you need to do is create an area on the worksheet where you want the auto filter to be, then apply the auto filters to that area. This works on data sets that already have data, and data sets that just have ExcelTemplate data markers.

wksht.AutoFilter.Area = wksht.CreateArea("A6:D14");

Remember, you only get one set of auto filters per worksheet, so if you set the auto filter to a new area, you’ll lose your original filters. Continue reading New in OfficeWriter 8.3: Auto Filters and More!