| Summary: | only the equal sign is accepted as beginning of a formula | ||
|---|---|---|---|
| Product: | [Applications] calligrasheets | Reporter: | Ferdinand Gassauer <gassauer> |
| Component: | general | Assignee: | Laurent Montel <montel> |
| Status: | CONFIRMED --- | ||
| Severity: | wishlist | CC: | aristsakas, esigra |
| Priority: | NOR | ||
| Version First Reported In: | 1.1 | ||
| Target Milestone: | --- | ||
| Platform: | Compiled Sources | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
|
Description
Ferdinand Gassauer
2001-06-21 11:59:59 UTC
Hello Ferdinand I don't think that we can use '+' or '-" as they are used for positv or=20 negativ information. Okay the '+' maybe unnecessary but at the end I don= 't=20 think it makes sense but there is only one way to input -10. I would like to close this wish as it doesn't really make sense (yes I'm= =20 working on german keyboard too but I don't know anybody in may company who= =20 is entering formulas with one hand or has complained about the only=20 possibility "=3D" in MS EXCEL). Do you think we can close this? Philipp On Friday 05 April 2002 19:34 Philipp M=FCller wrote: > Hello Ferdinand > > I don't think that we can use '+' or '-" as they are used for positv or > negativ information. Okay the '+' maybe unnecessary but at the end I > don't think it makes sense but there is only one way to input -10. > > I would like to close this wish as it doesn't really make sense (yes I'm > working on german keyboard too but I don't know anybody in may company w= ho > is entering formulas with one hand or has complained about the only > possibility "=3D" in MS EXCEL). Wouldn't help much ;-) I usualy put my left hand fingers near the number on the paper where I read= =20 the information. And as long as only ONE number has to be entered in one ce= ll=20 there is no problem. > Hm! Couldn't we do better than EXCEL ? Entering -10 shows "-10" 10 shows "10" +10 shows "10" all numbers Entering -10+4 shows a _string_ "-10+4" but IMHO the number "-6" is more reasonable= =20 with a formula "=3D-10+4" and I rarely want to see "-10+4" which could be= =20 achieved by entering "'-10+4". I actualy use this regulary to remember how I came up with a number. May be make it configurable? IMHO it shouldn't be to difficult to automagicaly add a "=3D" in front if a= =20 operator is entered after a number/cell. But what is more important: Entering + UP-Arrow in A2 gives "+" in A2 and moves the cursor to A1 but i= t=20 should give "+A1" in A2 (as in EXCEL). > Do you think we can close this? May be we try to get more opinions on this. I cc it to kde-devel > > Philipp --=20 cu ferdinand http://www.goesing.at On Friday 05 April 2002 19:34 Philipp M=FCller wrote: > Hello Ferdinand > > I don't think that we can use '+' or '-" as they are used for positv or > negativ information. Okay the '+' maybe unnecessary but at the end I > don't think it makes sense but there is only one way to input -10. > > I would like to close this wish as it doesn't really make sense (yes I'm > working on german keyboard too but I don't know anybody in may company w= ho > is entering formulas with one hand or has complained about the only > possibility "=3D" in MS EXCEL). Wouldn't help much ;-) But actualy this is what EXCEL does Entering +3+4 gives 7 with a formula "=3D3+4" --=20 cu ferdinand http://www.goesing.at *** Bug 58159 has been marked as a duplicate of this bug. *** On Friday 16 July 2004 18:42, ameo wrote: > Hi Marc, Ariya, > > Thanks for your interest in this. At work I have a French QWERTZ > keyboard huh? French is AZERTY :) QWERTZ is German. > FWIW, I notice OpenOffice Calc also requires an "equals" sign. Hmm, this means we might have to convert '+' to '=' automagically.... Either at saving time or right after typing, not sure which one would result in less surprise. I just checked it again Excel (97) allows to start a formula with "+" or "-" and automatically adds a "=" when leaving the cell (hitting enter or any of the arrows keys) and displaying the result instead of the formula. it also checks the syntax +5+6z is recognized as error and suggests to change it to +5+z6 which would be a valid formula cu ferdinand |