Page 1 of 3 123 LastLast
Results 1 to 15 of 40
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    fraction superscript font (any)

    Sometime within the past month I have stared in amazement at a neat macro that sniffed out awkward fractions and turned them into things of great beauty.

    A search of all forums for "fraction superscript font" (AND, not entire phrase) produces no results.

    If anyone remembers the post or was reading the same site page, please let me know.

    From memory the macro looked for the slash character, and applied superscript format to characters preceding the slash, subscript behind. Better than autotext, this baby handled 34/456 and such like.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    I don't recall it.

    Please don't take this the wrong way, but you're not subscribed to any l-serve peachease forums, are you?

    I only say this because I get their excel and access digest and I do have a hard time remembering what's going on in which place, partly because there are definately other people out there that take an active part in both - Bob Umlas for example has just come across here (in response to Legare's plea?) and partly because new people on the scene looking for help go to more than one place. Also, even when the participants aren't the same, I find it amazing just how often the same subjects come up at the same time.

    Hope that was constructive - it was meant that way!

    Brooke

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    I remember seeing that little beauty but don't recall where. Let me interrogate the cranial storage receptors and I'll get back to you in a light-year or two.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    It was in WOW 6.33!

    Is this it?

    Dim fractionbit As Range
    With Selection
    forwardslash = InStr(.Text, "/")
    Set fractionbit = ActiveDocument.Range _
    (Start:=.Start, End:=.Start + forwardslash - 1)
    fractionbit.Font.Superscript = True
    Set fractionbit = ActiveDocument.Range _
    (Start:=.Start + forwardslash, End:=.End)
    fractionbit.Font.Subscript = True
    End With
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    > l-serve peachease forums

    Never heard of them, until now.

    No. Basically I wait until I see someone recommend a site, then I go take a look.

    Maybe I should pretend that Charles has just recommended that I inspect the MVP site; that's the sort of place I end up, turning things over with a long stick.

    I see Kevin remembers it. Maybe his brain will start working again .....

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    Yes. That is going to be(1) it. WOW - I knew I'd seen it recently.

    By my calculations, and based on a 10-pt font, your solution took less than 1/185,825,249,285,865,734 of a light year.


    Thanks, brain.

    (1) "Going to be" because it needs a wrapper that will make the selection if the provided selection is of length zero. That is, i ought to be able to click anywhere in a fraction string and have the doer do the deed.

  7. #7
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    Light year or two? I reckon he knew all along, had several instances of ie open, waited til he saw you previewing your reply and then went for it. not of course that I've ever done something like that.

    if you're interested, what I was talking about can be found at <A target="_blank" HREF=http://peach.ease.lsoft.com>http://peach.ease.lsoft.com</A> I subscribe to the daily digests as opposed to the real time emails - you try getting an extra 2/300 emails a day! I'm on Excel-L, Excel G and Access-L (though I just don't get the time to wade through the Access stuff.)

    I don't think theres a word list, but there are several more that I'm sure you'd be interested in.

    Brooke

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    I had 1/185,825,249,285,865,734.89.

    I saw a post somewhere about achieving speeds several orders of magnitude faster than the speed of light. I just pasted it into a VBA module, tweeked it a bit and viola!
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #9
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    You should be able to make this even nicer looking (more like the special characters 1/2, 1/4, 3/4) by replacing the slash with the fraction slash (U+2044 from Insert>Symbol, Subset General Punctuation), or the division slash (U+2215 from the subset "Mathematical Operators").

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>Regards, Klaus

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    >not of course that I've ever done something like that.

    Nor wossname, but if he did, he'd have learned it from me. My ambition at age 21 was to learn every programming language on the planet so that I could write any program at all. Two years later I was roped into DESIGNING languages, thereby spelling, so to speak, my own downfall ...

    >waited til he saw you previewing your reply

    Nah. We stole the idea of scanning the forum posting database from code I grabbed from your EXCEL VBA via the ProcClipper, and can almost predict what is going to be posted after any long weekend in the states that involves a car race of 200 miles or more.

    Light-years ahead of you ......


    I did find an interesting list at the site you mentioned.. Watch this space!
    "" WORLDWIDEWORDS is an announce-only list for distributing Michael Quinion's weekly World Wide Words newsletters. They discuss the vagaries of the English language, including word histories, new words, the background to words in the news, and some of the problems of English usage. World Wide Words also attempts to answer your questions on English language and usage. All postings are available on the World Wide Words web site at <www.worldwidewords.org/>""

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    > I had 1/185,825,249,285,865,734.89

    yabbut. You're not allowed to have decimal places in a vulgar fraction.

    I have read articles indicating that very small particles, with awkward names like Pi-Bosons, or Mu-mesons, Leptons, at any rate, can attain faster-than-light speeds for short periods, I think by "borrowing" elements of certainty from slower-than-light particles. I'm not absolutely certain of this.

    A bit like the outermost part of a steam-locomotive's wheel flange travelling backwards during each revolution.

    Myself, I think the leptons should go back to where they came from.

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    > You should be able to make this even nicer looking

    Klaus, thanks for this. I am re-writing the function as a developers edition, with parameters nominating the incoming "slash" character, a substitution "slash" character (for which codes many thanks) and the set of characters from which the numerator and denominator strings can be composed.

    For users like Kevin, if there are any more out there, the numerator and denominator strings set would include "0123456789" and "," and ".".

    For those of greater base, such as 16, the character set could allow "0123456789ABCDEF".

    I once used a negative-4 base number system. Not sure how to handle that.

    Does the leading "-" or "+" sign get superscripted?


    Optional parameters (thanks Geoff or Gary, I forget which) would provide a user interface that would just RUN.

    In any event, the selection mechanism will determine if more characters ought to be sought, or whether the supplied selection is sufficient.

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    > tweeked it a bit and viola!

    So!

    It really was a fiddle?

  14. #14
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: fraction superscript font (any)

    Did someone say <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=scut&Number=61685>leptons</A>?
    -John ... I float in liquid gardens
    UTC -7DS

  15. #15
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fraction superscript font (any)

    Viola? So you play an instrument as well as you other talents?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •