[Dropped] Boolean field purpose

Discuss the spreadsheet application
Locked
User avatar
White Phoenix
Posts: 312
Joined: Tue Jan 01, 2008 7:10 am

[Dropped] Boolean field purpose

Post by White Phoenix »

What is the point of a Boolean field, if you still need to use a conditional statement that will function in any numeric field? Seems to me that If I have something that either is or isn’t, I should be able to put a 1 if it is for the field to return TRUE or 0 if it isn’t to return FALSE?
As it is, I may as well just do a two step process and use two columns instead of just one. Either that, or just type Yes or No in the one column.
Last edited by MrProgrammer on Sat Dec 20, 2025 12:36 am, edited 1 time in total.
Reason: Dropped: No attachment provided when requested
Apache OpenOffice 4.1.15 on Linux Mint 21.3 with Cinnamon.
User avatar
robleyd
Moderator
Posts: 5505
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Boolean Field Purpose

Post by robleyd »

If you care to elaborate on your actual problem I'm sure someone will be able to help. Perhaps provide a sample spreadsheet with details of what you are trying to accomplish.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
User avatar
RoryOF
Moderator
Posts: 35210
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Boolean Field Purpose

Post by RoryOF »

1 or 0 works excellently if your field is guaranteed to be one bit wide, but if it is an integer, as many calculated results are, what if it is something else - 1234, for example? And "yes/no": what about "maybe", or (my favourite) "none of the above"?

Just go with the convention, and devote the saved energy to worrying about other aspects of your programs.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Locked