Do you have SWING Integrator experience?

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!

Published by

lekkim

Positive, competent, out-spoken, frank and customer focused architect and developer with a strong foundation in web, cloud and product development. I'm a strong advocate for API first and cloud based solutions and development. I have a knack for being able to communicate and present technically complicated matters in conference, customer and training settings. I've previously acted as team member and leader in a product organisation.

One thought on “Do you have SWING Integrator experience?”

  1. I have mostly used Word with Swing, not Excel – so I’m not quite sure where you are looking to use the above Excel formula. I assume this is on the Field Mapping tab of the Template setup form.

    With both Word and Excel we use Notes formulas for any calculations. I believe you can also use Lotusscript in the formula

Comments are closed.