Tag: microsoft_excel

I finally got a reply from a support representative from SWING Software and it appears that SWING Integrator doesn’t support writing formulas to Microsoft Excel. I think this is a real shame shame since it restricts its use dramatically or at least makes some functionality very difficult to implement. Of cause there might be a valid reason for this restriction.

Anyways I reimplemented the needed functionality by doing all the formatting in LotusScript. Apart from the solution being a lot longer (more lines of code) and taking more time to implement I solved the problem which is what really counts.

If you have experience with SWING Integrator and Microsoft Excel, more specifically experience in writing formulas from Notes to MS Excel I would be VERY happy to hear from you. We have a major issue with an application due for launch. It seems like the SWING Integrator code removes the equal-signs in from of the formulas thus rendering them unusable in Excel.

The formula is a concatenation of two dates from the Date functions (the funny å-character is the Danish stand-in for year (år)):

=concatenate(text(date(2006;11;8); "dd-mm-åååå"); " - "; text(date(2006;11;19); "dd-mm-åååå"))

(If I remove the equal-sign in front of the formula the text is written correctly to Excel so I think the issue stems from how SWING Integrator handles formulas.)

Heeeeeelp!