Reset book's numeric field to blank (undefined)?

Rob557 · 07-27-2012, 04:01 AM

In the case of a numeric custom column, is there a convenient way to reset the cell to blank (undefined) for one or more books? If I try to delete the contents of the cell, it defaults to a display of zero.

The only solution that I found so far was to copy the selected book(s) into a temp library and delete/reset the entire column (in the temp library) before copying the book back into the main library, but that is awkward and can lead to lost data if I forget to delete the temp library and use it for other processing.

chaley · 07-27-2012, 09:07 AM

Using either edit metadata/single or on the books spreadsheet: set the value to -999999 (easy way to enter: press the minus key then hold down the 9 key until the field stops changing), then click the small decrement button (the down-pointing arror). The value will change to "undefined".

GeckoFriend · 07-27-2012, 10:28 AM

Thanks for that tip chaley.

Rob557 · 07-27-2012, 11:26 AM

Works great. Thank you chaley !

GeekyGal · 07-31-2012, 04:26 PM

Perfect. Haunting this board is SO educational. Thank you, Chaley.

07-27-2012, 04:01 AM	#1
Rob557 Zealot Posts: 108 Karma: 810 Join Date: Jul 2012 Device: Kobo	Reset book's numeric field to blank (undefined)? In the case of a numeric custom column, is there a convenient way to reset the cell to blank (undefined) for one or more books? If I try to delete the contents of the cell, it defaults to a display of zero. The only solution that I found so far was to copy the selected book(s) into a temp library and delete/reset the entire column (in the temp library) before copying the book back into the main library, but that is awkward and can lead to lost data if I forget to delete the temp library and use it for other processing.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Blank field in "Browse for folder"	Roel	Library Management	7	04-29-2012 11:13 AM
Blank screen after factory reset	IxiaAurea	Kobo Reader	5	09-28-2011 08:44 AM
(Development) What are these apparently-undefined python operators?	offby1	Calibre	5	06-26-2010 12:57 PM
PRS-600 Sony library - Error undefined	omk3	Sony Reader	13	01-22-2010 11:52 AM
Cybook Numeric Entry Dialog	delphidb96	OpenInkpot	8	08-07-2008 10:54 AM

07-27-2012, 09:07 AM	#2
chaley Grand Sorcerer Posts: 12,529 Karma: 8075744 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Using either edit metadata/single or on the books spreadsheet: set the value to -999999 (easy way to enter: press the minus key then hold down the 9 key until the field stops changing), then click the small decrement button (the down-pointing arror). The value will change to "undefined".

07-27-2012, 10:28 AM	#3
GeckoFriend Guru Posts: 618 Karma: 1164945 Join Date: Jan 2012 Location: SF Bay Area, California, USA Device: iPhone 7+, iPad Mini4, Kindle Voyage	Thanks for that tip chaley.

07-27-2012, 11:26 AM	#4
Rob557 Zealot Posts: 108 Karma: 810 Join Date: Jul 2012 Device: Kobo	Works great. Thank you chaley !

07-31-2012, 04:26 PM	#5
GeekyGal Enthusiast Posts: 40 Karma: 13888 Join Date: Sep 2010 Device: Kindle FireHD, Kindle3G, iPad, MacBook, iRex Illiad (ret)	Perfect. Haunting this board is SO educational. Thank you, Chaley.

Advert

Advert