WordPerfect Photo Album Catalogs & Clip Art

published by Science Translations

February 13th, 2009 at 7:13 pm

Formulas in Tables

Postby AdrianRoth on Wed Feb 11, 2009 6:38 pm
WordPerfect 9
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, 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 for Service Pack 3. (Look in Help, About…)

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.

Jerry Stern
Moderator and Webmaster
Author of Graphcat and FileTiger