BUG in 2007

B

bwjames9301

put in 850 in a1
in b1 through b10 put in 77, 77.1, 77.2,77.3 etc
in c1 put =$a$1*b1 and fill down through c10
line graph c1:c10 - it is linear

copy c1:c10 - paste special (value) -- still linear

type in 100000 into b2 (where the 100000) was
now it is not linear.....
 
P

Peo Sjoblom

I think that bug was first reported here a couple of days ago,
in this particular newsgroup


--


Regards,


Peo Sjoblom
 
J

JE McGimpsey

Please read the group messages before posting - this is already being
discussed in multiple threads...
 
M

Mantvydas

Only if they had used more proper keywords in the subject for searching. The
only right search term was "bug", and it just didn't come to my mind. :) I
used "calculation", "error"... but somehow not the "bug". :)

Mantvydas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unique values in Excel 4
Excel 2007 bug 3
Excel: Fill Down without Incrementing a Formula Variable 2
Formula Query 9
How to save Max Min values 1
Calculation error found in Excel 2007 under XP 1
Using Arrays With IF functions 2
Macro to copy formula based on range of other column 2

Top