MobileRead Forums - View Single Post - Customize the positive and negative number format on an integer column

Sandwich · 10-12-2020, 05:40 AM

I posted this as a Calibre feature request here, but I'm beginning to wonder if it's possible to do already.

Basically, I'd like to have a column for in-universe dating systems. Eg. Star Wars uses "[year] BBY" or "[year] ABY" for dating events, similar to how we have BC and AD (or BCE and ACE if you prefer) on our years.

I think the solution would have to involve 3 custom columns:

Year (integer) - this would store the actual in-universe year wherein a book takes place, as either a negative or positive integer.
Year Format (preset fixed values) - Different universes have different ways of labeling their years. I already covered Star Wars above; Dune uses "BG" / "AG". This column would be where we select which date format we use for each book.
Chronological date (formated year, built from other columns) - I guess this would just take the integer from the Year column, combine it with the selected Year Format somehow, and show the result.

I may be overthinking this, I admit, but can anyone point me in the right direction here?

10-12-2020, 05:40 AM	#1
Sandwich Junior Member Posts: 5 Karma: 10 Join Date: Mar 2012 Device: Android	Customize the positive and negative number format on an integer column I posted this as a Calibre feature request here, but I'm beginning to wonder if it's possible to do already. Basically, I'd like to have a column for in-universe dating systems. Eg. Star Wars uses "[year] BBY" or "[year] ABY" for dating events, similar to how we have BC and AD (or BCE and ACE if you prefer) on our years. I think the solution would have to involve 3 custom columns: Year (integer) - this would store the actual in-universe year wherein a book takes place, as either a negative or positive integer. Year Format (preset fixed values) - Different universes have different ways of labeling their years. I already covered Star Wars above; Dune uses "BG" / "AG". This column would be where we select which date format we use for each book. Chronological date (formated year, built from other columns) - I guess this would just take the integer from the Year column, combine it with the selected Year Format somehow, and show the result. I may be overthinking this, I admit, but can anyone point me in the right direction here?