Postby AdrianRoth on Wed Feb 11, 2009 6:38 pm
Windows XP Professional, Service Pack 3
I create a table with three columns
In cell C2 I specify the formula +C1+B2
In cell C2 I specify “copy the formula down 5 times”
Formerly the “copy” would adjust the formula so that in cell C3 the formula would be +C2+B3, etc.
Now the “copy” doesn’t adjust the formula; in the third column of each row the formula is +C1+B2
I don’t know what happened to change the way that the “copy” command works.
What must I do to have the “copy” command adjust the formula?
Postby Graphcat on Fri Feb 13, 2009 10:22 am
I re-created your table in WP 10.0.0.990, and it worked correctly. (I don’t have 9 installed any more; I just keep the last 5 versions.)
I don’t see any options that affect this. I don’t see any relevant bugs in the Corel Knowledgebase.
That leaves a formula that WP is recognizing as text instead of as a formula, or document corruption, or a bug that was quietly fixed either in 10, or in a service pack for 9.
So, there are a few things to check:
Try rebuilding the simple test version of the table in a new, empty document. If it works, the original is either corrupted or the formula is being read as a label. Your example is simple–I wonder if it fails in the real world on a much larger table, with many rows of running totals carried down.
WP9 should be version 18.104.22.1688 for Service Pack 3. (Look in Help, About…)
http://www.corel.com/servlet/Satellite/ … 3321346751
All the downloads for 9 are here:
http://www.corel.com/servlet/Satellite/ … 8716793655
And… (could be a waste of time, but you never know):
Open Quattro Pro 9, go to Settings, and reverse the setting for “Cell Reference Checker”. Should not make a difference, but I don’t know how much of the code is shared between different portions of the suite. There is no equivalent setting in WP.