Ask Your Question
0

LibreOffice how do I fix autocalc/autocorrect/autofill [closed]

asked 2016-09-15 08:32:23 +0100

unavailableartist gravatar image

updated 2020-08-05 14:46:51 +0100

Alex Kemp gravatar image

Problem No. 1 office doesn't auto update (recalculate based on what you type in):

A1= 2 B1=2 C1=2 D1=sum(A1:C1) or "6" update* delete cell A1 and D1 still = "6"

2.) I'm slowly making a list with shifting values, for top least valuable to bottom more value. So I shift A1:C1 down... and... D1=(A2:C2) or "6"... when it should be zero... it tracks those 3 cells I'm moving around... I don't want it to.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-19 20:02:53.801025

Comments

First: did you accidentally format cells as text? If you did, numbers will still be right aligned but formula will not recalculate. What are you trying to accomplish with formula =(A2:C2)? Are you summing in D1 rage from A2 to C2?

Kruno gravatar imageKruno ( 2016-09-15 21:45:30 +0100 )edit

For first, are you accidentally formated cells as text? If you did, numbers will still be right aligned but formula will not recalculate. What are you trying to accomplish with formula =(A2:C2)?

Kruno gravatar imageKruno ( 2016-09-15 21:45:42 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-12-07 11:12:18 +0100

newbie-02 gravatar image

calculation works fine with 6.2.8.2,

more complex calculations sometimes fail in auto recalculation,

D1 still referencing A2:C2 after move depends on the steps you take,

normally a formula cell should keep it's references as long as it makes sense and is technically possible,

if you want to trick it out consider inserting a row 1, copy! D2 to D1, and then delete D2,

plenty other ways are possible, 'move', 'cut and paste' and similar will more likely keep the original reference, while 'copy and paste' and similar produces a new reference in similar relation to copy target as it's been to copy source,

b.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-09-15 08:32:23 +0100

Seen: 193 times

Last updated: Dec 07 '19