Deleting a date - Page 2

davidfor · 07-08-2013, 06:58 AM

Quote:

Originally Posted by BetterRed

BR meant exactly what he wrote

Sorry, but it wasn't exactly clear that you meant for the "-" to be typed and wasn't punctuation. The only reason I considered it was that you had a "=" in the set to today example.

Quote:

After I press F2 on ANY editable cell in the spreadsheet the content of the cell is always selected - to un-select it I must press home, end, left arrow or right arrow.

Well, if you press F2 on a date, only part of the date is selected. When I tried this earlier, I automatically selected the rest of the field before pressing the minus.

Quote:

There is no need to check anything. To clear a date just press the F2 key, followed by the '-' key, followed by the Enter key; use the '=' to set to today. If you change your mind exit the cell edit with Escape.

Personally, that is much clearer than what you originally wrote and why I expanded on it.

BetterRed · 07-08-2013, 08:35 AM

Aaah I see, both davidfor and HFC3 missed the subtlety of my italics

I use italics to avoid the confusion of putting things in quotes

Maybe underline would be better than italics, but not all BB boards support underline.

BR

PeterT · 07-08-2013, 08:55 AM

And an italic = or - does not really jump out of the screen !

== --

Can YOU tell the difference in the line above?

BetterRed · 07-08-2013, 09:28 AM

Quote:

Originally Posted by PeterT

And an italic = or - does not really jump out of the screen !

== --

Can YOU tell the difference in the line above?

No, but that's not what I wrote -this is what I wrote

You can clear a date in the spreadsheet by highlighting the field, then press F2-enter

You can set a date in the spreadsheet to today by highlighting the field, then press F2=enter

If people can't see the italics then they should probably increase the font size in their browser, in firefox & chrome that's done via ctrl/num+

BR

PeterT · 07-08-2013, 09:48 AM

Yes.... I can (and do see) italics on the F2 and the Enter; the challenge is that it's not at all obvious that the hyphen and equals key were to be included in the keystrokes.

I'll butt out now

HFC3 · 07-08-2013, 11:41 AM

"-" made the difference. I took "F2-enter" to be >F2< and >Enter<.

I'm curious why that would make a difference programatically.

theducks · 07-08-2013, 01:47 PM

Quote:

Originally Posted by HFC3

"-" made the difference. I took "F2-enter" to be >F2< and >Enter<.

I'm curious why that would make a difference programatically.

f2 = edit mode
the - causes the clear (unspecified)
Enter (mouse click outside the field) ends the edit mode

HFC3 · 07-12-2013, 09:36 AM

I type keystroke instructions like this; >F2< "-" >Enter<. Or, maybe >F2< >Hyphen< >Enter<. I typically use >< surrounding actual keys and "" surrounding literal keystrokes when I have to enter keyboard commands.

This is what I call "Mom Proof". LOL I wrote an instruction manual for an inventory control program I wrote in High School, and tested it until I was (literally) blue! Mom took it, and complained that she couldn't read all the information since it was jammed into a little field.

Mom's! I said you had to press >Enter< after each field; Product Code >Enter< Product Name, etc. "But that's not what you said in the instructions!". E-gads!

Of course, this was in 1980 when computers were still unknown, but I mean really. Parents can be such a burden LOL

This especially helpful if the literals needed are the same as a key abbreviation; for instance what if it was F2F2enter? >F2< "F2" >Enter<? This way it's obvious (at least to me. Well, Mom, too)" that the first F2 is a key and the 2nd is the letter F and the number 2.

BetterRed. your "F2-enter would have probably been OK except that "-" kind of hides. Part of the confusion is that - is such a little character

Even so, the goal was accomplished, and we now know how to remove a date! I'm definitely not complaining because I needed an extra push (kick) to understand instructions.

07-08-2013, 08:35 AM	#17
BetterRed null operator (he/him) Posts: 20,568 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Aaah I see, both davidfor and HFC3 missed the subtlety of my italics I use italics to avoid the confusion of putting things in quotes Maybe underline would be better than italics, but not all BB boards support underline. BR Last edited by BetterRed; 07-08-2013 at 08:42 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Publication Date or Copyright Date or ???	hd_cal_dave	Library Management	8	05-25-2012 01:50 PM
Date Added vs. Date Modified	aglaia761	Calibre	5	11-28-2010 05:34 AM
Bulk Changing Published Date To Date	hmf	Calibre	4	10-19-2010 10:19 PM
Up-to-date candy teacher (date being 1921)	kacir	Deals and Resources (No Self-Promotion or Affiliate Links)	0	06-16-2010 04:18 PM
new official shipping date / US invitation date	R2D2	iRex	18	07-06-2006 02:32 PM

07-08-2013, 08:55 AM	#18
PeterT Grand Sorcerer Posts: 12,167 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	And an italic = or - does not really jump out of the screen ! == -- Can YOU tell the difference in the line above?

07-08-2013, 09:48 AM	#20
PeterT Grand Sorcerer Posts: 12,167 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	Yes.... I can (and do see) italics on the F2 and the Enter; the challenge is that it's not at all obvious that the hyphen and equals key were to be included in the keystrokes. I'll butt out now

07-08-2013, 11:41 AM	#21
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	"-" made the difference. I took "F2-enter" to be >F2< and >Enter<. I'm curious why that would make a difference programatically.

07-12-2013, 09:36 AM	#23
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	I type keystroke instructions like this; >F2< "-" >Enter<. Or, maybe >F2< >Hyphen< >Enter<. I typically use >< surrounding actual keys and "" surrounding literal keystrokes when I have to enter keyboard commands. This is what I call "Mom Proof". LOL I wrote an instruction manual for an inventory control program I wrote in High School, and tested it until I was (literally) blue! Mom took it, and complained that she couldn't read all the information since it was jammed into a little field. Mom's! I said you had to press >Enter< after each field; Product Code >Enter< Product Name, etc. "But that's not what you said in the instructions!". E-gads! Of course, this was in 1980 when computers were still unknown, but I mean really. Parents can be such a burden LOL This especially helpful if the literals needed are the same as a key abbreviation; for instance what if it was F2F2enter? >F2< "F2" >Enter<? This way it's obvious (at least to me. Well, Mom, too)" that the first F2 is a key and the 2nd is the letter F and the number 2. BetterRed. your "F2-enter would have probably been OK except that "-" kind of hides. Part of the confusion is that - is such a little character Even so, the goal was accomplished, and we now know how to remove a date! I'm definitely not complaining because I needed an extra push (kick) to understand instructions.

Advert

Advert