[libreoffice-users] Sorting problem in LO and OOo in base / Report

I have a Excel Worksheet I download from one of my cooperation partners, it
consist of almost 200 columns and 70 - 400 rows
and a columns with week number in. First time I made the report my focus was
about to break the report into weeks and customer. As in group Week and
group customer no accumulation implemented at first.
This went fine no problem at all it break all the right place and sorted the
right way.
Optimistic starting, adding some more function on.
Accumulation, the first to columns went fine, adding more function on, then
it all break down that gos for OpenOffice and Libre Office 3.2.1 / 3.3.2
Report builder 1.2.1 Windows / Linux Ubuntu.
I to a while before I found the reason for the break down, DON'T USE: SPACE,
( ), /. After that I thought, now it's moving forward.
Made the report with group=Week and group=Customer 9 columns of data, the
last 4 columns should accumulate to Week and to to Customer.
I download new file from cooperation partner with 3 weeks data.
Try the report and nothing works as supposed, it didn't sort the week right
and mess up the sort of customer.
Try download new file with only one week in, same problem with the customer
again...
Now I can't get anything to work proper.
Then I got an idea, try to search and replace customer names with car names
and upload it to your so you could see the mess, but thats not gone a
happed, because now it works, but not with the right data....
Ok, good idea it was to replace the names with car names, so this time I
replaced it with the right customer name but bad lock seem to hit me... it
didn't workout.
Now I am lost....
What can be wrong, and how do I debug the worksheet to see if it's something
with char set eg. UTF-8 or some other charset....
By the way if i do save the Excel Sheet to OpenOffice Sheet still the same
problem...

Please any suggestions...

Best regards
Rikard Svenningsen

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***