OLE Object (e.g. formula)

Recommended Posts

Hello!

Can I insert an OLE object in the Publisher? For example, I would like to use the formula editor (Writer or Word) to write formulas.

Which is the easiest way to insert and edit formulas?

Regards

Share on other sites

Hi maxmax

On 6/22/2019 at 2:18 PM, maxmax said:

Can I insert an OLE ﻿object﻿﻿ in the Publisher?

OLE is a proprietary technology developed by Microsoft, so unfortunately not.

However Affinity Publisher does have a Resource Manager, meaning you can place or embed multiple files into your document, such as RTF, Docx, Image files etc.

On 6/22/2019 at 2:18 PM, maxmax said:

I would like to use the formula editor (Writer﻿ or Word) to write formulas.

Which is the easiest way to insert and edit formulas?

Publisher doesn't current support formulas, or embedding spreadsheet data. We can currently copy and paste from spreadsheets to tables in Affinity, but we're working on improving this for future builds.

I hope this helps.

Ok.

Thank you

Share on other sites

This post might be a bit late to the race – I only found this thread by accident – but you can create equations using Publisher. However, you do need to be careful and patient.
I’ve attached an example where I’ve used a table and the Cambria Math font to create something reasonably complex.
Some planning and tweaking is necessary but it’s possible; I just wouldn’t want to do it for lots of equations.
My recommendation would be to create the equation in something else – e.g. LaTeX, or whatever – and export as SVG to import (linked may be preferable) into Publisher.

complex-equation.afpub

Share on other sites

That must have taken you some creative planning and execution! Kudos!

Share on other sites

Thanks. I just wanted to see if it was possible. It is, but it's just not very easy.

Share on other sites

I’ve just done a quick test with MiKTeX (TexWorks) on Windows and I can create the equations, export them as PDFs, import the PDFs into Publisher – as Linked files – clip the PDF down to size (if necessary) and update them quite easily using the Resource Manager.
It’s not an ideal solution but it works.
Try this LaTeX:

\documentclass{article}
\usepackage{amsmath}
\usepackage{geometry}
\geometry{
papersize={210mm,60mm},
}
\pagestyle{empty}
\begin{document}
\begin{align*}
f(x) &= x^2\\
g(x) &= \frac{1}{x}\\
F(x) &= \int^a_b \frac{1}{6}x^4
\end{align*}
\end{document} 

To get the attached example.

Share on other sites

Thanks, @GarryP. That looks like an interesting approach. Of course, with importing PDF files we'll have the known issues with needing to have the fonts installed, and with other changes being made by Publisher, given that the PDFs are not "pass-through" but editable. SVG might be preferrable, if MiKTeX can handle that.

I'm not sure what happened there, but the integral operation on the last line doesn't seem to have worked properly.

-- Walt

Windows 10 Home, version 1909 (183623.476),
Desktop: 16GB memory, Intel Core i7-6700K @ 4.00GHz, GeForce GTX 970
Laptop:  8GB memory, Intel Core i7-3625QM @ 2.30GHz, Intel HD Graphics 4000 or NVIDIA GeForce GT 630M
Affinity Photo 1.8.3.641 and 1.8.4.665 Beta   / Affinity Designer 1.8.3.641 and 1.8.4.665 Beta  / Affinity Publisher 1.8.3.641 and 1.8.4.663 Beta.

Share on other sites

Oops. Thanks for pointing that out Walt. I wasn’t concentrating.
Looking at the fonts in the PDF they seem to be all embedded subsets of the CM* fonts.
I installed the "cm-super" package into MiKTeX (via the Package manager) and added this line to my LaTeX code:

\usepackage[T1]{fontenc}

...but it’s still not coming though into Publisher correctly (all of the text is being converted to Consolas, for some reason).
Aside: If I try and open the PDF in Designer it asks to convert all of the fonts to Arial.
Opening the PDF in Inkscape – via the Poppler/Cairo importer – lets me save as SVG and then import that nicely into Publisher (see attached) but it makes the process more long-winded and, therefore, less useful.
As far as I know, TexWorks doesn’t have an “Export to SVG” function.
I’m not a LaTeX expert but maybe there’s one out there who can give more/better information.

Share on other sites
4 minutes ago, GarryP said:

...but it’s still not coming though into Publisher correctly (all of the text is being converted to Consolas, for some reason).
Aside: If I try and open the PDF in Designer it asks to convert all of the fonts to Arial.

Do you also have the relevant CM* fonts installed in Windows?

-- Walt

Windows 10 Home, version 1909 (183623.476),
Desktop: 16GB memory, Intel Core i7-6700K @ 4.00GHz, GeForce GTX 970
Laptop:  8GB memory, Intel Core i7-3625QM @ 2.30GHz, Intel HD Graphics 4000 or NVIDIA GeForce GT 630M
Affinity Photo 1.8.3.641 and 1.8.4.665 Beta   / Affinity Designer 1.8.3.641 and 1.8.4.665 Beta  / Affinity Publisher 1.8.3.641 and 1.8.4.663 Beta.

Share on other sites
19 minutes ago, GarryP said:

the﻿ "cm﻿-﻿supe﻿﻿r﻿﻿﻿" package﻿

Alfred
Affinity Designer/Photo/Publisher 1.7.3.481 • Windows 10 Home (4th gen Core i3 CPU)
Affinity Photo for iPad 1.8.3.180 • Designer for iPad 1.8.3.2 • iPadOS 13.5.1 (iPad Air 2)

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×

• Affinity

×
• Create New...