Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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
* << tc@tomcloyd.com >> (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: users+unsubscribe@global.libreoffice.org
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

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.