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

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
    • View Profile
Bru'n Water Issue
« on: June 09, 2015, 09: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: 647
    • View Profile
    • Accidentalis Brewing Blog
Re: Bru'n Water Issue
« Reply #1 on: June 09, 2015, 09: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.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2008
  • A twerp from Antwerp
    • View Profile
Re: Bru'n Water Issue
« Reply #2 on: June 09, 2015, 09: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
    • View Profile
Re: Bru'n Water Issue
« Reply #3 on: June 09, 2015, 09: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, 09:38:21 PM by flbrewer »

Offline mchrispen

  • Brewmaster
  • *****
  • Posts: 647
    • View Profile
    • Accidentalis Brewing Blog
Re: Bru'n Water Issue
« Reply #4 on: June 09, 2015, 11: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.

Offline mabrungard

  • Brewmaster General
  • *******
  • Posts: 2385
  • Water matters!
    • View Profile
    • Bru'n Water
Re: Bru'n Water Issue
« Reply #5 on: June 11, 2015, 03:40:20 AM »
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://sites.google.com/site/brunwater/

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

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Re: Bru'n Water Issue
« Reply #6 on: June 11, 2015, 05:09:31 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.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2008
  • A twerp from Antwerp
    • View Profile
Re: Bru'n Water Issue
« Reply #7 on: June 11, 2015, 02:15:17 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.

Macros seem to work in OpenOffice 4.
Frank P.

Staggering on the shoulders of giant dwarfs.