-
There are a lot of ways to set this up, Here's how I did it. First, I used quick fill to put a lot of data on sheet A of a new QP notebook. On Sheet B, I put the starting row number (10 in your example) into cell B:A1 I put the ending row number (8000 in your example) into cell B:A2 I put the following macro commands into B1..B4: {if B:A1>=B
-
It is a bit of a headache, even for those of us who have occasionally used it, which may explain the failure to attract lots of help there. Here's what I would do. 1. Start on a cell with a date in it. F12 to Cell properties, select the Numeric Formats tab and click the bottom entry, Custom. Click "Add ..." button to add your new date
-
I can't help with third-party applications, but have you ruled out WordPerfect's own document assembly capabilities with its Merge functions? There are plenty of samples and discussions in the Macros & Merges forum of WordPerfect Universe. I've incorporated some of them in a case management program written in Quattro Pro that assembles
-
I agree that the TOA sorts are alphabetical, and this causes the results you see, which users must check and correct. I agree that it would be nice for WP to know in advance when it would be more appropriate to sort parts of the citations numerically instead of alphabetically. (I don't have Corel's Perfect Authority - perhaps it does all this
-
It has worked that way at least since I started using WP in the early 1990s. WP can't be expected to know how to sort each set of authorities that might be used by any user anywhere in the world, and have a special rule for them. That would be a programming nightmare. So, the user has to take responsibility for final manual changes to the tables
-
I think that QP X6 has a problem importing custom toolbars from saved workspaces. I attempted to restore a saved workspace in QPX6, but the custom toolbar appeared as the smallest blank space for toolbar buttons, omitting the ten buttons I had there. To test, I started with the default workspace and then created a new one. I created a custom toolbar
-
On many versions of QP before X5, you could cause QP to fail this way by opening a file from a CD, thumb drive, or some other inaccessible drive. That stored the address in the Most Recently Used keys in the registry. When QP opened again, it looked for that file, and if the drive was not available, it crashed like this. A common solution has been to
-
I was unable to open your table.xlsx file in either QP X5 or QP X6. The cells that QP ignores appear to be simple numbers, so I have no explanation for QP's failure to display them. Time for some lentil soup. Charlie
-
That's odd. Sum works for me. I would double-check the source data to be summed to ensure that the entries that appear as numbers aren't actually text But if they are numbers, I would then check the construction of the cross-tab report to ensure that it covers the range of data to be summed. If the same structure relates to both Count and Sum
-
I remember the same symptoms (crash if a particular file is opened by an icon or by clicking explorer, but not if QPX4 was opened first) some years ago, though in that case, the crash occurred on a print request rather than file opening. I wish I remembered the ultimate fix. I think it had something to do with file associations I had altered in the