SpokeTools V1.5

So, I think I found all the errant local links. Tarted up a bit,
changed a few things so even less to do.

https://www.dropbox.com/s/x0diazvtgd5pxac/SpokeTools V1.5.xlsx?dl=0

Let me know if you see any problems.

 

On 25/11/15 11:08, Tosspot wrote:
> So, I think I found all the errant local links. Tarted up a bit,
> changed a few things so even less to do.
>
> https://www.dropbox.com/s/x0diazvtgd5pxac/SpokeTools V1.5.xlsx?dl=0
>
> Let me know if you see any problems.

The "Select a rim" and "select a hub" drop down menus appear to be
missing in LibreOffice Calc - there isn't even any code visible in the
cell. I don't have MS Office so I can't even see the way it's done with
that. I presume it is supposed to allow you to select rim and hub data
from the rim and hub sheets, or am I misinterpreting the instructions?

--
â•”â•â•¦â•â•¦â•â•â•â•â•â•¦â•â•â•â•—
â•‘ â•‘ â•‘ â•‘ â•‘
â•”â•â• â•‘ â•‘ â•‘ â•‘ â•‘ â•”â•â•
â•šâ•â•â•â•©â•â•©â•â•©â•â•©â•â•©â•â• -- JimP.

 

On Wed, 25 Nov 2015 15:05:47 +0000, Jim Price <>
wrote:

>On 25/11/15 11:08, Tosspot wrote:
>> So, I think I found all the errant local links. Tarted up a bit,
>> changed a few things so even less to do.
>>
>> https://www.dropbox.com/s/x0diazvtgd5pxac/SpokeTools V1.5.xlsx?dl=0
>>
>> Let me know if you see any problems.
>
>The "Select a rim" and "select a hub" drop down menus appear to be
>missing in LibreOffice Calc - there isn't even any code visible in the
>cell. I don't have MS Office so I can't even see the way it's done with
>that. I presume it is supposed to allow you to select rim and hub data
>from the rim and hub sheets, or am I misinterpreting the instructions?

That's what happens in MS Excel. I tried with OpenOffice and that
behaves like you describe as well.

 

On 25/11/15 16:05, Jim Price wrote:
> On 25/11/15 11:08, Tosspot wrote:
>> So, I think I found all the errant local links. Tarted up a bit,
>> changed a few things so even less to do.
>>
>> https://www.dropbox.com/s/x0diazvtgd5pxac/SpokeTools V1.5.xlsx?dl=0
>>
>> Let me know if you see any problems.
>
> The "Select a rim" and "select a hub" drop down menus appear to be
> missing in LibreOffice Calc - there isn't even any code visible in the
> cell. I don't have MS Office so I can't even see the way it's done with
> that. I presume it is supposed to allow you to select rim and hub data
> from the rim and hub sheets, or am I misinterpreting the instructions?

Correct. They used to work, I'll fire up LO and have a butchers.

 

On 25/11/15 16:48, Ace wrote:
> On Wed, 25 Nov 2015 15:05:47 +0000, Jim Price <>
> wrote:
>
>> On 25/11/15 11:08, Tosspot wrote:
>>> So, I think I found all the errant local links. Tarted up a bit,
>>> changed a few things so even less to do.
>>>
>>> https://www.dropbox.com/s/x0diazvtgd5pxac/SpokeTools V1.5.xlsx?dl=0
>>>
>>> Let me know if you see any problems.
>>
>> The "Select a rim" and "select a hub" drop down menus appear to be
>> missing in LibreOffice Calc - there isn't even any code visible in the
>> cell. I don't have MS Office so I can't even see the way it's done with
>> that. I presume it is supposed to allow you to select rim and hub data
>>from the rim and hub sheets, or am I misinterpreting the instructions?
>
> That's what happens in MS Excel. I tried with OpenOffice and that
> behaves like you describe as well.

It seems the validation is broken, a more serious problem is the kgf
formula is broken in LO. I'll have a look tomorrow and try and sort it.
I might try exporting it from MS Excel.

 

On Wed, 25 Nov 2015 19:42:38 +0100, Tosspot <>
wrote:

>On 25/11/15 16:48, Ace wrote:
>> On Wed, 25 Nov 2015 15:05:47 +0000, Jim Price <>
>> wrote:
>>
>>> On 25/11/15 11:08, Tosspot wrote:
>>>> So, I think I found all the errant local links. Tarted up a bit,
>>>> changed a few things so even less to do.
>>>>
>>>> https://www.dropbox.com/s/x0diazvtgd5pxac/SpokeTools V1.5.xlsx?dl=0
>>>>
>>>> Let me know if you see any problems.
>>>
>>> The "Select a rim" and "select a hub" drop down menus appear to be
>>> missing in LibreOffice Calc - there isn't even any code visible in the
>>> cell. I don't have MS Office so I can't even see the way it's done with
>>> that. I presume it is supposed to allow you to select rim and hub data
>>>from the rim and hub sheets, or am I misinterpreting the instructions?
>>
>> That's what happens in MS Excel. I tried with OpenOffice and that
>> behaves like you describe as well.
>
>It seems the validation is broken, a more serious problem is the kgf
>formula is broken in LO. I'll have a look tomorrow and try and sort it.
> I might try exporting it from MS Excel.

Or just tell people not to be such cheapskates and get Excel
<DH,RFC>