Differences between revisions 51 and 52
Deletions are marked like this. Additions are marked like this.
Line 7: Line 7:
= Milestones =

 * '''Deadline:''' Week of 18-Jul
   * Deliver a completed and tested version that can be used in production.

= Immediate Items to Complete =

 1. '''JS''' Complete the following:
    * Implement Excel 2003 menu 		= Implementation and Bug Fixes =

== Bug Fixes ==

 1. '''AH''' - Diagnose errors reported by GMM
 1. '''AH''' - Implement highlighting of deleted records in ''Refresh Row''
 1. Fix display of Umlaut characters in error messages

== Implement New Functionality ==

 1. Design for document links
 1. Implement ''Preufdauer'' menu and handling of ''Delta-4'' field
 1. Implement document links for ''Grundlagen'' documents. ''tech GL'' and ''WV GL'' fields.
 1. Implement document links for ''Stellungnahmen'' and ''Pruefberichts'' documents. ''Stn-Nr'' and ''Pruef-Nr'' fields.
 1. Implement document links for ''QA-Eklaerung'' documents

== Login/Logout/Exit ==

 1. Gracefully handle when user not logged in
    * Implement routine to catch and report not being logged in
    * All menu items that access server should be able to respond to a non-logged in error
 1. Trap Excel-Quit and ask user if unsaved records should be saved ''(design needed)''
 1. Implement login timeout
 1. Implement code that reacts correctly to auto-logout. E.g. session-timeout
    * Implement a heartbeat function to prevent session timeout?
 1. Check user roles and disallow login if certain roles not present
 1. Login in a specific contract?

== Search ==

 1. In search form implement ''Gruppe'' menu with dependency on ''Bereich'' menu ''(design needed)''
 1. Change ''New Worksheet'' checkbox to ''Clear Existing Sheet'' in ''Search'' and ''Test Cases''
 1. Implement named baskets (Design needed)
    * User can select a named basket download its contents
    * Make sure all calculate fields are readonly
 1. Mark row as ''un-savable'' if revision sequence is incomplete?

== Attributes Lists ==

 1. Separate ''Refresh Attributes'' into:
    * ''Refresh Attributes''
    * ''Refresh Users and Roles''
 1. Shorten attribute lists ''(design needed)''
    * Via server-side configuration?

== Implement Improved Revision Processing ==

 1. Reject revision ''(design needed)''
 1. Sub-revision processing ''(design needed)''

== Internals ==

 1. Implement new ''Magic Row'' fields:
    * Protocol version
    * Client software version
    * Server software version

== Internationalization ==

 1. Convert all user display text to ''Const'' strings
 1. Translate all messages ''Const''s into DE
 1. Implement tag and lookup for form text ''(design needed)''

== Final Packaging ==

 1. Set password on VBA code
 1. Get code signed with a Axpo certificate?
 1. Re-hide hidden rows/columns in header worksheet
    * Ensure that non-implemented fields are locked/greyed-out
 1. Setup field worksheet field locking (probably not)
 1. Hide internal worksheets


----

= Testing =

== Test Plan and Setup ==

 1. Write a test-plan wiki page
 1. Make sure ZK/TN/DD have suitable test environments

== Basic Tests ==

 1. Check reading and updating of all fields
    * Save values and read back
    * Check values on server
 1. Stress/performance testing
    * Searching for long lists
    * Bad input data
 1. Character sets: test with Umlaut characters
    * Test Umlauts in UTF-8 set to server
    * Test Umlauts in ISO-8859-1 set from server
    * Test Umlauts in error messages
 1. Compatibility testing
    * Excel 2003 menus
    * Excel 2003 complete functionality
 1. Search tests
    * Test all search fields
    * Test functionality of ''Bereich'' and ''Gruppe'' menus
 1. Display tests
 1. List menu tests
    * Status menus
    * User menus
    * Flag menus
 1. Editing tests
    * Delta date calculations
    * Drawing code menus
 1. Insert tests
 1. Update tests
 1. Client-side validation tests
    * Leave ''Wer'' and ''Status'' field validation for now
 1. Menu item tests
    * Check for duplicates
    * Duplicate selected
 1. Performance tests
 1. HTTPS test
 1. HTTP/HTTPS proxy test


= Testing of Specific Features =

== Search ==

 1. Search fields: Test all search fields:
    * document code
    * title
    * revision date from/to
    * external reference number
 1. Searching for more than selected the number of records
    * Ensure ''cancel/continue'' dialog functions correctly

== Display of Search Results ==

 1. Display/clearing of cell comments
 1. Search correctly merges new data with existing data
    * Make sure that if you re-arrange the order of documents in a worksheet, that search still operates correctly. E.g. check th t search is able to re ognize existing documents in the worksheet and doesn't depend on the order of documents delivered by the s rver.
 1. Display/removal of ''progress menu'' in lower left message area

== Editing ==

 1. Check for Copy and Paste problems - specifically related to ''onChange'' routine
 1. Contract and group menu changes in planning list worksheet
    * Make sure group menu updates when contract changed
    * Make sure user id menus change when contract and group changed
 1. ''Get Next Sequence Number''
 1. Generate client-side error on update/insert when drawing code not complete
 1. ''Vorabzug'' flag handling and ''RevC Revision Type'' menu handling
    * See ''[[ExcelIntegrationRequirements#GA.2BAC8-FregegebenMenu]]''
Line 20: Line 160:
    * Test items marked '''TEST''' in the High and Medium priority lists
      * Make notes, in a text file in axpo-excel/notes, of what has been tested and the results
      * Report all (and fix is possible) all errors

    * --('''Field locking:''' Implemented protected worksheets and individual cell locking/unclocking)--
      * --(See: the ''lockCell'' and ''unlockCell'' subroutines in ''modFunctions''. These are called for he correct cells in the correct places. The goal is that they actually lock the cells, rather than just set/reset the cell' background color.)--
    * --('''Inserting after selection point:''' ''New Document'' and ''Duplicate Selected'')--

 1. '''AH'''
    * --(Complete ''on change'' handling for ''Vorabzug'' menu and ''Rev``C'' type fields)--
    * --(''Vorabzug'' flag implementation: clearing locked fields when no ''Vorabzug'')--
    * --(Highlighting records after change/save/error)--
    * --(Progress messages)--

 1. '''DD''' Testing: See items marked '''TEST'''
    * Client-side validation: Testing of ''Ist'' field validation
    * Functional testing
    * Performance and stress testing (operations many records)

 1. --('''(JS)''' Implement ''Bau'' reports. There are two reports:)--
    * --(''Dokumentenlieferprogramm'' - mainly contains deadline fields: ''Tv, Tzf, Tf, Tgza, T0, T0,wv'')--
    * --(''Ressourcenplanung'' - mainly contains ''Wer'' fields and resource (user defined) fields)--



----

= High-Priority Items =

== Internals ==

 1. '''TEST''' Implement cell locking helper functions that make cells ''read-only/non-read-only''
    * --(Design/plan for implementing cell locking in protected sheets)--
    * --(Implementation initial implementation that just sets field's background color to indicate that the field is locked.)--
 1. '''TEST''' Fix handling/display of progress messages:
    * --(Convert display of ''Record count'' to ''Revision count'' in search)--
    * --(All (most?) menu items should clear display area when operation completes)--
 1. Implement Excel 2003 menu
 1. Implement handling when not logged in:
    * Implement routine to catch and report not being logged in
    * All menu items that access server should be able to respond to a non-logged in error
 1. '''TEST''' Supress setting of cell comments when records initially read from server
 1. '''TEST''' Make sure that no problems occurr when user changes worksheet names
 1. --(Fix ''checkDuplicates'' to check both the ''drawingCode'' and ''drawingId'' fields)--
    * --(Set cell note and highlighting when duplicates found)--
 1. --(Review/improve cell note set/clear functions: ''isCellDifference'' and ''setCellDifferenceComment'')--
    * --(Fix bug when comparing date fields)--
    * --(Do not set cell comments in key set area)--

== Search ==

 1. '''CRITICAL (AH)''' Change ''New Worksheet'' checkbox to ''Clear Existing Sheet'' in ''Search'' and ''Test Cases''
 1. '''TEST''' that no problems when the ''Layout'' worksheet is hidden.
 1. '''TEST''' that ''Refresh All'' and ''Refresh Selected'' update the record update counts in key set area
    * Search, then make update on the server, refresh the client and ensure that the update counts are correctly updated
 1. '''TEST''' that search correctly merges new data with existing data
    * Make sure that if you re-arrange the order of documents in a worksheet, that search still operates correctly. E.g. check th t search is able to recognize existing documents in the worksheet and doesn't depend on the order of documents delivered by the s rver.
 1. '''TEST''' Searching for more than selected the number of records
    * Ensure ''cancel/continue'' dialog functions correctly
 1. Mark row as ''un-savable'' if revision sequence is incomplete?
 1. --(Implement checking for duplicate worksheet names)--
    * --(Make sure that system doesn't crash if it tries to create a worksheet name that already exists)--

== Edit ==

 1. '''TEST (JS)''' that ''New Document'' inserts after selected row
    * Should append data after last selected cell, or last row if nothing selected
 1. '''TEST (JS)''' ''Duplicate Row'' should duplicate after the last selected row
    * And should not have problems when blank rows are selected
 1. '''CRITICAL (AH)''' Implement Vorabzug ja/nein flag
    * --(Clear/reset ''revisionNo'' and ''revisionCode'')--
    * --(Lock and grey-out all ''Vorabzug'' fields if ''Vorabzug'' flag set to 0)--
    * --(Disable plan date formulas when Vorabzug set to false)--
    * See ''[[ExcelIntegrationRequirements#VorabzugFlag]]''
 1. '''CRITICAL (AH)''' Fix highlighting/de-highlighting of status column. Display colors: 		 1. Field highlighting
Line 106: Line 172:
 1. '''TEST''' ''GA/Freigegeben'' menu:
    * --(Sets the RevC ''revisionTypeId'')--
    * --(Menu with two choices: ''freigegeben'' (13) and ''gut zur Ausführung'' (15))--
    * See ''[[ExcelIntegrationRequirements#GA.2BAC8-FregegebenMenu]]''
 1. '''TEST''' ''Get Next Sequence Number'' 		 1. ''New Document'' inserts after selected row
    * Should append data after last selected cell, or last row if nothing selected
 1. ''Duplicate Row'' should duplicate after the last selected row
    * And should not have problems when blank rows are selected
 1. Client-side field validation
    * Ordering/gaps in plan complete date fields
    * Ist field validation
    * Status
 1. ''Refresh All'' and ''Refresh Selected'' update the record update counts in key set area
    * Search, then make update on the server, refresh the client and ensure that the update counts are correctly updated
Line 112: Line 183:

== Validation ==

 1. '''TEST''' Client-side field validation
    * '''TEST''' ''Ist'' field validation.
    * --(Formulas generated from ''Perl'' script.)--
      * --(See axpo-integration/data/genValidation.pl)--
    * See ''[[ExcelIntegrationValidation|Client-Side Validation]]''
 1. '''TEST''' ''Group'' menu change
 1. Leave ''Wer'' and ''Status'' field validation for now

== Save/Update ==

 1. '''TEST''' ''Save'' handling of ''Vorabzug'' menu and ''GA/Freigegeben'' menus
    * --(''Vorabzug'' flag)--
    * --(''GA/Freigegeben'' menu)--
 1. '''TEST''' Implement field locking after save. Fields:
    * --(''Bereich'' menu)--
    * --(''Vorabzug'' flag)--
    * --(''GA/Freigegeben'' menu (RevC type) No, does not need to be locked after save)--
 1. --(Generate client-side error on update/insert when drawing code not complete)--
 1. --(Implement checking of record serial numbers on update)--
 1. --(Save all/selected should set record update counts)--
    * --(Test that a second save results in state with correct record update counts)--
 1. --(Duplicate row detection before:)--
    * --(search / test cases)--
    * --(save all / save selected)--
    * --(refresh all / refresh selected)--

== Attributes ==

 1. '''TEST''' Make sure ''Refresh Attributes'' still works
 1. --(Get feedback from JS re: recent changes to ''m_attributeRowCount'' global variable)--
    * --(Make sure that handling of ''m_attributeRowCount'' global variable is OK)--

== Report ==

 1. '''TEST (JS)''' ''Bau'' and ''Ausrüstung'' reports
    * Based on simple macros
    * Formatting of date columns
    * ''Dokumentenlieferprogramm'' - mainly contains deadline fields: ''Tv, Tzf, Tf, Tgza, T0, T0,wv''
    * ''Ressourcenplanung'' - mainly contains ''Wer'' fields and resource (user defined) fields

== Final Cleanup ==

 1. Re-hide hidden rows/columns in header worksheet
    * Ensure that non-implemented fields are locked/greyed-out
 1. Setup field worksheet field locking
 1. Hide internal worksheets
 1. Set password on VBA code

== Test ==

 1. Setup Excel 2003/2007 test/development environment
 1. '''TEST''' contract and group menu changes in planning list worksheet
    * Make sure group menu updates when contract changed
    * Make sure user id menus change when contract and group changed

----

= Medium-Priority Items =

 1. Implement ''Ausrustung'' report

 1. Implement ''Preufdauer'' menu and handling of ''Delta-4'' field

 1. Implement document links for ''Grundlagen'' documents. ''tech GL'' and ''WV GL'' fields.

 1. Implement document links for ''Stellungnahmen'' and ''Pruefberichts'' documents. ''Stn-Nr'' and ''Pruef-Nr'' fields.

 1. Implement document links for ''QA-Eklaerung'' documents

 1. '''TEST''' Performance: 		 1. Make sure ''Refresh Attributes'' still works
 1. Make sure that no problems occur when user changes worksheet names


= End-to-End Testing =

 1. Define scenarios
    * Client-side only
    * Client and Server interactions
 1. Functional testing
 1. Performance testing
Line 188: Line 197:
    * --(Disable screen update during record list processing)--
    * --(Investigate to see if bubble sort is really needed. Debug prints?)--

 1. In search form implement ''Gruppe'' menu with dependency on ''Bereich'' menu ''(design needed)''

 1. '''TEST''' search fields:
    * document code
    * title
    * revision date from/to
    * external reference number

 1. Separate ''Refresh Attributes'' into:
    * ''Refresh Attributes''
    * ''Refresh Users and Roles''

 1. Trap Excel-Quit and ask user if unsaved records should be saved ''(design needed)''

 1. Testing prior to release of test candidate to GMM
    * Test basic features
    * Test different contracts/groups

 1. Implement named baskets (Design needed)
    * User can select a named basket download its contents
    * Make sure all calculate fields are readonly

 1. --(Implement new columns to display record status and DrawMGT id values ''(design needed)'')--

 1. --(Design for record status fields)--
    * --(May not be needed if the above highlighting is implemented)--

----

= Low-Priority Items =

== General ==

 1. Reject revision ''(design needed)''
 1. Sub-revision processing ''(design needed)''
 1. Implement new ''Magic Row'' fields:
    * Protocol version
    * Client software version
    * Server software version
 1. Shorten attribute lists ''(design needed)''
    * Via server-side configuration?

== Final Cleanup and Packaging ==

 1. Get code signed with a Axpo certificate?
 1. Assign password to code

== Login/Logout ==

 1. Implement login timeout
 1. Implement code that reacts correctly to auto-logout. E.g. session-timeout
    * Implement a heartbeat function to prevent session timeout?
 1. Check user roles and disallow login if certain roles not present
 1. Login in a specific contract?

== Search ==

 1. Use case: Set next revision based on a document with unknown revision types

== Internals and Refactoring ==

 1. Named ranges
    * Automated management
    * Function for repair/reset of named ranges in case of corruption
    * Clone worksheet
    * Document named ranges and their boundaries
 1. Make sure ''Consts'' are used for all field type names in the write-back header worksheets
 1. Change ''iRow'' to ''lRow''?
 1. Document new validation columns in header structure
 1. Document and revision (write) record structures
 1. Improved worksheet lookup/access functions (''getCellValue/Address'')
 1. Improved row selection for printing to worksheet
 1. Refactor define names to improve clarity and remove near-aliases
 1. Identify all magic constants and convert to ''Consts''
 1. Improve function naming:
    * Make function names more ''business oriented'' rather than ''technically descriptive''
 1. Review ''TODO''s in code

== Compatibility ==

 1. Excel 2003 compatibility (menu)

== Internationalization ==

 1. Convert all user display text to Const strings
 1. Translate all messages Consts into DE
 1. Implement tag and lookup for form text ''(design needed)''

== Testing ==

 1. Write a test-plan wiki page
 1. Make sure ZK/TN/DD have suitable test environments
 1. Check reading and updating of all fields
 1. Stress/performance testing
    * Searching for long lists
    * Bad input data
 1. Character sets: test with Umlauts
    * Test Umlauts in UTF-8 set to server
    * Test Umlauts in ISO-8859-1 set from server
 1. Compatibility testing
 1. Search tests
 1. Display tests
 1. List menu tests
    * Status menus
    * User menus
    * Flag menus
 1. Editing tests
    * Delta date calculations
    * Drawing code menus
 1. Insert tests
 1. Update tests
 1. Client-side validation tests
 1. Menu item tests
    * Check for duplicates
    * Duplicate selected
 1. Performance tests
 1. HTTPS test
 1. HTTP/HTTPS proxy test

== Internal Documentation ==

= User Documentation =

 1. Define outline/structure for user documentation
 1. Setup wiki pages


= Internal Documentation =
Line 325: Line 220:
== User Documentation ==

 1. Define outline/structure for user documentation
 1. Setup wiki pages 		= Internals and Refactoring =

 1. Named ranges
    * Automated management
    * Function for repair/reset of named ranges in case of corruption
    * Clone worksheet
    * Document named ranges and their boundaries
 1. Make sure ''Consts'' are used for all field type names in the write-back header worksheets
 1. Change ''iRow'' to ''lRow''?
 1. Document new validation columns in header structure
 1. Document and revision (write) record structures
 1. Improved worksheet lookup/access functions (''getCellValue/Address'')
 1. Improved row selection for printing to worksheet
 1. Refactor define names to improve clarity and remove confusing near-aliases
 1. Identify all magic constants and convert to ''Consts''
 1. Improve function naming:
    * Use function names that more ''business oriented'' rather than ''technically descriptive''
 1. Review ''TODO''s in code

Excel Integration - To Do List

Contents

  1. Excel Integration - To Do List
  2. Implementation and Bug Fixes
    1. Bug Fixes
    2. Implement New Functionality
    3. Login/Logout/Exit
    4. Search
    5. Attributes Lists
    6. Implement Improved Revision Processing
    7. Internals
    8. Internationalization
    9. Final Packaging
  3. Testing
    1. Test Plan and Setup
    2. Basic Tests
  4. Testing of Specific Features
    1. Search
    2. Display of Search Results
    3. Editing
  5. End-to-End Testing
  6. User Documentation
  7. Internal Documentation
  8. Internals and Refactoring

Implementation and Bug Fixes

Bug Fixes

  1. AH - Diagnose errors reported by GMM

  2. AH - Implement highlighting of deleted records in Refresh Row

  3. Fix display of Umlaut characters in error messages

Implement New Functionality

  1. Design for document links

  2. Implement Preufdauer menu and handling of Delta-4 field

  3. Implement document links for Grundlagen documents. tech GL and WV GL fields.

  4. Implement document links for Stellungnahmen and Pruefberichts documents. Stn-Nr and Pruef-Nr fields.

  5. Implement document links for QA-Eklaerung documents

Login/Logout/Exit

  1. Gracefully handle when user not logged in
    • Implement routine to catch and report not being logged in
    • All menu items that access server should be able to respond to a non-logged in error

  2. Trap Excel-Quit and ask user if unsaved records should be saved (design needed)

  3. Implement login timeout
  4. Implement code that reacts correctly to auto-logout. E.g. session-timeout
    • Implement a heartbeat function to prevent session timeout?
  5. Check user roles and disallow login if certain roles not present
  6. Login in a specific contract?

  1. In search form implement Gruppe menu with dependency on Bereich menu (design needed)

  2. Change New Worksheet checkbox to Clear Existing Sheet in Search and Test Cases

  3. Implement named baskets (Design needed)
    • User can select a named basket download its contents
    • Make sure all calculate fields are readonly

  4. Mark row as un-savable if revision sequence is incomplete?

Attributes Lists

  1. Separate Refresh Attributes into:

    • Refresh Attributes

    • Refresh Users and Roles

  2. Shorten attribute lists (design needed)

    • Via server-side configuration?

Implement Improved Revision Processing

  1. Reject revision (design needed)

  2. Sub-revision processing (design needed)

Internals

  1. Implement new Magic Row fields:

    • Protocol version
    • Client software version
    • Server software version

Internationalization

  1. Convert all user display text to Const strings

  2. Translate all messages Consts into DE

  3. Implement tag and lookup for form text (design needed)

Final Packaging

  1. Set password on VBA code
  2. Get code signed with a Axpo certificate?
  3. Re-hide hidden rows/columns in header worksheet
    • Ensure that non-implemented fields are locked/greyed-out
  4. Setup field worksheet field locking (probably not)
  5. Hide internal worksheets

Testing

Test Plan and Setup

  1. Write a test-plan wiki page
  2. Make sure ZK/TN/DD have suitable test environments

Basic Tests

  1. Check reading and updating of all fields
    • Save values and read back
    • Check values on server
  2. Stress/performance testing
    • Searching for long lists
    • Bad input data
  3. Character sets: test with Umlaut characters
    • Test Umlauts in UTF-8 set to server
    • Test Umlauts in ISO-8859-1 set from server
    • Test Umlauts in error messages
  4. Compatibility testing
    • Excel 2003 menus
    • Excel 2003 complete functionality
  5. Search tests
    • Test all search fields

    • Test functionality of Bereich and Gruppe menus

  6. Display tests
  7. List menu tests
    • Status menus
    • User menus
    • Flag menus
  8. Editing tests
    • Delta date calculations
    • Drawing code menus
  9. Insert tests
  10. Update tests
  11. Client-side validation tests

    • Leave Wer and Status field validation for now

  12. Menu item tests
    • Check for duplicates
    • Duplicate selected
  13. Performance tests
  14. HTTPS test
  15. HTTP/HTTPS proxy test

Testing of Specific Features

Search

  1. Search fields: Test all search fields:
    • document code
    • title
    • revision date from/to
    • external reference number
  2. Searching for more than selected the number of records

    • Ensure cancel/continue dialog functions correctly

Display of Search Results

  1. Display/clearing of cell comments
  2. Search correctly merges new data with existing data
    • Make sure that if you re-arrange the order of documents in a worksheet, that search still operates correctly. E.g. check th t search is able to re ognize existing documents in the worksheet and doesn't depend on the order of documents delivered by the s rver.

  3. Display/removal of progress menu in lower left message area

Editing

  1. Check for Copy and Paste problems - specifically related to onChange routine

  2. Contract and group menu changes in planning list worksheet
    • Make sure group menu updates when contract changed
    • Make sure user id menus change when contract and group changed

  3. Get Next Sequence Number

  4. Generate client-side error on update/insert when drawing code not complete

  5. Vorabzug flag handling and RevC Revision Type menu handling

    • See ExcelIntegrationRequirements#GA.2BAC8-FregegebenMenu

    • Test the onChange handling for Vorabzug menu and RevC type fields.

      • Make sure the revision code and revision type are changed and set correctly

      • Make sure the Vorabzug fields are locked/unlocked when the flag is changed

      • Make sure the Vorabzug fields are cleared when flag not set and records saved

  6. Field highlighting
    • Status colors:

      • gray - saved

      • yellow - changed

      • red - error

    • Events:
      • New record (set to yellow)
      • Re-started record (set to yellow). E.g. after restart revision sequence
      • Record changed locally (set to yellow)
      • Client-side error? (set to red)
      • Server-side error (set to red)
      • Record saved (set to white)

  7. New Document inserts after selected row

    • Should append data after last selected cell, or last row if nothing selected

  8. Duplicate Row should duplicate after the last selected row

    • And should not have problems when blank rows are selected
  9. Client-side field validation
    • Ordering/gaps in plan complete date fields
    • Ist field validation
    • Status

  10. Refresh All and Refresh Selected update the record update counts in key set area

    • Search, then make update on the server, refresh the client and ensure that the update counts are correctly updated

  11. Should Restart Revision Sequence not be allowed when applied to an unsaved record? Probably not

  12. Make sure Refresh Attributes still works

  13. Make sure that no problems occur when user changes worksheet names

End-to-End Testing

  1. Define scenarios
    • Client-side only
    • Client and Server interactions
  2. Functional testing
  3. Performance testing
    • Measure performance with large data sets
    • Profile code to see what is being called for each document/revision

    • Review calls to DoEvents

User Documentation

  1. Define outline/structure for user documentation
  2. Setup wiki pages

Internal Documentation

  1. List of modules
  2. List of public subs/functions

  3. List of gotchas

    • Blank cells in header regions, caused by use of Excel count2 function

  4. Explanation of complex menu and look formulas)
  5. Convert notes/DesignNotes into Wiki
  6. Revision sequence
  7. Named ranges
  8. URLS for REST transactions
  9. XML structures
    • Returned records
    • Insert/update records

Internals and Refactoring

  1. Named ranges
    • Automated management
    • Function for repair/reset of named ranges in case of corruption
    • Clone worksheet
    • Document named ranges and their boundaries

  2. Make sure Consts are used for all field type names in the write-back header worksheets

  3. Change iRow to lRow?

  4. Document new validation columns in header structure
  5. Document and revision (write) record structures

  6. Improved worksheet lookup/access functions (getCellValue/Address)

  7. Improved row selection for printing to worksheet
  8. Refactor define names to improve clarity and remove confusing near-aliases

  9. Identify all magic constants and convert to Consts

  10. Improve function naming:

    • Use function names that more business oriented rather than technically descriptive

  11. Review TODOs in code

ExcelIntegrationToDoList (last edited 2011-07-19 17:10:57 by karl)

Copyright 2008-2014, SoftXS GmbH, Switzerland