UPDATE: So sorry. I stupidly forgot to include info. about my operating
environment - it's Kubuntu Linux 14.04 and I'm running LO Version: 4.3.0.2
Build ID: 14ed55896fdfcb93ff437b85c4f3e1923d2b1409. We are, of course,
talking about Calc.
t.
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
