ExcelFormat.DLL -- and the latest DLL's
Grzegorz (Greg) Pasternak
gpasternak at cogeco.ca
Wed Oct 23 17:48:47 UTC 2024
Doug;
You are superman, seriously!
Thanks for this.
However, it doesn't solve the problem I have at hands as it is about Omnis Studio 6.1.3 (though 64 bit).
I have come up with 2 options now:
1. Use "workstation" on a separate machine - this works for a different customer hosted in-house - but it is not good to implement today.
2. Remove the option of creating XLS/XSX files on "workstations" and leave it on "server" only - this is the priority as files are created automatically and sent, "workstation" users have no need to do the "by hand" - this is probably the workaround for today.
About Windows, well, some stuff works and some doesn't which I am discovering daily working on the Web App, but that is a different topic for another day. Thanks for all your help.
Grzegorz (Greg) Pasternak
> On Oct 23, 2024, at 1:04 PM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>
> hi Greg (and the world)
>
> The latest archive of all versions of Excel Format xcomp up to and including just release 4.4.1 is found at:
>
> http://www2.artsman.com/omnis/Software/Omnis-XL441.zip
>
> the changes as per the libxl foundational libraries that excel format is based on.
> https://www.libxl.com/changelog.html
>
>
> *** WARNING ***
>
> Some cautions before anybody runs out and installs the latest are:
>
> — all new versions are compiled as only 64 bit.
> — we focus on latest studio versions, so only studio 10.2 and Studio 11.0, 11.1 and 11.2 for this version
> — Excel Format 4.4.1 is built from libxl 4.4.1 which is the latest release of libxl.
> — You will need you to ‘upgrade’ your licence at $99 per platform
> —— IF you purchased your original licence more than a year ago.
> —— That LIBXL's rules .. free upgrades for a year and this tool is so essential for our community, that we’d like them to stay in business :)
> — if you have Excel format 388 or 390 or earlier, you will likely need to pay for the update
>
> last 32 bit releases
> — for studio 5 was Excel Format 2.2.0
> — for windows studio 6 was Excel format 3.7.2
> — for windows sudio 8 and 10 was Excel Format 3.9.4
>
> Everything since Excel format 4.3.0 is 64 bit only, studio 10 and later only.
>
>
>
> The older versions of LibXl for windows may have needed msvcp110.dll an msvcr110.dll in the same directory as the xComp if ir was not installed in the OS. I believe those are now bound into the external so that there is no dependency within the xcomp itself for windows.
>
>
> Also, windows being windows, you may need to make sure you have installed the appropriate micrsoft runtime environment with omnis to make a bunch of things work. Sadly, microsoft has traditionally included all bloatware installed for free and essential development frameworks need to be downloaded and installed manually. (yes, thats an editorial comment on my part that is often sadly true).
>
> have a look at the microsoft support areas for the VC++ runtime — if you have just installed OMNIS for the first time on a workstation or server. If omnis runs, then you might have the right version of this installed that is appropriate to the version of omnis you have
> https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170
>
> Our Theatre Manager installers put a few of them in place to make sure we cover the bases for different runtimes. If its a new operating system install, chances are you may not have the support files.
>
>
> I’m out for a bit. I”ll come back later and rethink any other advice. I just wanted to let everybody know about latest versions if that impacted them.
>
>
>
>
>
>
>
>
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
>> On Oct 23, 2024, at 7:26 AM, Grzegorz (Greg) Pasternak <gpasternak at cogeco.ca> wrote:
>>
>> Phil;
>>
>> I took another look at these 2 additional dll files, I have indeed found reference to them after dusting off my hard drive a little
>> (\\Mac\Home\Desktop\Artsman\ExcelFormat390AndDemo\ExcelFormat372\64bit- Sudio 6 and 8\beside Omnis_exe only if needed)
>>
>> I copied/pasted them with full admin rights to my second Omnis Studio 6.1.3 64 bit installation on Windows 11 - the one that does not load ExcelFormat - it did NOT make any difference.
>>
>> As mentioned in my previous email, the other dev installation for the same Omnis version (just different dev license) on the same machine loads ExcelFormat without any problems - this seems to be a consitent behavior with what the customer experiences (I have to deal with this issue today).
>>
>> So, while the life would be easier if I could simply copy/paste those two additional dll's into xcomp, this does not seem to be the solution.
>>
>> I think moving "workstation" installation off app server to a different machine would help but I don't expect this to be easy "to swallow" today.
>> Installing 32bit Omnis 6.1.3 instead of the 64bit used by "workstations" ? This may work but can simply replace one problem with a different problem.
>>
>> I am running out of ideas.
>> What else can I try?
>>
>> Grzegorz (Greg) Pasternak
>>
>>
>>
>>
>>
>>> On Oct 23, 2024, at 5:11 AM, Phil (OmnisList) <phil at pgpotter.co.uk> wrote:
>>>
>>> msvcp110.dll
>>
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en
mailing list