The Best Solution to the Shopping List Ever

I added a couple of checkboxes to the Configuration window.

One took the place of a text field for saying "yes" to automatic PDF generation, and the other lets ShoppingList create your list title from the filename of the database you have open.

So, you can have an automatically generated title at the top of the list, or you can specify what you want to show up there.  Your choices are saved to the .ini file.

I realized I should put a button in the application that would open the database spreadsheet for editing using the system default application for spreadsheets.  So I did.

The spreadsheet must be closed after editing before pressing any other buttons, otherwise you get a popup reminding you to do so.

Word wrapping is much better now.

The Notes section previously did alright with wrapping, but in the actual list itself, not so much. So now, items in the list that are longer than the paper is wide are wrapped and indented on the second and subsequent lines.

v1.7 is available at Github: https://github.com/casspop/shoppingList

I just created my first ever Windows setup.exe using Inno Setup.  My limited testing here indicates it works as expected, both for installing and uninstalling.

I was  only able to get it to work by only installing as the local user, not 'For Everyone'.  I think it's a permissions problem, but I have neither the inclination to worry about it, nor the interest to chase it down.  I don't think this app deserves 'For Everyone' status, so this isn't a problem from my perspective.

Other than that, it seems to work great!  ShoppingList is available on Github here.

If you get to the store and reach into your pocket for the list you printed at the house, and you suddenly realize you left it sitting on the kitchen counter, what do you do?

As an emergency backup strategy, I thought it might be good to figure out how to create a receipt-sized .pdf of the list and save it into one of the cloud storage services that everyone has on their phones and laptops/desktops/whatever.

The irony is not lost on me, but this would not be intended (at least not for me and my wife) to be the primary strategy for the shopping list.

Last night I worked through learning about the 'reportlab' module, and I was able to get a .pdf with the size and font spacing that was close enough to the actual printed receipt to satisfy me.

Next I'll move my test code over to the main app and see if I can get the whole thing to work.

7/15 UPDATE: It works, and now v1.6 is on Github.  I'm really excited about how this has come together.

Actually, now if you want to use the .pdf as a list on your phone, you can just leave the printer IP set at it's default 192.168.254.254 and SL will print your list to the .pdf file and save it to the folder where your .xlsx file is located.