Fwd: Re: Calc changed dates catastrophically
Forwarded to poster as he isn't subscribed. Original Message Subject:Re: Calc changed dates catastrophically Date: Fri, 18 Jul 2014 12:01:05 +1000 From: Martin Groenescheij Reply-To: mar...@groenescheij.com To: users@openoffice.apache.org CC: mar...@groenescheij.com Look at the date settings under Tools --> Options --> OpenOffice Calc --> Calculate On the top right there is a setting for Date make sure you use the same as in the previous version of Calc. On 18-7-2014 6:28, Ari Heikkilä wrote: Hi I'm using Apache OO 4.1.0 Calc for booking thousands of rows of work, payment and billing. In each row are three dates (dd.mm.yy). In the late version there were tens of thousands of rows. But it was never like now: When I saved the work and looked, almost all dates were changed 4y1d or 4y2d older. Minority was not. I take backups all the time, but unfortunately the last was then several days old, and I'v done plenty of updating data. Tracing my changes backward is hard days work. Before trying to mend data, I want to know, how is it, that Calc does catastrophe like this. And how can I be sure, it doesn't make it again. Versions of OO have been several in my use, but no bug of this kind, since and so far. By Google I can find hints of problems of this kind, but no solution. And the community have not taken the bug for fixing. Surely the bug is difficult to repeat. I guess, it must be with 'basedate', but I'v not changed it ever (naturally). If I change it now, the corrupted dates shift 4y1d more older. The plain date-number in the cell have been shifted permanently. If the corruption was frequent, i.e. ALL the dates was shifted the same, I could try by somewhat function or math. But there are at least three cases. Almost impossible. Have anyone experience or advice? Yours Ari Heikkilä, Finland - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Calc changed dates catastrophically
Look at the date settings under Tools --> Options --> OpenOffice Calc --> Calculate On the top right there is a setting for Date make sure you use the same as in the previous version of Calc. On 18-7-2014 6:28, Ari Heikkilä wrote: Hi I'm using Apache OO 4.1.0 Calc for booking thousands of rows of work, payment and billing. In each row are three dates (dd.mm.yy). In the late version there were tens of thousands of rows. But it was never like now: When I saved the work and looked, almost all dates were changed 4y1d or 4y2d older. Minority was not. I take backups all the time, but unfortunately the last was then several days old, and I'v done plenty of updating data. Tracing my changes backward is hard days work. Before trying to mend data, I want to know, how is it, that Calc does catastrophe like this. And how can I be sure, it doesn't make it again. Versions of OO have been several in my use, but no bug of this kind, since and so far. By Google I can find hints of problems of this kind, but no solution. And the community have not taken the bug for fixing. Surely the bug is difficult to repeat. I guess, it must be with 'basedate', but I'v not changed it ever (naturally). If I change it now, the corrupted dates shift 4y1d more older. The plain date-number in the cell have been shifted permanently. If the corruption was frequent, i.e. ALL the dates was shifted the same, I could try by somewhat function or math. But there are at least three cases. Almost impossible. Have anyone experience or advice? Yours Ari Heikkilä, Finland - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Calc changed dates catastrophically
Hi I'm using Apache OO 4.1.0 Calc for booking thousands of rows of work, payment and billing. In each row are three dates (dd.mm.yy). In the late version there were tens of thousands of rows. But it was never like now: When I saved the work and looked, almost all dates were changed 4y1d or 4y2d older. Minority was not. I take backups all the time, but unfortunately the last was then several days old, and I'v done plenty of updating data. Tracing my changes backward is hard days work. Before trying to mend data, I want to know, how is it, that Calc does catastrophe like this. And how can I be sure, it doesn't make it again. Versions of OO have been several in my use, but no bug of this kind, since and so far. By Google I can find hints of problems of this kind, but no solution. And the community have not taken the bug for fixing. Surely the bug is difficult to repeat. I guess, it must be with 'basedate', but I'v not changed it ever (naturally). If I change it now, the corrupted dates shift 4y1d more older. The plain date-number in the cell have been shifted permanently. If the corruption was frequent, i.e. ALL the dates was shifted the same, I could try by somewhat function or math. But there are at least three cases. Almost impossible. Have anyone experience or advice? Yours Ari Heikkilä, Finland - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Fw: emailadresse openoffice 4.1.0
Sorry, but I do not write German. At 12:09 17/07/2014 +0200, Günther Bolte wrote: Sehr geehrter Herr Tesch, I'm not Herr Tesch; will I do? Ich benutze Win7 ohne Outlook o.ä. (Angriffsfläche vermindern), Software und Treiber immer aktuell, COMODO Internet Security Premium. Bei meinem PC stürzt OpenOffice ab (friert ein), wenn ich im Calc an ein Feld mit Email-Adresse gehe. So kann ich eine falsch eingetippte Email-Adresse nicht ändern. Die eingebaute Hilfe gibt keinen Hinweis darauf, wie ich die www-connectivity abschalten kann. As you imply, the problem with a cell containing only an e-mail address is that this will have been automatically converted to a hyperlink, and when you double-click on the cell in order to edit it, the hyperlink will be stimulated and OpenOffice will at least hesitate whilst a new mail message is created. What happens next will depend on what you have registered as your mail client. Perhaps you have none: maybe you use a web interface to your mail. Was kann ich tun? Many things: o If you do not want the addresses to act as hyperlinks, go to Tools | AutoCorrect Options... | Options and remove the tick from URL Recognition - before you enter them. o If you do not want the addresses to act as hyperlinks but you have already entered them, select the cell - or even a range, such as an entire column - and go to Format | Default Formatting (or Ctrl+M). o If you need to edit the address in a cell, you can double-click on a part of the cell outside the hyperlink - either additional text or in a blank part of the cell. Expand the column width if necessary to allow this. You cannot edit the address directly, but you can replace it. o Alternatively, you can remove the hyperlink first, as above, and then edit the original text. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Fw: emailadresse openoffice 4.1.0
> Gesendet: Donnerstag, 17. Juli 2014 um 12:09 Uhr > Von: "Günther Bolte" > An: f...@openoffice.org > Betreff: emailadresse openoffice 4.1.0 > > Sehr geehrter Herr Tesch, > > Ich benutze Win7 ohne Outlook o.ä. (Angriffsfläche vermindern), Software und > Treiber immer aktuell, COMODO Internet Security Premium. > > Bei meinem PC stürzt OpenOffice ab (friert ein), wenn ich im Calc an ein Feld > mit Email-Adresse gehe. So kann ich eine falsch eingetippte Email-Adresse > nicht ändern. Die eingebaute Hilfe gibt keinen Hinweis darauf, wie ich die > www-connectivity abschalten kann. > > Was kann ich tun? > > Mit freundlichen Grüßen > G. Bolte > > -- > einfach mal 'reinschauen unter www.rtc-koeln.de > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office vs MS Office
On 7/14/2014 10:16 PM, Senior.System Analyst wrote: >(a) Formatting (color size, shapes, etc.) may change once MS word document is opened in Open Office. As a general rule, if the document remains the same when opened with different versions of MSO, it will remain the same when opened with AOo. >(b) Sometimes behaviour of open office is uncertain when using Smart Art & Word Art styles (of MS Power point, excel). This is problematic when switching between document formats, and programs that can not read/write/edit ODF file formats. > (c) Animation of MS Powerpoint slides does not always work as desired in Open > Office. Known issue. > (d) Although macros are supported in Open Office but the Macros created using > MS Office cannot be executed in Open Office. AOo and MSO use different languages for macros. As such, you'll have to rewrite the macros in a language that AOo understands. That said, there used to be a program that converted MSO macros to AOo. I don't know if that program is still available. When migrating to AOo from MSO, two things are vital: * Rewrite all macros in a language that AOo can utilize; * Construct all templates from scratch, specifically for AOo; That means that your organization will either have to train somebody in-house to write macros, and construct templates, or hire an independent contractor to perform that task for your organization. > (e) Some of the features that are easily available in MS Office could not be > found in Open office such as;- > (i) Spelling / Grammar check Dictionaries in all of the official languages of India have been released. However, they have not been maintained. OTOH, fixing errors, adding words, deleting words, etc to a dictionary is fairly straightforward. Thus far, the grammar checkers have focused on European languages. Language Tool has a basic rule set for Malayalam. Developing functional rule sets requires both a deep knowledge of the grammar of the language, and a comprehensive understanding of XML. Understanding when, and more importantly, when _not_ to create rules used by Language Tool is an art form that few people master. Between the various grammar checkers, roughly 40 languages can claim some type of grammar checking. However, I wouldn't rely on any of them. OTOH, I've yet to see any of them do what MSO specializes in --- claim the sentence is grammatically incorrect, change it to what it calls correct, and then claim the correction is grammatically incorrect, and change it back to the way it was, repeating the cycle ad infinitum. > (ii) View files side by side with Synchronous scrolling I've seen that demoed in an OpenOffice.org fork, but don't know which fork it was, nor how it was done. :( For the time being, assume it isn't present in AOo, and won't be included for a couple of versions. > (iii) Converting the impress document into PDF results in the printing of > all hidden slides too. That is a configuration issue. Change the settings, and the behaviour will change. jonathon - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org