Ask Your Question
0

Copy and Paste Formula without copying tab name

asked 2018-10-29 10:30:46 +0200

Helpalwaysneeded gravatar image

Hi, I have a spreadsheet with multiple tabs (one for each month). Sometimes I need to copy a row including formula from one tab to another, however when I do this the formula automatically adds the sheet name in which then means my formula in the second tab is referring to the wrong data. I have never manually added the sheet name in when writing the formula, is there a way to stop it happening?

Thank you

edit retag flag offensive close merge delete

Comments

(The label on the glass and the jam in the glass are different things. So are the tab showing the sheet's name and the sheet itself.)

Lupp gravatar imageLupp ( 2018-10-29 11:52:39 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-29 11:37:22 +0200

Lupp gravatar image

updated 2018-10-29 12:05:32 +0200

What you describe is not the regualr behaviour of Clac.
What's your LibreOffice version? I have a faint impression of memorizing an old version which had a bug to the described effect. Do your formulas you want to copy from the other sheet already contain a sheet part in their references? If so, has it prefixed a $-sign?

edit flag offensive delete link more

Comments

Hi, I think we are on number 5.2.5.1 There is no sheet reference in formula, a basic example is when I paste the formula it looks like this =IF($January.F3="","",$January.F3-$January.G3-$January.H3) I try and manually remove the $January. but it automatically adds it back in. Thank you

Helpalwaysneeded gravatar imageHelpalwaysneeded ( 2018-10-30 11:20:29 +0200 )edit

Well. The version(s) having a related bug was(were) early in the 5.x series. See tdf#96591 e.g. Seems you are afflicted.
Best update to V5.4.7, the most matured version of the 5.x series, or to V6.0.7 probably.
(You may first test if a corrupted user profile was the villain in your specific case.)

Lupp gravatar imageLupp ( 2018-10-30 11:43:39 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-29 10:30:46 +0200

Seen: 43 times

Last updated: Oct 29 '18