Membership questions? Log in issues? Email info@brewersassociation.org

Author Topic: Bru'n Water Issue  (Read 1891 times)

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
Bru'n Water Issue
« on: June 09, 2015, 03:01:39 pm »
I received a supporter version of Bru'n Water and noticed that none of the pull down cells work, even with macros are enabled. Examples include;
-Program Volume Setting
-Grain Types
-Desired Water Profile, etc.

Any ideas? I emailed Martin, but figured this may get a faster response. Cheers!

Offline mchrispen

  • Brewmaster
  • *****
  • Posts: 713
    • Accidentalis Brewing Blog
Re: Bru'n Water Issue
« Reply #1 on: June 09, 2015, 03:04:19 pm »
Windows or Mac? Are you using Excel? I use Excel on both platforms and it works fine. The Mac has a few issues with the long drop downs and scrolling - but it works.

You may need to enable editing in the document and save as before some of the features work.
Matt Chrispen
Sometime Austin Zealot
Blogging from the garage @ accidentalis.com
>> Bru'n Water Spreadsheet Walkthroughs<<
>> Bru'n Water Subscriber Version 5.3 Spreadsheet Walkthrough <<

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2009
  • A twerp from Antwerp
Re: Bru'n Water Issue
« Reply #2 on: June 09, 2015, 03:10:09 pm »
I bet you have a mac. It's a known issue caused by Microsoft's port of Excel to the mac. Don't click but keep pushing the button, then you can scroll up and down.
Frank P.

Staggering on the shoulders of giant dwarfs.

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
Re: Bru'n Water Issue
« Reply #3 on: June 09, 2015, 03:23:10 pm »
Yup, Mac and Excel. The clicking trick did the trick, thanks!

One other issue, while saving as .xlsx, I get a message that warns visual basic macros will be disabled. I'm curious if there are some big visuals I'm missing that I don't know about. Anyone care to take a screen shot?
« Last Edit: June 09, 2015, 03:38:21 pm by flbrewer »

Offline mchrispen

  • Brewmaster
  • *****
  • Posts: 713
    • Accidentalis Brewing Blog
Re: Bru'n Water Issue
« Reply #4 on: June 09, 2015, 05:08:12 pm »
not really. The interface looks slightly different but the information presented is the same. The screen shots on my website are all from Windows if you want to compare.
Matt Chrispen
Sometime Austin Zealot
Blogging from the garage @ accidentalis.com
>> Bru'n Water Spreadsheet Walkthroughs<<
>> Bru'n Water Subscriber Version 5.3 Spreadsheet Walkthrough <<

Offline mabrungard

  • I spend way too much time on the AHA forum
  • ********
  • Posts: 2903
  • Water matters!
    • Bru'n Water
Re: Bru'n Water Issue
« Reply #5 on: June 10, 2015, 09:40:20 pm »
Sorry about your issue with Excel on Mac. It really sucks that Microsoft treats Apple products that way. But, it sounds like you did solve it. I understand that LibreOffice or OpenOffice does work better on the Mac.

The only macros have to do with the drop-down boxes and the scroll bars. If they still work after you save the file with them disabled and they still work, you are good. You shouldn't miss anything else.  A number of Mac users say they have saved it that way and everything still works, so you should be OK.
Martin B
Carmel, IN

BJCP National
Foam Blowers of Indiana (FBI)

Brewing Water Information at:
https://www.brunwater.com/

Like Bru'n Water on Facebook
https://www.facebook.com/Brun-Water-464551136933908/?ref=bookmarks

Offline Stevie

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 6858
Re: Bru'n Water Issue
« Reply #6 on: June 10, 2015, 11:09:31 pm »
I can attest to LibreOffice. Works well enough for my needs. I had issues with OpenOffice a few years back and have not tired it since.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2009
  • A twerp from Antwerp
Re: Bru'n Water Issue
« Reply #7 on: June 11, 2015, 08:15:17 am »
I can attest to LibreOffice. Works well enough for my needs. I had issues with OpenOffice a few years back and have not tired it since.

Macros seem to work in OpenOffice 4.
Frank P.

Staggering on the shoulders of giant dwarfs.