Clearing a Integers Custom Column

Tanjamuse · 09-09-2017, 05:23 PM

Hi.

I have a bunch of Integers Columns that I use for icons.

I accidentally entered a number into one of them, and was wondering if there's anyway to change it back to undefined without having to delete the column and create it again?

Thanks so much in advance.

PeterT · 09-09-2017, 05:42 PM

See https://www.mobileread.com/forums/sh...d.php?t=221187

chaley · 09-09-2017, 05:52 PM

Quote:

Originally Posted by Tanjamuse

Hi.

I have a bunch of Integers Columns that I use for icons.

I accidentally entered a number into one of them, and was wondering if there's anyway to change it back to undefined without having to delete the column and create it again?

Thanks so much in advance.

Set the value to -1000000. This also works in float columns.

If you want to change one cell then you can click in the cell and press CTRL-F2, where F2 is the key your system uses to edit the value in a cell.

BetterRed · 09-09-2017, 09:06 PM

@chaley - you seem to have forgotten - in the book list, F2 (or whatever triggers edit cell - e.g. double click) then space on a numeric cell will set it to Undefined, space also works in bulk MDE, not sure about single MDE.

I say 'forgotten', because you did the change, about same time as you did the '=' (today) and '-' (clear) for dates.

BR

Tanjamuse · 09-10-2017, 04:07 AM

Thanks. I did try to search first but I didn't find that thread.

chaley · 09-10-2017, 05:30 AM

Quote:

Originally Posted by BetterRed

@chaley - you seem to have forgotten - in the book list, F2 (or whatever triggers edit cell - e.g. double click) then space on a numeric cell will set it to Undefined, space also works in bulk MDE, not sure about single MDE.

I say 'forgotten', because you did the change, about same time as you did the '=' (today) and '-' (clear) for dates.

BR

Yes, I did forget that. I never use it and my brain tosses out things more than a few days old.

To be complete, looking at the code I see that I (or Kovid) also added a right-click context menu item to clear the number. This would be must useful if one is using double-click to open the editor. Double-click, right-click, choose Set to undefined.

And it works in single MDE.

09-09-2017, 05:23 PM	#1
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	Clearing a Integers Custom Column Hi. I have a bunch of Integers Columns that I use for icons. I accidentally entered a number into one of them, and was wondering if there's anyway to change it back to undefined without having to delete the column and create it again? Thanks so much in advance.

09-09-2017, 09:06 PM	#4
BetterRed null operator (he/him) Posts: 20,572 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@chaley - you seem to have forgotten - in the book list, F2 (or whatever triggers edit cell - e.g. double click) then space on a numeric cell will set it to Undefined, space also works in bulk MDE, not sure about single MDE. I say 'forgotten', because you did the change, about same time as you did the '=' (today) and '-' (clear) for dates. BR Last edited by BetterRed; 09-09-2017 at 09:09 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move selected data from series column to a new custom column	fvdham	Library Management	3	06-02-2017 03:49 PM
Custom column returns value based on value of another custom column?	calvin-c	Calibre	3	09-14-2013 02:24 PM
Custom yes/no column built from long text column	Philantrop	Library Management	7	03-23-2013 07:44 PM
how to move value(s) of tag column to a custom made column	zoorakhan	Library Management	0	12-08-2012 03:53 AM
Can custom book data be displayed in a custom column?	kiwidude	Development	9	03-02-2011 05:35 AM

09-09-2017, 05:42 PM	#2
PeterT Grand Sorcerer Posts: 12,167 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	See https://www.mobileread.com/forums/sh...d.php?t=221187

09-10-2017, 04:07 AM	#5
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	Thanks. I did try to search first but I didn't find that thread.

Advert

Advert