SpokeTools V1.5

Discussion in 'Cycling Archive' started by Tosspot, Nov 25, 2015.

  1. Tosspot

    Tosspot Guest

    Tosspot, Nov 25, 2015
    #1
    1. Advertisements

  2. Tosspot

    Jim Price Guest

    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.
     
    Jim Price, Nov 25, 2015
    #2
    1. Advertisements

  3. Tosspot

    Ace Guest

    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.
     
    Ace, Nov 25, 2015
    #3
  4. Tosspot

    Tosspot Guest

    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.
     
    Tosspot, Nov 25, 2015
    #4
  5. Tosspot

    Tosspot Guest

    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.
     
    Tosspot, Nov 25, 2015
    #5
  6. Tosspot

    Ace Guest

    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>
     
    Ace, Nov 25, 2015
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
There are no similar threads yet.
Loading...