Thanks for the pioneering work and report.
Bob

On Sat, Dec 17, 2016 at 1:16 AM, <MouthpieceWork@yahoogroups.com> wrote:

> [image: Yahoo! Groups]
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJkdjVzbzIxBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDgxOTY2MTg2>
> Sax and Clarinet Mouthpiece Work Group
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/info;_ylc=X3oDMTJkZDlrdGxkBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BHNlYwNoZHIEc2xrA2hwaARzdGltZQMxNDgxOTY2MTg2>
> 2 Messages
> Digest #2929
> 1a
> Success using LibreOffice Calc with Mojo's spreadsheets
> <#m_3277896989493876433_1a> by jorns4ever
> 1b
> Re: Success using LibreOffice Calc with Mojo's spreadsheets
> <#m_3277896989493876433_1b> by "Keith Bradbury" kwbradbury
>
> Messages
> 1a Success using LibreOffice Calc with Mojo's spreadsheets
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/conversations/topics/12720;_ylc=X3oDMTJybjRodmYxBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BG1zZ0lkAzEyNzIwBHNlYwNkbXNnBHNsawN2bXNnBHN0aW1lAzE0ODE5NjYxODY->
> Fri Dec 16, 2016 8:24 am (PST) . Posted by: jorns4ever
> <jorns4ever@...?subject=Re%3A%20Success%20using%20LibreOffice%20Calc%20with%20Mojo%27s%20spreadsheets>
> I wanted to drop a quick note to say that I've been able to use
> LibreOffice to display and edit Mojo's facing curve spreadsheets. I've had
> success on systems running Windows 10 and Linux Mint 18.
>
>
> Here are some tips and caveats:
> Download LibreOffice from libreoffice.org and install it.
> Install Java JRE from www.java.com/en/download/manual.jsp
> https://www.java.com/en/download/manual.jsp. I had to install the 32-bit
> version of Java because LibreOffice complained that I had a bad version of
> Java installed when I tried to run the non-linear Solver plugin with the
> 64-bit version of Java. I believe that it is possible to install both the
> 32-bit and 64-bit versions of Java at the same time, but I haven't tried
> it.
> When you open one of Mojo's Excel files, the axis labels on the facing
> plots will be in a very small font. This is easy to change. Be sure to load
> the Excel files and then save them in the OpenDocument .ods format so that
> you don't have to tweak things each time you load them. In other words, it
> is easiest to work in the .ods format when using Calc. I haven't tried
> opening the ods files in Excel to see have well it it works with
> OpenDocument formats. It seems like the Windows version of LibreOffice came
> with the non-linear Solver plug-ins installed, but the Linux version did
> not. Refer to the following to install the nonlinear Solver plugin if you
> are running Linux: https://www.libreoffice.org/
> assets/Uploads/EN-Documents/Installingextensions.pd
> https://www.libreoffice.org/assets/Uploads/EN-Documents/
> Installingextensions.pdff, https://ask.libreoffice.org/
> en/question/79526/non-linear-solver-doesnt-show-up-in-calc/
> https://ask.libreoffice.org/en/question/79526/non-linear-
> solver-doesnt-show-up-in-calc/ If the nonlinear Solver isn't enabled by
> default, go to Tools->Extension Manager to enable it. About Solver:
> Solver is needed in some spreadsheets to calculate the curve radius "R"
> and length "M". Unfortunately, the Solver parameters are lost from the xls
> file when it is loaded into LibreOffice Calc. You have to add the target
> cell (labelled Err or Sum err) and the changed cells (labelled R and M) in
> the Solver dialog. It can take quite a while for the non-linear Solver
> function to compute results and stops when "stagnated". Just accept
> the results if the "err" cells are zero and the curve data looks
> reasonable.
>
>
> I hope this helps folks that want to use Mojo's incredible spreadsheets
> but don't have access to Microsoft Office.
>
>
> -Jorns
> Reply to sender
> <jorns4ever@...?subject=Re%3A%20Success%20using%20LibreOffice%20Calc%20with%20Mojo%27s%20spreadsheets> .
> Reply to group
> <MouthpieceWork@yahoogroups.com?subject=Re%3A%20Success%20using%20LibreOffice%20Calc%20with%20Mojo%27s%20spreadsheets> .
> Reply via Web Post
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/conversations/messages/12720;_ylc=X3oDMTJyNmg5azZ0BF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BG1zZ0lkAzEyNzIwBHNlYwNkbXNnBHNsawNycGx5BHN0aW1lAzE0ODE5NjYxODY-?act=reply&messageNum=12720> .
> All Messages (2)
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/conversations/topics/12720;_ylc=X3oDMTM3dnFpY2poBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BG1zZ0lkAzEyNzIwBHNlYwNkbXNnBHNsawN2dHBjBHN0aW1lAzE0ODE5NjYxODYEdHBjSWQDMTI3MjA-> .
> Top ^ <#m_3277896989493876433_toc>
> 1b Re: Success using LibreOffice Calc with Mojo's spreadsheets
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/conversations/topics/12721;_ylc=X3oDMTJyMDRhM2VkBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BG1zZ0lkAzEyNzIxBHNlYwNkbXNnBHNsawN2bXNnBHN0aW1lAzE0ODE5NjYxODY->
> Fri Dec 16, 2016 10:04 am (PST) . Posted by: "Keith Bradbury" kwbradbury
> <kwbradbury@yahoo.com?subject=Re%3A%20Success%20using%20LibreOffice%20Calc%20with%20Mojo%27s%20spreadsheets>
>
> I tried some of the free spreadsheets a few years ago. But I gave up on
> them when their version of the Solver did not work for me. I did not try
> some things to make them work like you did. I just bit the bullet and use
> Office 365 now at $10/month.
>
> Congratulations and thanks for sharing your findings.
>
> PayPal as "Personal, Friend or Family" to: sabradbury79@...
> Checks made out to "Keith W. Bradbury"
> Mail to:
> Mojo Mouthpiece Work LLC
> 2925 Crane St.
> Vineland, NJ 08361
> > On Dec 16, 2016, at 11:24 AM, jorns4ever@... [MouthpieceWork] <
> MouthpieceWork@yahoogroups.com> wrote:
> >
> > I wanted to drop a quick note to say that I've been able to use
> LibreOffice to display and edit Mojo's facing curve spreadsheets. I've had
> success on systems running Windows 10 and Linux Mint 18.
> >
> >
> >
> > Here are some tips and caveats:
> >
> > Download LibreOffice from libreoffice.org and install it.
> > Install Java JRE from www.java.com/en/download/manual.jsp. I had to
> install the 32-bit version of Java because LibreOffice complained that I
> had a bad version of Java installed when I tried to run the non-linear
> Solver plugin with the 64-bit version of Java. I believe that it is
> possible to install both the 32-bit and 64-bit versions of Java at the same
> time, but I haven't tried it.
> > When you open one of Mojo's Excel files, the axis labels on the facing
> plots will be in a very small font. This is easy to change.
> > Be sure to load the Excel files and then save them in the OpenDocument
> .ods format so that you don't have to tweak things each time you load them.
> In other words, it is easiest to work in the .ods format when using Calc. I
> haven't tried opening the ods files in Excel to see have well it it works
> with OpenDocument formats.
> > It seems like the Windows version of LibreOffice came with the
> non-linear Solver plug-ins installed, but the Linux version did not. Refer
> to the following to install the nonlinear Solver plugin if you are running
> Linux: https://www.libreoffice.org/assets/Uploads/EN-Documents/
> Installingextensions.pdf, https://ask.libreoffice.org/
> en/question/79526/non-linear-solver-doesnt-show-up-in-calc/
> > If the nonlinear Solver isn't enabled by default, go to Tools->Extension
> Manager to enable it.
> > About Solver:
> > Solver is needed in some spreadsheets to calculate the curve radius "R"
> and length "M". Unfortunately, the Solver parameters are lost from the xls
> file when it is loaded into LibreOffice Calc. You have to add the target
> cell (labelled Err or Sum err) and the changed cells (labelled R and M) in
> the Solver dialog. It can take quite a while for the non-linear Solver
> function to compute results and stops when "stagnated". Just accept
> the results if the "err" cells are zero and the curve data looks reasonable.
> >
> > I hope this helps folks that want to use Mojo's incredible spreadsheets
> but don't have access to Microsoft Office.
> >
> > -Jorns
> >
> Reply to sender
> <kwbradbury@...?subject=Re%3A%20Success%20using%20LibreOffice%20Calc%20with%20Mojo%27s%20spreadsheets> .
> Reply to group
> <MouthpieceWork@yahoogroups.com?subject=Re%3A%20Success%20using%20LibreOffice%20Calc%20with%20Mojo%27s%20spreadsheets> .
> Reply via Web Post
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/conversations/messages/12721;_ylc=X3oDMTJyNzhodDl1BF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BG1zZ0lkAzEyNzIxBHNlYwNkbXNnBHNsawNycGx5BHN0aW1lAzE0ODE5NjYxODY-?act=reply&messageNum=12721> .
> All Messages (2)
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/conversations/topics/12720;_ylc=X3oDMTM3aDNpOWtxBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BG1zZ0lkAzEyNzIxBHNlYwNkbXNnBHNsawN2dHBjBHN0aW1lAzE0ODE5NjYxODYEdHBjSWQDMTI3MjA-> .
> Top ^ <#m_3277896989493876433_toc>
> Got a Mouthpiece Work question?  Send it to MouthpieceWork@yahoogroups.com
>
> Visit the site at http://groups.yahoo.com/group/MouthpieceWork to see the
> Files, Photos and Bookmarks relating to Mouthpiece Work.
>
> To see and modify your groups, go to http://groups.yahoo.com/mygroups
> Visit Your Group
> <https://groups.yahoo.com/neo/groups/MouthpieceWork/info;_ylc=X3oDMTJlb2RpNW5pBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQ4MTk2NjE4Ng-->
>
>
> [image: Yahoo! Groups]
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJkdjVzbzIxBF9TAzk3MzU5NzE1BGdycElkAzYyODI5MDAEZ3Jwc3BJZAMxNzA1MDMyMTk4BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDgxOTY2MTg2>
> • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
> Unsubscribe
> <MouthpieceWork-unsubscribe@yahoogroups.com?subject=Unsubscribe> • Terms
> of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>