![]() In this particular project it would just need to copy the resulting range and paste it to the table relevant sheet. Basically it would provide the same range result as a manual filter. In the case this actual project, this isn’t possible on the original table, but making a temporary copy of the table would be just fine and after a sort on the pertinent column, there wouldn’t be this issue of non selected row. Thirdly, your suggestion would be much faster, I think the best workaround for the non selected rows would be to do a sort on the table containing the data in advance. A long process, but after some tinkering and optimization, it provides the expected results without speediness, but comparable to Excel’s performances. I did so mainly by using the example shown in the first post to extract the value and format of each individual cells and to reconstruct new tables cell by cell with those values. Secondly, being definately out of Excel and forcibly in Numbers’ bangwagon, I had no choice but the find a workaround to emulate the result of Filter. I could not conceive it didn’t exist! Thanks Apple! After gaining some knowledge on the basic of Number’s AppleScript language support, my first foray was to look for the AppleScript command to setup Filters in Number. My reasoning being that I could emulate Excel’s Macros with AppleScript. Up to 2020, when I decided that it was enough, not having the available time to program a full application, I thought to give a try to Numbers, for which I had a very superficial experience. Every january, I was fearing to suffer Excel for one more long year. Once the accounting year had started, it was out of the question to replace it. With every system upgrades the Excel projet became ever more frustrating to use and unstable in its functioning. Unfortunately, the years passed, I didn’t had time to work on anything new. My plan was to develop later a better solution with another software and recuperate the templates and the data gathered meanwhile. Even though I had no personal experience with this software or Macro programming, I was able to provide a workable solution that revolved mostly around calling the “Filter” command from a Macro. Some, … many years ago I rapidly developed in emergency a prototype for general accounting with Mac Excel for an external company. I’m sorry for the delay for the reply, but meanwhile I gave some thoughts to your suggestions.įirstly, let me present to context for my search. ![]() Well, I do hope that Apple’s programmer will! I apologizes, I can’t change the design of the application. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |