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.
--
-- Tim Deaton
===========================
I know the plans I have for you:
Plans to prosper you and not to harm you;
Plans to give you hope and a future.
--- God (Jeremiah 29:11)
--
To unsubscribe e-mail to: [email protected]
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
