Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question - Making a VFP Com Server Excel Add in
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00818943
Message ID:
00820188
Vues:
25
Looks like I misunderstood the recalc functions in Excel.

Shift-F9 recalcs only the active sheet and _only_ the cells that it thinks need recalcing (Ie. if a cell has a dependancy on another cell whose value has changed).

F9 alone recalcs the whole workbook using the same logic as Shift-f9.

Ctrl-Alt-F9 recalcs the entire sheet, cell by cell with no exclusions.

Since Excel wasn't aware that the logic in my Add-in server had changed, it saw no need to recalc the cells that used one of it's functions. Once I hit Ctrl-Alt-F9, I got the results I was looking for.

Problem solved.

Hope this helps someone.

-Matt
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform