Corruption - Item ID showing in "#" Column

Submitted by Tom on 2012/06/26 08:09

EDIT/
I added a summary of the bugs in a new post below.

 
Been working on a grid related to an older job that I'm revisiting.
Basically a ToDo list:
 
At some stage when I reopened the grid, a Y/N column had jumped to the left of the item field.
I was unable to drag it back and unable to drag item field to the left of it:
 
 
But then I noticed the number in the "#" column - turns out that *some* items are showing their ID number in the # Column.
 
I created a new grid to show the same items, and had the same problem
 

Pivot Table support stopped working

Submitted by martym on 2012/06/06 14:13
Team,
  I've been using W10 in Portable mode to track some financial data. Tried Pivot Tables several weeks ago. Cool!  Since then I added more data. Went to use the PT feature and got the error that I have no Office installed. I do, office 2007, and have for months. Nothing changed there. How do I get the capability working again? What could have made IQ think I don't have Office installed?
 
  I'm running Windows 7 and it's locked down tighter than a drum so don't suggest I dabble in the registry.  
 
Any help is greatly appreciated!
 
MartyM

equation question > changing forecolor depending on action

Submitted by jan_rifkinson on 2012/06/03 14:23
When item is marked datedone I have the following equation
 
A:ItemForeColor=&H808080|
ME:ItemForeColor=&H000000|
 
I assumed with the above the following would happen:
 
A: if datedone is 1 (yes) then ItemForeColor=&H808080 (gray)
ME: if datedone is 0 or changed then ItemForeColor=&H000000 (black)
 
but it's not happening.