Rechtschreibprüfung
Guten Morgen! Seit einigen Tagen werden bei mir alle deutschen Worte als Fehler angezeigt. Bei Extras - Rechtschreibprüfung sehe ich aber, dass Deutsch (Deutschland) eingestellt ist. Beispiel: Ein neuer Download von Open Office hat nichts geändert. Obwohl ich in der deutschen Rechtschreibung fit bin, stört mich einfach diese Anzeige. Was kann ich tun? Mit freundlichen Grüßen Peter Münch -- Peter Münch Steinenberg 8 89584 Ehingen - Erbstetten Tel.: 07386 97 51 92 Papier ist der billigste Langzeitspeicher. Muss diese Nachricht wirklich aufbewahrt werden?Bitte bedenken Sie die Auswirkungen auf die Umwelt, bevor Sie diese E-Mail ausdrucken. Diese Nachricht kann vertrauliche und/oder rechtlich geschützte Informationen beinhalten. Sollten Sie nicht der richtige Adressat sein, oder diese Nachricht irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten diese Nachricht. Das Kopieren, die unerlaubte Weitergabe sowie anderweitige Nutzung des Inhalts dieser Nachricht ist untersagt. This message may contain confidential and/or privileged information. If you are not the intended recipient or have received this message in error, please Inform the sender immediately and destroy this message. Any copying, unauthorized distribution or disclosure of the content of this message is forbidden.
Re: Stop reducing fractions
On 21-Mar-15 09:39, Vincent A. Juliano wrote: Gentlemen/Ladies I have been successful in properly entering fractions into my table. Now however the fractions do not remain as I wrote them but are being reduced to the nearest single digit numerator as soon as I go to the next column to enter the next fraction.. what must I do to keep the fractions in their original form? If you have formatted the cell as Fraction it should display 1 1/4 when you enter 1.25 as value If you have formatted as Number with 2 decimals it displays 1.25 with zero decimals if will display 1 Now if you enter 1 1/4 instead of 1.25 it displays 1 ¼, because this value is in the AutoCorrect table the problem with this is that the value is treated as text instead of numeric and hence you can't use this in a calculation. Thank you. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Stop reducing fractions
At 18:39 20/03/2015 -0400, Vincent A. Juliano wrote: I have been successful in properly entering fractions into my table. Are we talking about a table in a text (Writer) document or material in a spreadsheet? (I suspect the answer may be the same in either case.) Now however the fractions do not remain as I wrote them but are being reduced to the nearest single digit numerator as soon as I go to the next column to enter the next fraction. Good-oh! That's what I'd want. If I add two cells that each contain two, I expect to see the number 4 displayed as the result, not the text string 2+2, still less 3+1 - neither of which are exactly wrong. But it's perfectly possible to store and handle such text strings if you wish - but not easily to calculate with them, of course. what must I do to keep the fractions in their original form? I don't think you can. If you add 1/3 and 1/6 and if you are genuinely calculating, you would surely want to see 1/2, not 3/6 or 1/3+1/6? You probably need to decide whether you are representing these values for their appearance or as their actual value, in which latter case the simplest form would always be preferable. o If you don't need to calculate, don't use the Fraction formatting style; instead, enter your values as Text. o If you need to calculate but have some need for unusual formatting, you probably need to do the work yourself. There are various ways to do this. oo You could maintain two versions of the values - one for show and one for calculation. For reliability, you should calculate one from the other, not maintain them separately. You could hide the calculation version if you preferred. oo If the denominator was always the same, you could achieve what you ask using formatting. In the example above, you could store 2 and 1 in your cells and sum them to 3. With the cell format set to #/6 you would see 2/6 added to 1/6 to give 3/6. (This works both in text tables and spreadsheet documents.) But if you are always working in sixths, why not indicate that at the head of the column or outside the table and keep just the numerators in that table - just as you similarly would a physical unit.? 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
Re: Rechtschreibprüfung
Hallo, du hast in dem Dokument oder der Standardvorlage nicht Deutsch eingestellt, sondern wahrscheinlich Englisch. Änder das da (F11) evtl auch noch andere Items und speicher dann das Dokument als Vorlage. Horst Am 21.03.2015 um 11:18 schrieb Peter Münch: Guten Morgen! Seit einigen Tagen werden bei mir alle deutschen Worte als Fehler angezeigt. Bei Extras - Rechtschreibprüfung sehe ich aber, dass Deutsch (Deutschland) eingestellt ist. Beispiel: Ein neuer Download von Open Office hat nichts geändert. Obwohl ich in der deutschen Rechtschreibung fit bin, stört mich einfach diese Anzeige. Was kann ich tun? Mit freundlichen Grüßen Peter Münch -- Peter Münch Steinenberg 8 89584 Ehingen - Erbstetten Tel.: 07386 97 51 92 Papier ist der billigste Langzeitspeicher. Muss diese Nachricht wirklich aufbewahrt werden?Bitte bedenken Sie die Auswirkungen auf die Umwelt, bevor Sie diese E-Mail ausdrucken. Diese Nachricht kann vertrauliche und/oder rechtlich geschützte Informationen beinhalten. Sollten Sie nicht der richtige Adressat sein, oder diese Nachricht irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten diese Nachricht. Das Kopieren, die unerlaubte Weitergabe sowie anderweitige Nutzung des Inhalts dieser Nachricht ist untersagt. This message may contain confidential and/or privileged information. If you are not the intended recipient or have received this message in error, please Inform the sender immediately and destroy this message. Any copying, unauthorized distribution or disclosure of the content of this message is forbidden.
CSV format Not Present in AOO 4.1.1?
I want to open my data in Calc, but while it sees myfilename.txt It's not offering me the CSV to open it as, and otherwise it wants to open it in Writer, which is not what I want at all. I cleaned a list of data, and added commas between sets of information, and now I want to open it in Calc and sort it, making pretty spreadsheet. Maybe I'm forgetting a step, or steps? I'm pretty tired but need to finish this. Grateful for your help! Linda
Re: CSV format Not Present in AOO 4.1.1?
On Sat, 21 Mar 2015 20:22:10 -0400 Linda Hull chalcedony6...@gmail.com wrote: I want to open my data in Calc, but while it sees myfilename.txt It's not offering me the CSV to open it as, and otherwise it wants to open it in Writer, which is not what I want at all. I cleaned a list of data, and added commas between sets of information, and now I want to open it in Calc and sort it, making pretty spreadsheet. Maybe I'm forgetting a step, or steps? I'm pretty tired but need to finish this. Grateful for your help! Linda The Calc Help file says To Open a Text CSV File in Calc 1. Choose File - Open. 2. Locate the CSV file that you want to open. If the file has a *.csv extension, select the file. If the CSV file has another extension, select the file, and then select Text CSV in the File type box 3. Click Open. The Text Import dialogue box opens. 4. Specify the options to divide the text in the file into columns. You can preview the layout of the imported data at the bottom of the Text Import dialogue box. Right-click a column in the preview to set the format or to hide the column. Mark the text delimiter check box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box. 5. Click OK. -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org