Wrote

I don't know if that might be an issue here, but sometimes switching input operations to numeric optimization can make the day.

Wrote

November 19th, 2015 - Plugin update:
- Plugin works with units
- PNG export (excel_PNGv2) checks whether output cells changed automatically
- excel_PNGv0 addded, exported file does not contain row/column reference
- excel_QUIT now can selectively close EXCEL program or just workbook
- SampleHowTo.zip is added - it is a good guide to possible uses of the plugin
- Plugin is out of beta!

Use at your own risk and please report bugs.



SampleHowTo.zip (1 MiB) downloaded 505 time(s).

Wrote

It might be me and my lack of programming skills, but unless I use an eval() on the expression passed to my excel_IN function, it will not cancel out all the units before pasting the value into the EXCEL cell. End result - MESS. Instead of cell value 3138.0096 i get 2.82646777304901*10^19/9007199254741*'kg*'m^2/'s^2*1/10^3*'kg*'m/'s^2*'m (which is actually 3138.0096).

I figured our proposed symb() function can be used in similar way to cancel out units, but preserve symbolic notation.

P.S.: I'm sure I could do it somehow inside the plugin code, I just do not know how... And would not want to get off topic here.

        public static bool ExpressionEvaluation(Term root, Term[][] args, ref Store store, ref Term[] result)
        {
            TNumber tNum = Decision.NumericCalculation(args[0], ref store);

            result = GetFloor(tNum).obj.ToTerms();

            return true;
        }

        public static TNumber GetFloor(TNumber tNumber)
        {
            TDouble tDouble = tNumber.obj as TDouble;

            if (tDouble != null && !tDouble.isText)
            {
                TDouble tFloor = new TDouble(Math.Floor(tDouble.D));
                tFloor.Units = tNumber.obj.Units;

                return tFloor;
            }

            TFraction tFraction = tNumber.obj as TFraction;

            if (tFraction != null)
            {
                TFraction tFloor = new TFraction(Math.Floor(tFraction.ToDouble()));
                tFloor.Units = tNumber.obj.Units;

                return tFloor;
            }

            TComplex tComplex = tNumber.obj as TComplex;

            if (tComplex != null)
            {
                TNumber tFloor = new TComplex(Math.Floor(tComplex.Re.ToDouble()), Math.Floor(tComplex.Im.ToDouble()));
                tFloor.obj.Units = tNumber.obj.Units;

                return tFloor;
            }

            TMatrix tMatrix = tNumber.obj as TMatrix;

            if (tMatrix != null)
            {
                int rows = tMatrix.unit.GetLength(0);
                int cols = tMatrix.unit.GetLength(1);

                for (int r = 0; r < rows; r++)
                    for (int c = 0; c < cols; c++)
                        tMatrix[r, c] = GetFloor(tMatrix[r, c]);

                return tMatrix;
            }

            TSystem tSystem = tNumber.obj as TSystem;

            if (tNumber.obj is TSystem)
            {
                for (int s = 0; s < tSystem.matrix.GetLength(0); s++)
                    tSystem.matrix[s] = GetFloor(tSystem.matrix[s]);

                return tSystem;
            }

            // TInfinity or math strings (skipped in TDouble)
            return tNumber;
        }

Wrote

Until it is corrected, the only workaround I found is to use
function round in Smath to strip any decimal part of values
before sending to Excel.

Wrote

I tried the plugin function excel_IN. I noticed that there is a problem if in regional settings of Windows comma (",") is defined as a decimal separator and number I want to transfer to excel has decimal part. If I switch (only for test purposes -- for my work I must use decimal comma) this setting to decimal dot, everything works correctly. Similar setting in Smath does not matter.

I think that this is a bug in plugin whic causes that internally values are transferred according to Windows setting and not always with decimal dot. Until it is corrected, the only workaround I found is to use function round in Smath to strip any decimal part of values before sending to Excel.