so I have a a spreadsheet that is the 1040 tax documents. it has some 30-40 sheets. it gets released every year.
it has references like “wages” “interest_income” etc.
from that starting point, I make up a new sheet that in “mystatetaxes” and calculate my state taxes. here is a snippet of the sheet:
12a $2
12b $2 calcs:
13
14 $150,068 126,824.00 23,244.00
15 $0 0
16 $0 0 126,824.00
17 $23,940 23940
18 $0 0
now this sheet has formulas in it. if I go to tools->options->calc and can turn on view formulas. here is that exact same snipped in formula view:
12a =+B6+B7+B8+B11
12b =+B9+B10 calcs:
13
14 =Wages =B15-$‘W-2s’.G26 =$‘W-2s’.G26
15 =Interest_Inc 0
16 =Dividend_Inc 0 =B15-F15
17 =Business_Profit =B18
18 =B63 0
the problem is if I cut and paste the snippet into a new ods file, on a new sheet this is what I get:
12a $2
12b $2 calcs:
13
14 #NAME? #NAME? 0.00
15 $0 0
16 $0 0 #NAME?
17 $0 0
18 $0 0
and the formula view:
12a =+B6+B7+B8+B11
12b =+B9+B10 calcs:
13
14 =Wages =B15-$Disclaimer.G26 =$Disclaimer.G26
15 =Interest_Inc 0
16 =Dividend_Inc 0 =B15-F15
17 =Business_Profit =B18
18 =B63 0
so I’ve got two questions,
-
why didnt the cell with “=Wages” work and give me a #NAME? error? if I go into that cell (F2) and copy and paste that line, into itself, It fixes itself and references the cell correctly:
12a $2
12b $2
13
14 $146,749
15 $0 -
what’s with the disclaimer?? how can I get it tow just copy the cell exactly as if I typed it? If I go into the cell of the original sheet, edit the cell (F2) and select the whole TEXT cut it, and then go to the new sheet in the new ods document, go to the corresponding cell do a (F2) and PASTE it fixes the cell. I want this for the whole sheet.
any ideas ?