APEX Office Print (AOP) – Problems Excel Text Wrap, Line Break

Problem

An Excel template was created (with the variables according to AOP) including line wrapping (text wrap, line break). During the subsequent document creation, however, the line break is not taken into account (not in every column). However, this also means that when creating a PDF document, the line (in the respective column) is cut off. Only the opening with the Excel Office application and the subsequent processing (Edit document – secure source) and the double-click on the respective line element made the line break visible.

However, it should be noted that the line break works for certain columns. A check on the text length in advance (already correct text lengths are passed) brought here also no success.

Troubleshooting

AOP support is aware of this limitation. The function of the line break is to take place with a new release in July 2019. If there are, however, it requires the manual line height by the user. However, this is not expedient, because it can not be said, which amount is finally reached maximum.

Workaround

Create a table in the Word application (the standard Word table without combining it with Excel). Adjust the formats (height, length, width) like the Excel spreadsheet (as you wish). Unlike Excel, Word automatically adjusts the cell height (line height) to match the text length.

The subsequent conversion from Word to PDF works the same as in Excel. Excel is not always effective.

Limitations

There are currently some formatting issues with Word. So lines in Word need at least always 1px in height. As a result, a “bold” line border can not be set optimally. Adding the lines in AOP also works well for Word tables.

When converting from Word to PDF (but also Excel to PDF), the use of Libre Office (transformation) changes the format slightly. This has the effect that texts appear partially larger or the breaks are wrong. Therefore the Word template should be adapted and tested to the final format (eg PDF).

WD Elements Portable, externe Festplatte - 1 TB - USB 3.0 - WDBUZG0010BBK-WESN

 (39139)

46,29 € (as of n/a - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

KabelDirekt – 0,25 m – 4K HDMI-Kabel ([email protected] & [email protected] – spektakuläres Ultra-HD-Erlebnis – High Speed mit Ethernet, kompatibel mit HDMI 2.0/1.4, Blu-ray/PS4/PS5/Xbox Series X/Switch, schwarz)

 (46834)

4,59 € (as of n/a - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Am Arsch vorbei – Der Gelassenheitstee: 100g Kräutertee Wellness in der Dose

 (2652)

7,99 € (as of 11. April 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Webcam mit Mikrofon, HD 1080P Web Kamera mit 120° Blickfeld, Belichtungskorrektur und Drehbarem Clip, USB 2.0 Plug & Play für Live-Streaming, Videoanruf, Konferenz, Kompatibel mit PC/Mac/Linux

 (12082)

24,99 € (as of n/a - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Vielleicht - Eine Geschichte über die unendlich vielen Begabungen in jedem von uns: Das besondere Kinderbuch (Geschenkbuch Mädchen und Jungen)

 (7464)

12,95 € (as of 11. April 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Apple Pencil (1. Generation)

 (63795)

89,00 € (as of n/a - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Schaukel das Schaf - Ein Mitmachbuch zum Schütteln, Schaukeln, Pusten, Klopfen und sehen, was dann passiert. Von 2 bis 4 Jahren: Vom Bestsellerautor (Schüttel den Apfelbaum)

 (1675)

8,99 € (as of 11. April 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Das Café am Rande der Welt: eine Erzählung über den Sinn des Lebens

 (11026)

8,95 € (as of 11. April 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Achtsamkeit für dich: 50 Karma-Kärtchen | Schön gestaltete Achtsamkeitskarten in Geschenkbox zur Stressbewältigung im Alltag (Achtsamkeitskärtchen)

 (4312)

4,99 € (as of 11. April 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Fujifilm instax Mini 9 Kamera, blush Rose

 (45090)

57,33 € (as of n/a - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)