The problem has been fix now.
Because of the uses of the raw worksheet just downloaded from our cooperate
partner site, without modification to headlines in the worksheet. The
worksheet contained headlines with illegal char, those where isolated in a
query where I put alias in to all field in use and only used legal char.
This looks like a solution, but not quiet the solution as expected, now the
office didn't went down when creating accumulation and stuff like that.
But new trouble a raised.
Now it couldn't sort and what I haven't seen yet, the calculate fields
didn't work.
Back to square one...
The solution is remove / rename all headlines in the worksheet to only
contain legal char and not use a query.
Now it works as it is supposed to do, thanks to every one, and hope someone
can use my experience....
2011/3/31 Rikard Svenningsen <rikard@svenningsen.dk>
No it was plain names with char from a - z and capital a - z, except that
some names did have this char / as the second last char that means at least
the 10 first char goes to a - z and A - Z.
2011/3/30 Alexander Thurgood <alex.thurgood@gmail.com>
Le 30/03/11 15:58, Rikard Svenningsen a écrit :
Hi,
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...
Do any of your customer names have non-ascii characters in them ? Did
any of the car names you used as substitutes have any non-ascii characters
?
Alex
--
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 ***
--
Med venlig hilsen
Rikard Svenningsen
Smalager 36
DK-7120
--
Med venlig hilsen
Rikard Svenningsen
Smalager 36
DK-7120
--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
*All messages sent to this list will be publicly archived and cannot be deleted*
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.