![]() |
#1 |
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. |
![]() |
![]() |
![]() |
#2 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,863
Karma: 7036057
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".
|
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Guru
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 614
Karma: 1164945
Join Date: Jan 2012
Location: SF Bay Area, California, USA
Device: iPhone 7+, iPad Mini4, Kindle Voyage
|
Thanks for that tip chaley.
![]() |
![]() |
![]() |
![]() |
#4 |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 108
Karma: 810
Join Date: Jul 2012
Device: Kobo
|
Works great. Thank you chaley !
|
![]() |
![]() |
![]() |
#5 |
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 | |
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Blank field in "Browse for folder" | Roel | Library Management | 7 | 04-29-2012 10:13 AM |
Blank screen after factory reset | IxiaAurea | Kobo Reader | 5 | 09-28-2011 07:44 AM |
(Development) What are these apparently-undefined python operators? | offby1 | Calibre | 5 | 06-26-2010 11:57 AM |
PRS-600 Sony library - Error undefined | omk3 | Sony Reader | 13 | 01-22-2010 10:52 AM |
Cybook Numeric Entry Dialog | delphidb96 | OpenInkpot | 8 | 08-07-2008 09:54 AM |