FredB

Aargh, how clumsy. And it was so simple in PagePlus. Thanks.

I have to create consolidated papers for a meeting. The Agenda refers to various items following in the document and needs to give the page number for each, e.g.: 8. Accounts for 2020 (p.14) In PagePlus I could use a cross-reference, which would let me format it with prefix "(p." + page-number-of-the-anchor + suffix ")". The page number would then update itself to match where the target actually was, as the document grew. I cannot find how to achieve this in Publisher. The only mention of cross-references in the Help talks about previous or next frame linkage, which is not relevant here. The Help on anchors doesn't suggest how to get a page number self-updating either. Obviously I can do the job manually, but that's error-prone.

Thanks: optical alignment does the trick. I can't use tabs: the data is imported from Excel and comes in with no included tabs. I can't type tabs into 65 rows of 8 columns of figures without risking accidental alterations. There are, of course, only ten negative numbers in the whole lot!

[Publisher 1.9.2.1035, Windows10] I have to set some accounts tables (SOFA and Balance sheets). The convention is that negative amounts are in parens, positive without. The entries should be aligned right in their cells, but in order to get the actual figures to line up I need a space following the positive numbers (a space the size of the right paren, of course). However, I cannot see how to achieve this. Any kind of space I insert after the last digit is suppressed by the right-alignment. It was no problem in Pageplus ... I could work round by getting Pageplus to emit a PDF/EPS of these tables, but that's not a viable long-term solution.

Attached was created in Google Sheets and saved as .xlsx - it also crashes Publisher. Might be useful for diagnosis given it's about as simple as you could wish. Untitled spreadsheet.xlsx

[Windows 10, 64-bit; Publisher 1.9.2.1035] Needing to import some tabular data, put it in an Excel spreadsheet. The "Help" says I should be able to drop the file onto Publisher. Doing this causes a crash. The attached empty .afpub file and the attached .xlsx file do this every time on my system. analysis-by-society.xlsx empty.afpub

Here's what I do - a bit tedious but it gets the job done. Use "Find" to locate all the single quotes, then hit the single-quote key (which autocorrects the first one), select the next on the list and repeat; then the same for double.

Thanks, that does the trick. And of course if I assign a Paragraph style or two I can cut down on the work involved. I should stop trying to do things the Pageplus way ...

I wouldn't. I'd expect it to be at one height for uppercase characters and lowercase characters with ascenders, and a lower height for (lcase) characters without. Which is what seems to be happening.

Trying to set up financial tables (balance sheet and income/expenditure). These need rules drawn before and after totals and subtotals. I expect to be able to do this with "stroke and fill" in the Table dialog. In Pageplus I could set a single rule at the top of a totals cell and a double rule at the bottom. Is this supposed to be possible in Publisher? It seems a fairly basic requirement if one is to satisfy the demands of the accountants (whose data I am trying to typeset). The alternative of a thicker rule below is not favourably regarded. While I could of course introduce an empty row underneath, with its own extra line, this seems a kludgy approach. Attached pdf derived from Pageplus shows what I am looking to achieve. cc2020-report.pdf