![]() There is no way to prevent Calc from recognizing dates, or fractions, except to prevent any recognition at all, and every entry is taken as literal text. The formula input is not lost, it just looks strange because it's being displayed through a date format. However, in that situation, if I then type Ctrl+M (Format > Default Formatting), the simple numeric value is shown: 0.33. "1/3" ->, and then I try to replace the date value by re-entering the formula: "=1/3", Calc gets the numeric value (0.333.) but keeps the date formatting, and the cell then shows a date of. If I mistakenly enter something that Calc recognizes as a date, e.g. I fail to see the wisdom in that plan.Īnd I agree that Calc's behavior is pretty surprising when you go back and re-enter a new value over a date. For me, it actually gets recognized as a fraction and goes in as text: "¼". Hmm, ok, I assumed that "1/4" was being recognized as a date and I neglected to double-check. If other people think that's a feature, that's fine with me but please, please tell me how to turn it off. Not only do I have to change the formatting back to the default with a menu option, I *also* have to retype the text. But somehow, unlike most other programs I type things into, I can't use the backspace key to correct a simple typo. Unfortunately, I'm imperfect, and sometimes I type the wrong thing. ![]() I write enough code to understand that having it magically know what I meant is impossible. I really don't mind working with Calc and understanding what it's doing. Secondly, even if I retype it *with* the equals sign to specify I mean a formula, it *still* changes it to a date. I don't mind the formatting - I'm happy to place an equals in front to tell it I meant a formula. It replaces the text I typed with something else. Firstly, when I *mistakenly* type 1/4 (no apostrophe, no equals) Calc does not simply format it as a date. There are two behaviors I want to turn off. If I wanted to format text nicely or build a database I'd be using a different application. That's why I opened up Calc in the first place. Nor do I want pure text formatting - I'm trying to do math, here. No, putting an apostrophe in front is most emphatically *not* all that is required. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |