Re: [libreoffice-users] Spreadsheets
On 15/06/15 08:45, Richard Brown wrote: Hi I am trying to create a spreasheet that will track my budget. I want to have a form that will insert a payment every four weeks or monthly by date. Is this possible to do please? Thanks Probably. But might you not be better off with something like gnucash that's designed specifically for such jobs? (And as free as LO.) -- Mike Scott (unet2 at [deletethis] scottsonline.org.uk) Harlow Essex England -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Spreadsheets
Hi Richard, its in german and made for physicians, but it might give you an idea, how to set up such a spreadsheet: http://resmedicinae.sourceforge.net/manuals/EUR/eur.html GNU Free Documentation License Yours Walther Am Montag, 15. Juni 2015 schrieb Mike Scott: On 15/06/15 08:45, Richard Brown wrote: Hi I am trying to create a spreasheet that will track my budget. I want to have a form that will insert a payment every four weeks or monthly by date. Is this possible to do please? Thanks Probably. But might you not be better off with something like gnucash that's designed specifically for such jobs? (And as free as LO.) -- Mike Scott (unet2 at [deletethis] scottsonline.org.uk) Harlow Essex England -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Spreadsheets
On 06/15/2015 07:45 AM, Richard Brown wrote: have a form that will insert a payment every four weeks or monthly by date. Is this possible to do please? As a spreadsheet? If you are willing to write the appropriate macros, then yes. As a database, using the spreadsheet as an interface? Yes, but you'll still need to write the code to that task. It is much simpler to write a python script that does that, than write the macro for the spreadsheet. This is yet another time when I really wish that LibO had SQLite as a built in database engine. (Pity one can't just write SQLite as an extension, and have it work properly.) Nonetheless, your best option is to use a FLOSS accounting program. GnuCash, SMBLedger, etc. On 06/15/2015 11:33 AM, Andreas Säger wrote: No IT professional would ever consider this as a valid solution. Whilst that is true, that doesn't negate the fact that most corporate databases started out as spreadsheets created by the user. ### I've seen a couple of Excel spreadsheets that were 100 MB in size, before the user started populating them with data. Slower than molasses, but the only program that those users knew, was Excel. jonathon -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
Hi Brian Thanks for your help, our studies on other cultures at school was very vague, and as of yet, never needed to understand another calendar.. It could possibly be a red herring like you say, i just put 2 and 2 together, and came up with 5, maybe i should have used a spreadsheet :D Im running LO 3.4.4 on my works imac, and checking its a USA interface, UK Locale Currency setting... Just loaded up the document, and just checking the first sheet, the formulas seem to have been saved, and work ok, ill just keep an eye on it, and see what else happens. Thanks again, Phil On 07/07/2014 02:00, Brian Barker wrote: At 00:05 07/07/2014 +0100, Philip Ward wrote: On 06/07/2014 17:01, Brian Barker wrote: At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details D 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]D 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? Yes and no. There are a few things worth knowing. o The definition of ODF says that the format code is a sequence of characters with an implementation-defined meaning, so clearly it can be different in different standards-respecting applications. So formats such as D are not saved as such in ODF document files. Instead, it seems that three things are saved: the date in ISO standard form (2014-10-06), the actual text as displayed (Monday 6 October 2014), and a description in different terms of your chosen format - such things as: number:day-of-week number:style=long / number:text / number:day / number:text / number:month number:style=long number:textual=true / number:text / number:year number:style=long / When you reopen a document, the necessary formats must be reconstituted from this information in the file. o Dates in particular are reconstituted with reference to the current locale. If, for example, I enter today's date (6 July) in my UK locale, it is displayed naturally as 06/07/14. If I save that in a document and reopen it in a US locale, the format is automatically reconstituted differently, with the same cell being displayed instead as 07/06/14. o It seems that some formats that have been used or appeared automatically but perhaps are no longer needed are nevertheless saved in the document. So I think some of this could be explained by this document having been opened and resaved on a system with locale set to Hebrew. I understand that the NNNDDD etc are not stored with in the format, but just wondered where the jewish annotations came into effect? If I understand you correctly, these are just appearing as possible formats in the Format Cells dialogue. If so, I don't think you should be too worried about them. I don't claim to understand all the aspects of locale settings, which exist separately for operating systems (including individual user settings) as well as for applications, such as LibreOffice. If Calc thinks you might be helped by these offerings but you don't need them, there is no problem I can see the top reference in the list of pre-set annotations mentioned above is [~jewish]D , and in the format box it is Friday 22 Tevet 5760 ... That corresponds to Gregorian 31 December 1999, which is the date used for all format examples in the Format Cells dialogue. ... and in the preview box it is Monday 9 Tammuz 5774, i don't even know if that's correct? That's Monday 7 July 2014 in the Gregorian calendar, i.e. today. ... or if the Jewish calendar works on a different format? Well, yes: it has a different origin, of course - a point in 3761 BC by the Gregorian calendar - as well as different month names, which don't correspond with Gregorian months since they are generally shorter and need additional intercalary months every two or three years to keep the calendar in step with the solar year. I have also as a test just copied the cell into a new spreadsheet, and it took over the jewish annotation? By default, pasting carries over formats as well as values. You can suppress this using Paste Special... . I was just looking for insights as to whether anyone else has had the problem? i just don't want to go much further, and lose the lot, ... The question of available formats doesn't affect your use of the spreadsheet, does it? I suspect it is a red herring and may have no connection with the other corruption you mentioned (about which I have no comment). Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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:
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
Hi :) If you want pointers to find out about settings and configs for other languages and/or countries then you might find the international translators mailing list quite useful l...@global.libreoffice.org Sounds like Brian has helped you fix it already though :) Congrats! :) Regards from Tom :) On 7 July 2014 10:22, Philip Ward skegg...@gmail.com wrote: Hi Brian Thanks for your help, our studies on other cultures at school was very vague, and as of yet, never needed to understand another calendar.. It could possibly be a red herring like you say, i just put 2 and 2 together, and came up with 5, maybe i should have used a spreadsheet :D Im running LO 3.4.4 on my works imac, and checking its a USA interface, UK Locale Currency setting... Just loaded up the document, and just checking the first sheet, the formulas seem to have been saved, and work ok, ill just keep an eye on it, and see what else happens. Thanks again, Phil On 07/07/2014 02:00, Brian Barker wrote: At 00:05 07/07/2014 +0100, Philip Ward wrote: On 06/07/2014 17:01, Brian Barker wrote: At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details D 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]D 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? Yes and no. There are a few things worth knowing. o The definition of ODF says that the format code is a sequence of characters with an implementation-defined meaning, so clearly it can be different in different standards-respecting applications. So formats such as D are not saved as such in ODF document files. Instead, it seems that three things are saved: the date in ISO standard form (2014-10-06), the actual text as displayed (Monday 6 October 2014), and a description in different terms of your chosen format - such things as: number:day-of-week number:style=long / number:text / number:day / number:text / number:month number:style=long number:textual=true / number:text / number:year number:style=long / When you reopen a document, the necessary formats must be reconstituted from this information in the file. o Dates in particular are reconstituted with reference to the current locale. If, for example, I enter today's date (6 July) in my UK locale, it is displayed naturally as 06/07/14. If I save that in a document and reopen it in a US locale, the format is automatically reconstituted differently, with the same cell being displayed instead as 07/06/14. o It seems that some formats that have been used or appeared automatically but perhaps are no longer needed are nevertheless saved in the document. So I think some of this could be explained by this document having been opened and resaved on a system with locale set to Hebrew. I understand that the NNNDDD etc are not stored with in the format, but just wondered where the jewish annotations came into effect? If I understand you correctly, these are just appearing as possible formats in the Format Cells dialogue. If so, I don't think you should be too worried about them. I don't claim to understand all the aspects of locale settings, which exist separately for operating systems (including individual user settings) as well as for applications, such as LibreOffice. If Calc thinks you might be helped by these offerings but you don't need them, there is no problem I can see the top reference in the list of pre-set annotations mentioned above is [~jewish]D , and in the format box it is Friday 22 Tevet 5760 ... That corresponds to Gregorian 31 December 1999, which is the date used for all format examples in the Format Cells dialogue. ... and in the preview box it is Monday 9 Tammuz 5774, i don't even know if that's correct? That's Monday 7 July 2014 in the Gregorian calendar, i.e. today. ... or if the Jewish calendar works on a different format? Well, yes: it has a different origin, of course - a point in 3761 BC by the Gregorian calendar - as well as different month names, which don't correspond with Gregorian months since they are generally shorter and need additional intercalary months every two or three years to keep the calendar in step with the solar year. I have also as a test just copied the cell into a new spreadsheet, and it took over the jewish annotation? By default, pasting carries over formats as well as values. You can suppress this using Paste Special... . I was just looking for insights as to whether anyone else has had the problem? i just don't want to go much further, and lose the lot, ... The question of available formats doesn't affect your use of the spreadsheet, does it? I suspect it is a red
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
Hi Tom i forgot to add, the first time i saw the corruption was on OSX 10.6.8 running LO 3.X (cant remember), but that was only opening the file, not saving, so i decided not to use that one again... do you save locally or Dropbox or somthing else? cheers Phil On 6 July 2014 13:44, Tom Cloyd tomcloydm...@gmail.com wrote: 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 D 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]D 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 * t...@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+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
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 D 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]D 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 * t...@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+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
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 D 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]D 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 * t...@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+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details D 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]D 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? Yes and no. There are a few things worth knowing. o The definition of ODF says that the format code is a sequence of characters with an implementation-defined meaning, so clearly it can be different in different standards-respecting applications. So formats such as D are not saved as such in ODF document files. Instead, it seems that three things are saved: the date in ISO standard form (2014-10-06), the actual text as displayed (Monday 6 October 2014), and a description in different terms of your chosen format - such things as: number:day-of-week number:style=long / number:text / number:day / number:text / number:month number:style=long number:textual=true / number:text / number:year number:style=long / When you reopen a document, the necessary formats must be reconstituted from this information in the file. o Dates in particular are reconstituted with reference to the current locale. If, for example, I enter today's date (6 July) in my UK locale, it is displayed naturally as 06/07/14. If I save that in a document and reopen it in a US locale, the format is automatically reconstituted differently, with the same cell being displayed instead as 07/06/14. o It seems that some formats that have been used or appeared automatically but perhaps are no longer needed are nevertheless saved in the document. So I think some of this could be explained by this document having been opened and resaved on a system with locale set to Hebrew. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
I save to my Dropbox. Don't think that's relevant, though. Can't figure how it would be. Tom On Sun, Jul 6, 2014 at 6:49 AM, Philip Ward skegg...@gmail.com wrote: Hi Tom i forgot to add, the first time i saw the corruption was on OSX 10.6.8 running LO 3.X (cant remember), but that was only opening the file, not saving, so i decided not to use that one again... do you save locally or Dropbox or somthing else? cheers Phil On 6 July 2014 13:44, Tom Cloyd tomcloydm...@gmail.com wrote: 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 D 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]D 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 * t...@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+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
Hi Brian I have just opened the file in question on my Imac at home 10.6.8 running LO 4.2.4.2. The default User interface is English USA, Local Setting is UK, and default currency is GBP, ill check the laptop works imac tomorrow for specifics etc The alterations i did earlier after i sent the first email are still intact :) I understand that the NNNDDD etc are not stored with in the format, but just wondered where the jewish annotations came into effect? ive never used them in the past, my laptop is setup for UK english, and it was all working fine last time i looked at that particular area? And there definatly was no jewish annotation in there? the top reference in the list of pre-set annotations mentioned above is [~jewish]D , and in the format box it is Friday 22 Tevet 5760 and in the preview box it is Monday 9 Tammuz 5774, i dont even know if thats correct? or if the jewish calendar works on a different format?? If there are any jewish memebers out there reading this, let me know please :) There appears to be 10 with in the list, that appeared, and the one that i defined manually NN D appears after them? ill check with my works mac in a bit, i know i opened the file there, its running ver 3, ill double check its set for UK etc, but i normally make a point of changing the locale to UK, saying that it was a long time ago Ver 3 came out, and i cant remote log in to check etc. I do know that was not the cause of the corruption, as i emailed the file over to a collegue to review the work, and he said the formula made no sense, so i loaded it on the Ver 3 at work, and saw the corruption etc. I have also as a test just copied the cell into a new spreadsheet, and it took over the jewish annotation? i then created a new spreadsheet, and just entered a date, and changed its format, and there was no jewish annotation? but ive never used any other computer apart from the laptop to open the file, ive copied/emailed to others or opened from dropbox, but not saved it, apart from the one time mentioned above, when the corruption had already occured. I was just looking for insights as to whether anyone else has had the problem? i just dont want to go much further, and loose the lot, thinking about it, ill see how many revisions i can go back on dropbox, and see when it happened... Sorry guys if some doesnt make sense, my eyes are hurting, and its late, and i was a tad annoyed earlier when my boss said i want those sheets and im like AGGGHH cheers Phil On 06/07/2014 17:01, Brian Barker wrote: At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details D 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]D 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? Yes and no. There are a few things worth knowing. o The definition of ODF says that the format code is a sequence of characters with an implementation-defined meaning, so clearly it can be different in different standards-respecting applications. So formats such as D are not saved as such in ODF document files. Instead, it seems that three things are saved: the date in ISO standard form (2014-10-06), the actual text as displayed (Monday 6 October 2014), and a description in different terms of your chosen format - such things as: number:day-of-week number:style=long / number:text / number:day / number:text / number:month number:style=long number:textual=true / number:text / number:year number:style=long / When you reopen a document, the necessary formats must be reconstituted from this information in the file. o Dates in particular are reconstituted with reference to the current locale. If, for example, I enter today's date (6 July) in my UK locale, it is displayed naturally as 06/07/14. If I save that in a document and reopen it in a US locale, the format is automatically reconstituted differently, with the same cell being displayed instead as 07/06/14. o It seems that some formats that have been used or appeared automatically but perhaps are no longer needed are nevertheless saved in the document. So I think some of this could be explained by this document having been opened and resaved on a system with locale set to Hebrew. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?
At 00:05 07/07/2014 +0100, Philip Ward wrote: On 06/07/2014 17:01, Brian Barker wrote: At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details D 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]D 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? Yes and no. There are a few things worth knowing. o The definition of ODF says that the format code is a sequence of characters with an implementation-defined meaning, so clearly it can be different in different standards-respecting applications. So formats such as D are not saved as such in ODF document files. Instead, it seems that three things are saved: the date in ISO standard form (2014-10-06), the actual text as displayed (Monday 6 October 2014), and a description in different terms of your chosen format - such things as: number:day-of-week number:style=long / number:text / number:day / number:text / number:month number:style=long number:textual=true / number:text / number:year number:style=long / When you reopen a document, the necessary formats must be reconstituted from this information in the file. o Dates in particular are reconstituted with reference to the current locale. If, for example, I enter today's date (6 July) in my UK locale, it is displayed naturally as 06/07/14. If I save that in a document and reopen it in a US locale, the format is automatically reconstituted differently, with the same cell being displayed instead as 07/06/14. o It seems that some formats that have been used or appeared automatically but perhaps are no longer needed are nevertheless saved in the document. So I think some of this could be explained by this document having been opened and resaved on a system with locale set to Hebrew. I understand that the NNNDDD etc are not stored with in the format, but just wondered where the jewish annotations came into effect? If I understand you correctly, these are just appearing as possible formats in the Format Cells dialogue. If so, I don't think you should be too worried about them. I don't claim to understand all the aspects of locale settings, which exist separately for operating systems (including individual user settings) as well as for applications, such as LibreOffice. If Calc thinks you might be helped by these offerings but you don't need them, there is no problem I can see the top reference in the list of pre-set annotations mentioned above is [~jewish]D , and in the format box it is Friday 22 Tevet 5760 ... That corresponds to Gregorian 31 December 1999, which is the date used for all format examples in the Format Cells dialogue. ... and in the preview box it is Monday 9 Tammuz 5774, i don't even know if that's correct? That's Monday 7 July 2014 in the Gregorian calendar, i.e. today. ... or if the Jewish calendar works on a different format? Well, yes: it has a different origin, of course - a point in 3761 BC by the Gregorian calendar - as well as different month names, which don't correspond with Gregorian months since they are generally shorter and need additional intercalary months every two or three years to keep the calendar in step with the solar year. I have also as a test just copied the cell into a new spreadsheet, and it took over the jewish annotation? By default, pasting carries over formats as well as values. You can suppress this using Paste Special... . I was just looking for insights as to whether anyone else has had the problem? i just don't want to go much further, and lose the lot, ... The question of available formats doesn't affect your use of the spreadsheet, does it? I suspect it is a red herring and may have no connection with the other corruption you mentioned (about which I have no comment). Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] spreadsheets / timelines ... + queries
Thank you for your timely response - but unfortunately your response is over my head ;-( If I were to upgrade to .5 - [yes, I will be keeping .4 in the download folder] - what do I click on to so do? - all I see are various blocks mentioning various options with no download button ??? BTW - just what is torrent? - I keep hearing that word, yet still have no inkling as to what it refers ;-( On Sun, Jul 15, 2012 at 1:14 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) (2) The 'buttons' are not really proper buttons. http://www.libreoffice.org/download/ You have to click on the appropriate text inside the button/block. Sometimes a 'button' has a couple of different links that do slightly different things. It would be awkward to have a 3way button that had 1. Normal download when you click the top half 2. Torrent download when click the bottom half and 3. Information when you click the right-hand-side Putting all 3 together in a fake button means people usually wave their mouse around and click on something and then work it out. It's a good idea to keep the installer file (assuming you are on Windows) for the version you are familiar with so that if you don't like the upgrade then you can return to the familiar very easily. It's much less of an issue by around .3, .4 and onwards because things have settled down a lot by around then. It's more an issue when tons of new features have just been added, such as with the .0 releases. That 3rd digit is a bit like a Service Pack (like Xp Sp3 or Win7 Sp1). So i will be downloading and installing the .5 with no qualms (but i'll keep the .4 installer on 1 machine jic) (1) dunno. I suspect that Draw might be good for doing a time-line but if you are looking for proper calendar-type functionality then there are a few other packages depending on what sort of level you are aiming at. Project Managers with a dizzying arrray of interlocking sub-projects and mums with a couple of kids need something a lot more sophisticated than the average user. Regards from Tom :) From: anne-ology lagin...@gmail.com Subject: Re: [libreoffice-users] spreadsheets / timelines ... + queries To: users@global.libreoffice.org Date: Saturday, 14 July, 2012, 22:42 (1) Curiously wondering how timelines are done with this program - I've heard it's possible ... I've gone to the help-site ... Is it through these spreadsheets? ... or ??? (2) could someone explain if it's time to update to this .5 over .4 - and if so, how to do so; I've gone to the download site ... but there's only blocks of varying programs with no clickable download button ??? Looking forward to learning more of this fascinating program from this list - you all sound to be quite knowledgeable, On Fri, Jul 13, 2012 at 2:17 PM, Milos Sramek sramek.mi...@gmail.com wrote: Hi, is it a bug or not? 1. I open an xls file with a sheet with cells protected by a password 2. I save it in odf format - no messages, works without problems 3. I open the new odf file and want to save it in xls. LO requires change of the password (without asking for the original one) Is it OK that LO asks for the password change when saving from odf to xls but not when saving from odf to xls? What do you think? (according to the help it is ok that LO can change the password, I am asking only about the different behavior in similar situations) Thanks Milos -- email jabber: sramek.mi...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] spreadsheets / timelines ... + queries
Hi :) (2) The 'buttons' are not really proper buttons. http://www.libreoffice.org/download/ You have to click on the appropriate text inside the button/block. Sometimes a 'button' has a couple of different links that do slightly different things. It would be awkward to have a 3way button that had 1. Normal download when you click the top half 2. Torrent download when click the bottom half and 3. Information when you click the right-hand-side Putting all 3 together in a fake button means people usually wave their mouse around and click on something and then work it out. It's a good idea to keep the installer file (assuming you are on Windows) for the version you are familiar with so that if you don't like the upgrade then you can return to the familiar very easily. It's much less of an issue by around .3, .4 and onwards because things have settled down a lot by around then. It's more an issue when tons of new features have just been added, such as with the .0 releases. That 3rd digit is a bit like a Service Pack (like Xp Sp3 or Win7 Sp1). So i will be downloading and installing the .5 with no qualms (but i'll keep the .4 installer on 1 machine jic) (1) dunno. I suspect that Draw might be good for doing a time-line but if you are looking for proper calendar-type functionality then there are a few other packages depending on what sort of level you are aiming at. Project Managers with a dizzying arrray of interlocking sub-projects and mums with a couple of kids need something a lot more sophisticated than the average user. Regards from Tom :) --- On Sat, 14/7/12, anne-ology lagin...@gmail.com wrote: From: anne-ology lagin...@gmail.com Subject: Re: [libreoffice-users] spreadsheets / timelines ... + queries To: users@global.libreoffice.org Date: Saturday, 14 July, 2012, 22:42 (1) Curiously wondering how timelines are done with this program - I've heard it's possible ... I've gone to the help-site ... Is it through these spreadsheets? ... or ??? (2) could someone explain if it's time to update to this .5 over .4 - and if so, how to do so; I've gone to the download site ... but there's only blocks of varying programs with no clickable download button ??? Looking forward to learning more of this fascinating program from this list - you all sound to be quite knowledgeable, On Fri, Jul 13, 2012 at 2:17 PM, Milos Sramek sramek.mi...@gmail.comwrote: Hi, is it a bug or not? 1. I open an xls file with a sheet with cells protected by a password 2. I save it in odf format - no messages, works without problems 3. I open the new odf file and want to save it in xls. LO requires change of the password (without asking for the original one) Is it OK that LO asks for the password change when saving from odf to xls but not when saving from odf to xls? What do you think? (according to the help it is ok that LO can change the password, I am asking only about the different behavior in similar situations) Thanks Milos -- email jabber: sramek.mi...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] spreadsheets / timelines ... + queries
(1) Curiously wondering how timelines are done with this program - I've heard it's possible ... I've gone to the help-site ... Is it through these spreadsheets? ... or ??? (2) could someone explain if it's time to update to this .5 over .4 - and if so, how to do so; I've gone to the download site ... but there's only blocks of varying programs with no clickable download button ??? Looking forward to learning more of this fascinating program from this list - you all sound to be quite knowledgeable, On Fri, Jul 13, 2012 at 2:17 PM, Milos Sramek sramek.mi...@gmail.comwrote: Hi, is it a bug or not? 1. I open an xls file with a sheet with cells protected by a password 2. I save it in odf format - no messages, works without problems 3. I open the new odf file and want to save it in xls. LO requires change of the password (without asking for the original one) Is it OK that LO asks for the password change when saving from odf to xls but not when saving from odf to xls? What do you think? (according to the help it is ok that LO can change the password, I am asking only about the different behavior in similar situations) Thanks Milos -- email jabber: sramek.mi...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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