Phil,
Yeah. I sure do know this problem, too. For many months.
I can't see the pattern. I can't seem to reduce the matter to a simple
demonstration so I can file a bug report. I've simply given up for now.
I just fix things and keep on sailing.
Whatever it is is pervasive, highly corrupting, AND most people never
see it, so it never gets fixed. I deal with it multiple times a day,
day after day, week after week....
Tom
On 07/06/2014 06:12 AM, Philip Ward wrote:
Hi Guys,
Running 4.1.3.2 Libreoffice, on Win 7 64Bit, and having a few annoyances??
i have a multi sheet document, page one has some dates on it, and these
dates are then grabbed by the following sheets to make the dates work on
them etc??
sometimes i load up the document, and the formula's all go to pot
I put the start date of the year that the user wants, and then just select
another cell and say "= B4 + 7 "
but it keeps coming up with
=SUM('View Kitchen'.KY16)
which is sheet that should be getting the information from this area..
and now i went in to alter the format of the cell
ie Date details "NNNND MMMM YYYY" giving me " Monday 6 October 2014"
but now want to shorten the date down to "mon 6 oct 2014", but its now
telling me options for jewish?? ie " [~jewish]NNNND MMMM YYYY" i know i can
alter the details, but does anyone have any ideas as to why my cells change
from what they should be? or why i now have jewish in there as well??
cheers for any help.
Phil
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tom Cloyd, MS MA (LMHC, WA State)
Cedar City / St. George, UT, U.S.A: (435) 272-3332
* << [email protected] >> (email) << TomCloyd.com >> (website)
* Sleight of Mind blog: Sleightmind.com (mental health issues)
* Founder: Google+ Trauma and Dissociation Education and Advocacy community
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted