FarPoint Spread 8.0.11 31 Fixed
Phyllis Sterlin
After doing some more research, I learned that instead of using the FarPoint 6.0 vaSpread component (non-OLEDB), the FarPoint 6.0 FpSpread component (OLEDB capable) should be used in order to automatically populate the spread sheet. However, the method to automatically populate the new FpSpread component required:
Seeing as how I already had an active connection and also needed to use certain column records in calculations to populate other columns, I decided to go with a manual spreadsheet population method using FOR loops. My code is attached below so that anyone having any similar issues can use my code for ideas.
Even though most problems related to errors assocated with FarPoint.Win.Spread.dll should be fixed if placed in the correct directory, you should carry out a quick test to confirm. We recommend re-loading Visual Studio Industry Partner Program Partner Resource DVD to test for the issue.
Some types of spreadsheets, such as ledgers, have different appearances for alternating rows. This makes it easier to see the data. Spread for Windows Forms allows you to set different appearances for multiple alternating rows.
The Spread for Windows Forms spreadsheet control can be combined with other components, such as a Ribbon control in order to provide design functionality and other control to the user. In this example, you will learn how to add a Ribbon control to a project and connect it to a Spread component in a Windows Forms application.
You can quickly design a spreadsheet component using the Spread Designer. Whether you are prototyping a complete spreadsheet component or simply customizing some aspect of an existing spreadsheet component, the dedicated graphical interface offers many features to save time and effort.
You can use built-in shapes in Spread for Windows Forms to draw attention to different areas of your spreadsheet. You can use shapes to show a process with flowchart-like graphics, use shapes to highlight a particular result, or use a shape for some other purpose.
Shapes are a form of graphics that are drawn on a separate layer from that of the spreadsheet. This drawing layer, or drawing space, is in front of the spreadsheet in the display. Shapes can be made all or partially transparent to reveal the spreadsheet behind. Because the shapes appear on this separate layer from the sheet and can be thought to float above the spreadsheet, they are sometimes called floating objects.
Some things I don't love--real lack of pockets and organization. I don't mind that in the main compartment cus it can be fixed with packing cubes, but no real outer or front pockets--where to put kindle, wires, phone, journal, pens, pack of gum, etc? My guess is you'd have to buy some kind of separate organizing pouch and have it take up space in the main compartment. Not thrilled about it, but there is room.
If you are using the focus spread method to determine your minimum best focus position and minimum taking f-stop, then your goal in setting up tilts or swings is to reduce the focus spread. So your measurement that you still had 2.75 mm of focus spread shows that you had accomplished nothing re gaining of depth of field with your tilt. Your 9 to 10 degrees of tilt was probably far too much, and probably resulted in reversing the movement of the standards for the near and far objects in the subject, showing that you had overshot in applying tilt. Probably this is what you meant by saying that you had to "move a distance back the other way about the same 2.75 mm". That was your clue that you have over applied the tilt movement.
In using the focus spread method, the vertical separation of the near and far points is not pertinant. A vertical separation of the "test" points is necessary when setting up a tilt, but not for determining your focus spread. Your focus spread should be based on the objects that you want to be in focus that most deviate from focus.
Another way to calculate the appropriate tilt angle would be to divide the focus spread on the rail (between near and far point) by the vertical distance on the gg. That also gives you the sine of the tilt angle. In this case,
Thanks again to all you for your input. After I hopefully hear back some more guidance, I will go out and try again and use very minimal (about 3 degrees?) of tilt and see what that does to limit my focus spread. Steve
Perhaps I am missing something, but with the tilt fixed, the plane of focus does not move parallel to itself. It swivels on the hinge line, at least if you focus by moving the back. If you focus by moving the front, it is a bit more complicated, but I don't believe the plane of focus moves parallel to itself.
As explained in the CSS2.1 specification, table layout in general is usually a matter of taste and will vary depending on design choices. Browsers will, however, automatically apply certain constraints that will define how tables are laid out. This happens when the table-layout property is set to auto (the default). But these constraints can be lifted when table-layout is set to fixed.
Access Violations will occur whenbound to Long Raw when size of long raw minus 118 bytes ismultiple of 32k. Farpoint has confirmed this bug and it should befixed in a maintainece release of Spread. Please contact Farpointfor more information about how to obtain a fix.
Version 1 allowed 'dirty' delete where you could delete a rowin the database that had been changed by another user. This isconsidered a bug and has been 'fixed' in Version 2. However, thismight cause your application to encounter an error when it didnot before. The error you will get is OIP 4119-Data has beenmodified (the same error as if you tried to update a row thathad been changed). If you need 'dirty' deletes, you can turn offchecking for both delete and update with the ORADYN_DIRTY_WRITEflag when you create the dynaset.
There is a known problem with the Oracle RDBMS version 7.3.2.0affecting LONG column which is fixed in version 7.3.2.2 or later.When inserting a new row into (or updating an existing row in) atable containing a LONG column, you will get error OIP4119-Data has been modified if you subsequently try and editthe same row. This is because the database is returning NULL forthe LONG column just inserted when we try to lock the row byusing SELECT ... FOR UPDATE. The data really is in the database,but cannot be accessed using SELECT ... FOR UPDATE. You shouldobtain an upgrade to your database. There are three workarounds.The first is to avoid editing the same row more than once! Thesecond is to create the dynaset using the 'DIRTY_WRITE' option.This will prevent the OIP from attempting to lock the row, buthas the disadvantage of allowing your application to edit a rowthat really was changed by another user. The third option is touse the Refresh method of the dynaset after every Update. Thismaintains data integrity but will have a severe impact onperformance. The fix for this problem is 7.3.2.2 and the rdbmsbug# is 360985.
Many businesses require the management of data, from financials to inventory, from personnel to parts ordering, and depend on customized applications to provide the user interface and the manipulation algorithms. For many businesses, simply using spreadsheets in office applications are the extent of what they can handle. As they grow, though, those same businesses must move to more advanced applications, and spreadsheet components provide a quick and proven way to make the step up.
We have created a fictitious company, Calaway-Williamson winery, to illustrate the requirements that these companies face and the solutions they have found in spreadsheet components. With a minimal amount of .NET code, you can import existing Excel spreadsheets, customize the component appearance to create a corporate user interface, and quickly develop applications that can be deployed on the Windows desktop for back-office work as well as on the Web for a mobile sales force. FarPoint recommends trying the Spread component, in both Windows Forms and ASP.NET applications, for rapid spreadsheet application development across platforms.
With so much corporate data in easy-to-use Excel spreadsheets, you do not need to lose any of that data when moving to a spreadsheet application. Simply use FarPoint Spread to open the Excel (.XLS) file, and all the data is available, including formulas, custom names, and print settings. Converting from Excel to Spread is as easy as one line of code:
There are several ways to open Excel files in Spread, and additional parameters that you can specify to determine the exact handling of the file. You can include lists of warnings during the import, you can specify the sheet name or number, you can import from a filename or from a stream. Whichever method you choose, it is a simple procedure. Another advantage of importing Excel files, besides the ability to rescue legacy spreadsheets, is the ability to prototype in Excel and then import the finished prototype into Spread.
The quickest way to see how easy it is to develop an application using a spreadsheet component is to try the trial version of the Spread product. With the downloaded Spread for Windows Forms setup, in the VB examples folder, open the fpwine-orderentry demo and see what Calaway-Williamson created. Open and run the order entry program. When you click on Enter Order, a search form appears. To enter an order, click on Find Customer; an additional list appears that displays the customers. Here is a good example showing some of the spreadsheet capability. The figure below shows the interface of the order entry program:
The code is easily edited and built inside Microsoft Visual Studio .NET. Whether you are working in C# or Visual Basic .NET, developing an application using Spread can be as easy as selecting Spread from the toolbox, placing it on a form, and writing a few lines of code to customize it. In this demo, there is a parent form that contains the menu of buttons on the left and the grapes graphic. The order entry form contains the two spreadsheets and the two buttons shown inside the parent form. This illustrates how the spreadsheet component can be used for data entry and database connection.
aa06259810