MultiRáció
English Magyar

EuroSymphony extensions

EuroSymphony Plotter

EuroSymphony Plotter is a Lotus Symphony extension by MultiRacio Ltd. for high-precision custom illustrations and transformations. You can describe many geometric shapes in a spreadsheet table, and with EuroSymphony Plotter you can plot them.

Creating Drawings

Describe as many geometric shapes as you wish in a spreadsheet table (in the format detailed later on this page), select this data range and select Create Drawing from the Tools menu. (It is often simplest to select the data range by clicking and dragging on the column letters. You may get a warning message on the line with the header, but it will work.)

Disassempling Drawings

Simply right click a drawing in Calc and pick Disassemble Drawing to generate (on a new sheet) the table describing the drawing. If the drawing only contains components understood by EuroSymphony Plotter, the table can be used to recreate the drawing using the Create Drawing command. The coordinates can of course be transformed before recreating the drawing to achieve specific effects.

Data format

The resulting plot can be made up of any number of shapes. Each line in the input gives some information about a shape. Some shapes are described in a single line, others in multiple lines.

The columns of the table are in order from left to right: type, id, line color, fill color, x, y, extra 1, extra 2, extra 3. Type should be one of Ellipse, Rectangle, PolyLine, PolyPolygon, ClosedBezier, OpenBezier. (Note that this column is case-sensitive!) Id has to be unique for every shape (it can either be a number or text). Line color and fill color are given in the form of three integral numbers (for the red, green and blue components of the color) separated by semicolons, such as 255;100;100 for pink. The fill color can be left empty to describe an unfilled shape. The rest of the parameters are interpreted differently for different shape types.

For the Ellipse shape type only a single line of data is needed. x and y set the top right corner of the boudning rectangle of the ellipse, extra 1 and extra 2 set the width and height, and extra 3 sets its rotation in hundredth degrees.

For the Rectangle shape type only a single line of data is needed. x and y set the position of the top left corner, extra 1 and extra 2 set the width and height, and extra 3 sets its rotation in hundredth degrees.

PolyLine and PolyPolygon both represent shapes made up of straight lines. PolyLine is an open line sequence, and PolyPolygon is in turn automatically closed (the last point is connected to the first). These shape types are described over multiple lines, one for each point that makes up its outline. The color information is only read from the first line. In the rest of the lines only the id and the coordinates are required. The extra 2 cell may contain the word NEW to denote the start of a new outline within the PolyPolygon. Shapes with holes in them need this functionality.

OpenBezier and ClosedBezier both represent shapes made up of curved or straight lines (or both). OpenBezier is an open line sequence, and ClosedBezier is in turn automatically closed (the last point is connected to the first with a straight line). These shape types are described over multiple lines, one for each point that makes up its outline. The color information is only read from the first line. In the rest of the lines only the coordinates and the first extra column are important (but of course the id is needed in every line to identify them). The second and third "extra" columns are not used. The extra 1 cell should be a string that is one of NORMAL (for normal points), SMOOTH (for points where the point and its two control points lie on the same line), SYMMETRIC (for points where the control points are symmetric) or CONTROL (for the control points). A straight line segment is created by placing two NORMAL points after each other, and a curved segment by placing two CONTROL points between two NORMAL points. SMOOTH and SYMMETRIC points are also used to create curved segments, but care must be taken to properly position their control points then. Writing NEW in the extra 2 cell has the same effect as in the case of PolyPolygon and PolyLine.

The coordinate system used is the internal coordinate system of Lotus Symphony. The unit is one hundredth millimeter (don't ask), X is horizontal, Y is vertical, the origin is the top left corner and both coordinates are positive in the visible quadrant.

NFU LIPSZ InfoPólus ODF MultiRáció Home Page