https://bugs.freedesktop.org/show_bug.cgi?id=84022
Priority: medium
Bug ID: 84022
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: SORTING DATA
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: bondi3...@gmail.com
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 106467
--> https://bugs.freedesktop.org/attachment.cgi?id=106467&action=edit
Personal finance tracking using Calc
Libre Office for Mac V4.3.1.2. and previous version
BACKGROUND:
This spreadsheet has been created and refined by me over a number of years, so
some early rows will have different formulae to the most recent. The
modifications have been sometimes on the Mac, and sometimes in Open Office on
my Wintel laptop.
Data is usually entered on the blank rows below the green 'End of Month' rows
then sorted by date to place in date order.
I have visited LibreOfffice forums and didn't readily find a similar problem,
so it may be something specific to this spreadsheet or the Mac.
THE PROBLEM (BUG):
When sorting entire rows, row references in formulae become corrupted.
Eg C365-C366 becomes C392-C395 instead of retaining one row relationship.
This creates errors in the columns K to V and makes reconciliation with bank
statements etc impossible.
REPEATABILITY:
On the Macbook this problem has been plaguing me for some months now, and I
thought there was something wrong with my formulae or the way my partner was
performing the sort.
We installed LO V4.3.1.2 for Mac today (clean install). I tried several times
to sort the data and the result is still the same.
HOWEVER, EXACTLY the same spreadsheet (opened and sorted in Apache OpenOffice
4.1.1 in Win7/X86-64) sorts as expected.
ATTACHMENT:
The attached spreadsheet has had personal info removed from columns B, C, and D
but these columns are not referenced in any other columns.
Sorting is always done on column A (Date) with the other sort options left as
'Undefined'
There are three existing rows with added data below 'End of Month' rows. Add
appropriate dates to these rows and sort.
This is my first bug report so please be kind to me! Should you clever people
need any more info, please email and tell me exactly what info you need (and
where to find it) as I'm an advanced computer user, not a computer guru. :-)
Regards,
Ian
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
