Re: [libreoffice-users] Calc: moving/sorting rows on Sheet1 don't update formulas on Sheet2 that refer to them

I get the same on 6.07, it is what I would have expected from a sort
(the contents of the cells are moved about, the cell positions are not
changed). Seems logical to me but possibly not the desired outcome for
others.
If you use a lookup function on sheet 2 (include an index for each row
for lookup ease) then you will return the right results regardless of
position in the lookup table. You just have to be careful adding extra
lines that they get included in the table.

On 10/04/2019 11:48, Tim Deaton wrote:
> I'm building a spreadsheet to serve as a food diary.  On Sheet1 I have
> a list of different foods, and on Sheet2 I have what foods I ate at
> which day and meal.  So far, I've only got a couple of days' data posted.
>
> As I add more meals, I eat items that are not already on the Sheet1
> list.  So I add the new items to Sheet1, and sort that table again. 
> THAT's when the problem occurs.  I just added three new foods to the
> bottom of the Sheet1 list, then sorted it.  Before sorting, the new
> foods were in cells A38-A40.  After sorting, the new entries are all
> above A30.
>
> Before sorting Sheet1, the item in Sheet2, cell C5 contained this:
> =$'Sheet1'.A33
> After sorting Sheet 1, that Sheet2 cell reference should say
> =$'Sheet1'.A36, but it still says "A33".
>
> Is this a known problem?  I'm using LO v6.1.5.2 (x64) on Windows 7.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy