enhancements to existing spreadsheet (grid) control

Concluído Postado Mar 31, 2004 Pago na entrega
Concluído Pago na entrega

Enclosed is the sample project and the complete source code for the existing grid control that I need enhancements done to it. Must add to it instead of redoing it from scratch.

Here are the enhancements needed

1. add disablecell method. The parameters for it would be row number and column number

2. adding the ability of adding additional controls to the grid. The 3 controls needed are labels, command button, and checkboxes. When using those methods, if doing an entire column, need to do it in a way that instead of loading 100's or 1000's of checkboxes, labels, etc, do it in a way where it only loads what can be seen by sight and then somehow move it (the control needs to handle all of that). They will all need to have the standard properties (enabled, value, caption, click event for command, etc.). For the click event for the command button, the parameters would need to be tag, caption, the row number and the column number.

3. fix the part where if aligned to the left and I click on one then click on something not on the control focus, then have it line up properly. Currently it does not.

See on deliverables for more information.

## Deliverables

4. add an addition method. For it the parameters would be the range (numberto, numberfrom, either row or column). Would only consider numbers only. Must return not an integer but the actual number even if there are decimal places. For example, if the numbers are from 1 to 8, column and column 2 is not a number, it would not consider 2 in the calculation at all.

5. add an average method. Same thing but to figure out the average of the values. If for example the parameters are 1 to 8 and there is no number in 2 then it would divide by 7.

6. have the ability to insert a column or row in the middle of the grid. If its added on 3 then everything on 3 and beyond for column headers would be moved one column to the right.

7. have the ability to bypass the code to focus the next cell.

Currently, when using the mouse, enter, or tab, it moves to a different cell. However, if there is code in the leavecell event and it says to focus on something else, use it instead of the predefined code. Otherwise, follow normal rules

8. a property to show whether the grid is focused or not. When it leaves focus, the property would be false.

9. an event when clicking on the entire row or column. The parameter for it would be the row number or column number

I need all of these put into the sample project so I can see how it works. Let me know if you have any further questions. Must all be coded with Visual Basic since the original was in Visual Basic. Please let me know if you have any questions.

1) Complete and fully functional updated OCX control source code and compiled OCX

2) The updates to the sample application (source code only) to show all of the old functions in addition to the new functions

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP Home Edition, Windows 2000

PHP

ID do Projeto: #3154958

Sobre o projeto

2 propostas Projeto remoto Ativo em Mar 31, 2004

Concedido a:

vba66avbv

See private message.

$170 USD em 10 dias
(52 Comentários)
5.9

2 freelancers estão ofertando em média $128 nesse trabalho

gopikap

See private message.

$85 USD in 10 dias
(54 Comentários)
5.1