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
Search found 12 matches
- Fri Feb 10, 2017 12:24 pm
- Forum: XLSReadWritwII 6
- Topic: Digitally signed VBA macros
- Replies: 2
- Views: 2266
- 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...
- 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.
- 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?
- 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.
- 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.
- 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...
- 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...
- 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!
- 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?
- 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...
- 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...