Hi,I have been asked to look into a problem with a VB6 project using the FarPoint Spread 3.0 control (spr32x30.ocx). I've found out what's causing this. There is a change event.
In the change event, the code checks whether all three columns have text in them. If they do then it makes that row un-editable and creates a new row for input.The problem I have then is that the Change event runs whenever another application is used on the users PC. If they ALT + TAB for instance to some other app, the event runs.How can I stop the change event running in this situation? The user says that this never used to happen (the app used to be in VB4 and this behaviour has occurred since it was upgraded to VB6.).
Spread COM helps you easily incorporate advanced grid and high-level spreadsheet features into your applications. It offers flexibility at the cell level for maximum control over the display and entry of the data, plenty of events to respond to user changes and an impressive feature list for everything in between; including import/export capabilities, including the ability to import and export Excel 97, 2000 and Excel 2007 files (requires the.NET Framework).
It also offers enhanced printing, many cell types, formulas, a 64bit DLL and many more features. Spread COM will allow you create a spreadsheet with up to 2 billion rows by 2 billion columns. Spread COM Features. Workbook Support - Show data in a simple grid, a single spreadsheet, or in a multiple sheet workbook. However, you choose to show data, you get a formula library, grouping, sorting, and filtering.
Farpoint Spread For Visual Basic 6.0
Spreadsheet Authoring - Whether you are working in bound, unbound, or mixed mode, users will enjoy an easy click-to-edit spreadsheet authoring workflow. Style and Formatting - Apply font, alignment, borders, and shading to cells, rows, columns, and sheets.
Farpoint Spread Manual
Apply data type formatting.