Vorlage:Video-HervorhebungZahlenformatIgnorieren-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; ove…“) |
Keine Bearbeitungszusammenfassung |
||
Zeile 7: | Zeile 7: | ||
<p align="left">How to use the highlighting functions of firesys: <br><br> | <p align="left">How to use the highlighting functions of firesys: <br><br> | ||
<p align="left"> | <p align="left"> | ||
< | <ol> | ||
<li> <p align="left">Open an Excel workbook and select the cells you want to highlight on the worksheet.</li> | <li> <p align="left">Open an Excel workbook and select the cells you want to highlight on the worksheet.</li> | ||
<li> <p align="left">Click on the "Highlighting" button in the "Formatting" group of the "Design" menu band and select the "Ignore number format" function (green).</li> | <li> <p align="left">Click on the "Highlighting" button in the "Formatting" group of the "Design" menu band and select the "Ignore number format" function (green).</li> | ||
Zeile 18: | Zeile 18: | ||
<li> <p align="left">The selected table is updated and the number format is kept as desired and is not replaced by the format defined for the numerical values in Word.</li> | <li> <p align="left">The selected table is updated and the number format is kept as desired and is not replaced by the format defined for the numerical values in Word.</li> | ||
</ | </ol> | ||
</p> | </p> | ||
Version vom 30. Juni 2023, 10:48 Uhr
How to use the highlighting functions of firesys:
-
Open an Excel workbook and select the cells you want to highlight on the worksheet.
-
Click on the "Highlighting" button in the "Formatting" group of the "Design" menu band and select the "Ignore number format" function (green).
-
The selected cells are highlighted in red -
-
Now switch to the corresponding Word document and select the appropriate table.
-
Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".
-
In the "Hide numbers" group, you can activate the function "Hide Excel cells with red background when reading in" and then specify the number of X-characters to replace the numbers.
-
Now you can close the firesys settings.
-
Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
-
The selected table is updated and the number format is kept as desired and is not replaced by the format defined for the numerical values in Word.