Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?
HI :) 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 :) --- On Wed, 18/7/12, Dan wrote: From: Dan Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column? To: users@global.libreoffice.org Date: Wednesday, 18 July, 2012, 13:57 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: > Hi :) > 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 :) > > > --- On Wed, 18/7/12, Dan wrote: > > From: Dan > Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in > all cells in column? > To: users@global.libreoffice.org > Date: Wednesday, 18 July, 2012, 12:38 > > 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 >> -- >> View this message in context: >> http://nabble.documentfoundation.org/3-5-3-2-Calc-Display-drop-down-list-in-all-cells-in-column-tp3996001p3996193.html >> Sent from the Users mailing list archive at Nabble.com. >> > > > > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?
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: Hi :) 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 :) --- On Wed, 18/7/12, Dan wrote: From: Dan Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column? To: users@global.libreoffice.org Date: Wednesday, 18 July, 2012, 12:38 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 -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Display-drop-down-list-in-all-cells-in-column-tp3996001p3996193.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?
Hi :) 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 :) --- On Wed, 18/7/12, Dan wrote: From: Dan Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column? To: users@global.libreoffice.org Date: Wednesday, 18 July, 2012, 12:38 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 > -- > View this message in context: > http://nabble.documentfoundation.org/3-5-3-2-Calc-Display-drop-down-list-in-all-cells-in-column-tp3996001p3996193.html > Sent from the Users mailing list archive at Nabble.com. > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?
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 -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Display-drop-down-list-in-all-cells-in-column-tp3996001p3996193.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?
2012/7/17 Johnny Rosenberg : > 2012/7/17 Gilles : >> 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 ジョニー・ローゼンバーグ > > > Kind regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?
2012/7/17 Gilles : > 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. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
