Search found 12 matches

by davefowle
Fri Feb 10, 2017 12:24 pm
Forum: XLSReadWritwII 6
Topic: Digitally signed VBA macros
Replies: 2
Views: 2266

Digitally signed VBA macros

Thank you for allowing the preservation of macros in .XLSX workbooks. However if they are digitally signed the output workbook is invalid.

Please can this be fixed?

Thank you
by davefowle
Fri Feb 10, 2017 12:22 pm
Forum: XLSReadWritwII 6
Topic: Bar Charts
Replies: 1
Views: 1936

Bar Charts

I am trying to change the "Values" and "Categories" of an existing bar chart to reflect new ranges on the *.XLSX worksheet, using TXLSDrawingEditorChart. However these TXLSDrawingEditorChart properties do not accept values like "$A$1:$A$27 How can I change the Values and Cat...
by davefowle
Thu Nov 03, 2016 10:49 am
Forum: XLSReadWritwII 6
Topic: VBA macros in .XLSM format
Replies: 2
Views: 2462

Re: VBA macros in .XLSM format

Thank you Lars! I look forwards to the next release.
by davefowle
Thu Nov 03, 2016 10:48 am
Forum: XLSReadWritwII 6
Topic: Cannot edit a PivotTable in group edit mode
Replies: 1
Views: 2413

Cannot edit a PivotTable in group edit mode

I use your library to create an .xlsx workbook containing a pivot table. It opens correctly in Excel 2013, but when I open it Excel2016 the message: "Cannot edit a PivotTable in group edit mode" appears and the pivot table is not created. Please can you help?
by davefowle
Mon Oct 24, 2016 10:15 am
Forum: XLSReadWritwII 6
Topic: VBA macros in .XLSM format
Replies: 2
Views: 2462

VBA macros in .XLSM format

Is there any way to preserve existing VBA modules in .xlsm format files? I want to read an .xlsm file containing VBA code add some rows of data and then save the result. At the moment (using 5.20.62) the saved file cannot be opened by excel.
by davefowle
Wed May 11, 2016 11:18 am
Forum: XLSReadWritwII 6
Topic: VBA MACRO support in .XLSM format
Replies: 0
Views: 2689

VBA MACRO support in .XLSM format

Is there any way to preserve existing VBA modules in .xlsm format files? I want to read an .xlsm file containing VBA code add some rows of data and then save the result. At the moment (using 5.20.62) the saved file cannot be opened by excel.
by davefowle
Thu Feb 13, 2014 2:56 pm
Forum: XLSReadWritwII 6
Topic: Chart series in Excel97 workbook
Replies: 0
Views: 2227

Chart series in Excel97 workbook

I am porting code from XLsReadWrite v4 to v5. All is going well, but I cannot get the modification of chart series working, e.g // Does not work missing event handler TFormulaHandler::SheetDataEvent TDrwCharts* charts = Sheet->Charts ; TDrwChart* chart ; // For all charts in a worksheet - for (int i...
by davefowle
Tue Aug 13, 2013 4:43 pm
Forum: XLSReadWritwII 6
Topic: Unknown Attributes issue again
Replies: 3
Views: 2637

Re: Unknown Attributes issue again

Dear Lars, What has happened to the TXLSDrawingChart class? You told me how to use this class back in May. Now I cannot compile my code to test your fix for "unknown attributes". In February 2012 you wrote to your customers saying "We are glad to announce the release of the final vers...
by davefowle
Mon Aug 12, 2013 12:45 pm
Forum: XLSReadWritwII 6
Topic: Unknown Attributes issue again
Replies: 3
Views: 2637

Re: Unknown Attributes issue again

The same issue with workbooks created by Excel 2013 is a "show stopper" for my customers!
by davefowle
Wed Jul 31, 2013 4:51 pm
Forum: XLSReadWritwII 6
Topic: Pivot tables in .xlsx workbook
Replies: 0
Views: 2076

Pivot tables in .xlsx workbook

Please can you tell me how to edit the ranges of an existing pivot table?
by davefowle
Fri Mar 29, 2013 1:16 pm
Forum: XLSReadWritwII 6
Topic: Reading/writing Workbooks with comments and charts
Replies: 1
Views: 2153

Reading/writing Workbooks with comments and charts

I am very impressed with this component so far, but .... With version 5.1.0.5 of XLSReadWriteII5, I wrote simple program that reads in an .xlsx workbook then writes it out again, without making any changes. If the input workbook contains comments and/or charts, then the output workbook is un-readabl...
by davefowle
Wed Nov 22, 2006 10:46 am
Forum: XLSReadWriteII 3/4/5
Topic: Making notes visible
Replies: 1
Views: 2322

Making notes visible

Dear Lars, I have just upgraded to V3 of your excellent library. My application is quite simple and I was able to integrate V3 quite quickly. I do have one outstanding issue which is: How can I make "notes" I have added to the worksheet always visible? In v2 (using borlamd c++) I coded: no...