[3.5.3.2/Calc] Display drop-down list in all cells in column?

users
#1

Hello

I'm going through my bank statements to check how I spend money.

I'd like to use one of the columns to define the type of spending through a
drop-down list (eg. Food, Transporation, etc.)

"Data > Validity > Allow = List " does display a drop-down list, but I
couldn't find how to tell LO to display this list in all the cells in the
column:

http://bagofiles.free.fr/libreoffice.calc.dropdownlist.jpg
http://bagofiles.free.fr/libreoffice.calc.dropdownlist.jpg

How can I do this?

Thank you.

#2

Just select the range of cells to which you wish this restriction to apply - even the entire column - before you use Data | Validity... | Criteria | Allow | List.

I trust this helps.

Brian Barker

#3

Thanks for the tip. Didn't think of this.

In the same vein, after I created a list of possible items for the drop-down
box to be displayed in that column, is it possible to select some cells
through CTRL, and apply the same item for all of them?

For instance, I'd like to select all the cells for food shopping,
right-click on the selected section and choose "FOOD" from the drop-down
list.

I assume it's not possible to select the rows themselves, but selecting the
cells individually is good enough.

#4

I don't thinks that's possible. The easiest thing is probably to
select one cell, select FOOD, hit Ctrl+c, select all the other cells
in which you want the word FOOD (using Ctrl or Shift), hit Ctrl+v. Not
too much extra work, I think.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#5

Thanks for the tip. Didn't think of this.

In the same vein, after I created a list of possible items for the drop-down
box to be displayed in that column, is it possible to select some cells
through CTRL, and apply the same item for all of them?

For instance, I'd like to select all the cells for food shopping,
right-click on the selected section and choose "FOOD" from the drop-down
list.

I assume it's not possible to select the rows themselves, but selecting the
cells individually is good enough.

I don't thinks that's possible. The easiest thing is probably to
select one cell, select FOOD, hit Ctrl+c, select all the other cells
in which you want the word FOOD (using Ctrl or Shift), hit Ctrl+v. Not
too much extra work, I think.

By the way, if you entered FOOD in one cell, entering a single ”F” in
another cell will probably suggest ”FOOD” anyway, so you probably
won't need to enter more than a single ”F” into those other cells
anyway. There are always more than one way to do things. In most
cases, anyway…

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#6

Hi :slight_smile:
How about using GnuCash?
http://www.gnucash.org/

It is a bit like Sage or QuickBooks or something.  Although primarily for personal finances it is also used in small companies finance department.
Regards from
Tom :slight_smile:

#7

omega
  The
Omega sector
America's Last
Line of
Defense

*I put Quicken inside of wine and it has the graphs to show me where money goes to . . simpler and faster . .

#8

Johnny Rosenberg wrote

The easiest thing is probably to select one cell, select FOOD, hit Ctrl+c,
select all the other cells in which you want the word FOOD (using Ctrl or
Shift), hit Ctrl+v.

Thanks much for the tip. It's fast enough.

Tom wrote

How about using GnuCash?

Thanks for the idea. I know about GnuCash, but it's a bit too feature-rich
just to compute how much money I spend on what, and besides my bank no
longer provides data in CSV but rather as PDF :-/

#9

Gilles wrote:

Johnny Rosenberg wrote

The easiest thing is probably to select one cell, select FOOD, hit Ctrl+c,
select all the other cells in which you want the word FOOD (using Ctrl or
Shift), hit Ctrl+v.

Thanks much for the tip. It's fast enough.

Tom wrote

How about using GnuCash?

Thanks for the idea. I know about GnuCash, but it's a bit too feature-rich
just to compute how much money I spend on what, and besides my bank no
longer provides data in CSV but rather as PDF :-/

      A database will also do what you want to do. Queries will provide you with the information you need. I use such a database. One query tells me the balance of all my financial accounts (9 of them). Two queries break down my expenses into budget categories; one is for the present month, and the second is for the previous month. This way I can compare expenses for the two month by category. Both queries have a column for the budgeted amounts for each category as well.

--Dan

#10

Hi :slight_smile:
One problem with using a spreadsheet or database is that it is difficult to set-up an "audit trail" and even if you do then it's unlikely to be trusted by anyone else that might need to see your accounts.  That is the advantage with using proper software developed for the purpose or for using pen&ink (ie so you can't rub-out entries without it being noticeable) to keep proper records.

If you don't have an accountant or auditor or present the accounts to anyone else then of course a database might be a LOT better than a spreadsheet, if you are at all familiar with database programs. 
Regards from
Tom :slight_smile:

#11

And why isn't the bank statements in PDF files the "audit trail"? The numbers in those files can be compared with the numbers in the tables. The query structure will show whether the query will give the correct results or not. If the input numbers are correct, and the operations performed on those numbers are correct; it seems logical to assume that the output would also be correct. When in doubt, the query structure can also be checked by feeding it data with known calculations. If the query output on this data matches the known calculations, I would think the query can be trusted to give the correct result on other data as long as that data can be verified first.

--Dan

Tom Davies wrote:

#12

HI :slight_smile:
Oh wow!!  I am more familiar with Access than Base and hadn't even considered that Base might be able to read data from Pdfs!  Base really is an extremely powerful tool, or at least has the potential, and aims to be even if it's not as fully functional as it aims to be. 
Regards from
Tom :slight_smile:

#13

please do not send any mail to us sir

INDISCHKA Boekhorststraat 14,

#14

Hi :slight_smile:
Please unsubscribe yourself using these instructions
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Regards from
Tom :slight_smile: