How Do You Format Fractions in Publisher Tables

[Ldina]

I need some help creating fractions in Tables, preferably using some sort of number style or text style, rather than manually formatting each fraction one-by-one, which is very time consuming. I create a lot of tables for Engineering companies, which include combinations of numbers and fractions. Many columns of data will have integers followed by fractions. Some customers want a hyphen between integer and fraction, and other customers do not want any hyphens, so I need to be able to configure both. For example, the same column may have numbers (with or without hyphen), such as:

1-½ 

35-7/64

18-¼

165-17/32

I need small fractions, not that do not use full sized characters. Some fonts have common fractions pre-built, (e.g., ¼, ½, ¾, etc) but I am often required to create fractions using 16ths, 32nds, 64ths, etc (e.g., 17/64, 3/32, etc). Sometimes the integer before the fraction will have a single digit, two digits, three digits, etc. And sometimes, an integer suffices without any following fraction.

I can manually change a fraction in the Character Panel, but that takes forever with a lot of data. I've been able to create text styles that render the entire table cell as a fraction, but I need an Integer followed by a Fraction. I haven't been able to figure out how to do this in Publisher Tables or even with Character/Paragraph Styles. Can anyone help with this?

Thank you.

[v_kyr]

That's IMO usually something that would be part of common equations editing facilities for technical writings, which APub yet doesn't have build-in. Those are things which TeX/LaTeX and FrameMaker do support in a very comfortable manner. - You may have to look around and use some third party tool for equations writing here, though you ideally want something which keeps text/characters editable then and so not inserted as images/bitmaps here then.

[walt.farrell]

Depending on the OpenType capabilities supported by your chosen font, you may be able to simply select the fraction text and set the fraction option in the Character panel, under Typography. This is with Arial, for example:

 

[v_kyr]

If dealing with just specific fonts here as Walt suggested, there are some fonts which do offer more fractions than usual. - See therefor also ...

• Fractions (fonts.com)
• Fractions (Google fonts)
• Ronaldson W00 Fractions Fonts
• Sans Fraction Plain
• ... etc.

[Ldina]

Thanks v-kyr and Walt. 

Arial doesn't work that way on my MacBook Pro, and most fractions remain full sized, but Myriad Pro works fine. Maybe it's the version of Arial I have loaded. I know I can apply the fraction character style with a font that supports fractions, one by one, just to the fraction component, but that's what I am trying to avoid. It's quite tiring and time consuming if you have hundreds of such entries, which most engineering manuals and brochures do. 

Here's my present workaround, which is a bit of a kludge, but it works for now.

1. I created two narrow table columns, side by side, and set the vertical line divider between them to None, so it looks visually like a single column.

2. I set the left-hand column to be Right Aligned and I'm using that for Integers. I set the Paragraph Style to Integers, which I created expressly for that purpose, to preserve full sized numbers.

3. I set the column to the right of the Integer column to be Left Aligned and I'm using that for my fraction components, when needed. I set this Paragraph Style to Fractions, which I created to give me small sized fraction format.

This allows me to enter data fairly quickly and it looks good when spacing is adjusted properly. I can't center align the "integer-fraction" combination as if it were one entry, but I guess I'll have to live with that. The only other options I have found, so far, is to select each fraction component, and manually apply the fraction from Character Panel. 

If anybody knows of a better way, I'd love to hear it.

Thanks.

[Ldina]

6 minutes ago, v_kyr said:

If dealing with just specific fonts here as Walt suggested, there are some fonts which do offer more fractions than usual. - See therefor also ...

• Fractions (fonts.com)
• Fractions (Google fonts)
• Ronaldson W00 Fractions Fonts
• Sans Fraction Plain
• ... etc.

Thank you...I will definitely check that out. 😀

[Alfred]

2 hours ago, Ldina said:

Some customers want a hyphen between integer and fraction, and other customers do not want any hyphens, so I need to be able to configure both.

Please try to dissuade those who belong to the first group! I’m sure I’m not the only one who thinks that

18-¼

looks like a subtraction (=17¾).

2 hours ago, Ldina said:

I need small fractions, not that do not use full sized characters.

I suspect there are too many occurrences of the word ‘not’ in there. Anyway, if you’re looking for stacking or ‘nut’ fractions then you need to find a font that includes support for them.

[walt.farrell]

You could use Find and Replace, perhaps, with a regular expressiion search for something like \d+?/\d+? and then apply a character text style with the Fraction option set.

[kenmcd]

1 hour ago, Ldina said:

If anybody knows of a better way, I'd love to hear it.

IIRC Minion Pro has a way of handling fractions which enables the user to just type, but it requires a particular sequence of characters. IIRC the OpenType fractions feature does not just use the usual ligatures substitutions, but it also uses contextual alternates (so the fraction is triggered by the following space or punctuation). Never did find any documentation of how it is supposed to work. A few other Adobe fonts work the same way.

So you may be able type a 1, then a ZWS or hairspace, and then 3/16, and then space (and the text style has Fractions On by default). Then you can align that text as you wish.

On my phone at the moment so I cannot look inside the font or test (can look later today).

[Ldina]

1 hour ago, walt.farrell said:

You could use Find and Replace, perhaps, with a regular expressiion search for something like \d+?/\d+? and then apply a character text style with the Fraction option set.

Thanks Walt, but I'm not conversant with search and replace expressions or how to use them, or even where to learn how. I pasted your expression into Publisher's F/R to try it and it sort of worked. If the denominator of the fraction had more than one character, it only changed the first digit. The 2nd denominator digit remained full sized. So, using 25-1/64 as an example, the 25 remained full size, 1/6 was converted to small fraction, but the 4 following the 6 in 64 remained full sized. 

Some things in Publisher are very nice, but I'm finding it painful to learn coming from InDesign. Some features are completely opaque and require hours of searching, trial and error and experimentation, and sometimes it still isn't clear. Unfortunately, Affinity's Help files are often inadequate and not very helpful. They need much more detail and lots of good, clear examples, IMO.

[lacerto]

Obsolete.

[Ldina]

@lacerto

Thanks again. That worked with my installed versions of Myriad Pro and Minion Pro, so I have serif and sans fonts with many styles and weights I can use. It took me a while to get everything right, since I'm new to so many things in Publisher, but I finally got it working. And yes, it will be quite a time saver. Using the Opt-Spacebar shortcut for a non-breaking space between integer and fraction makes it fast and easy. My versions of Helvetica didn't seem to work that well, so perhaps I will check out Helvetica Now. I've attached a screenshot from Font Book showing the Helvetica fonts currently installed on my system. Some are rather old, but I keep them for legacy documents to be sure I am not missing any fonts when I open them.

I can see I need to learn more about RegEx and how to write search functions. 

Lou

[lacerto]

Obsolete.