Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 07-27-2012, 03:01 AM   #1
Rob557
Enthusiast
Rob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-books
 
Posts: 45
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.
Rob557 is offline   Reply With Quote
Old 07-27-2012, 08:07 AM   #2
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,245
Karma: 821512
Join Date: Jan 2010
Location: France
Device: Many android devices
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".
chaley is offline   Reply With Quote
 
Enthusiast
Old 07-27-2012, 09:28 AM   #3
GeckoFriend
Fanatic
GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.GeckoFriend ought to be getting tired of karma fortunes by now.
 
GeckoFriend's Avatar
 
Posts: 545
Karma: 1024603
Join Date: Jan 2012
Location: SF Bay Area, California
Device: Sony PRS T-1, Kindle Fire
Thanks for that tip chaley.
GeckoFriend is offline   Reply With Quote
Old 07-27-2012, 10:26 AM   #4
Rob557
Enthusiast
Rob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-books
 
Posts: 45
Karma: 810
Join Date: Jul 2012
Device: Kobo
Works great. Thank you chaley !
Rob557 is offline   Reply With Quote
Old 07-31-2012, 03:26 PM   #5
GeekyGal
Enthusiast
GeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavensGeekyGal is a rising star in the heavens
 
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.
GeekyGal is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
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


All times are GMT -4. The time now is 05:01 AM.


MobileRead.com is a privately owned, operated and funded community.