You can edit most spreadsheet cells by selecting them and entering the data you want to display, allowing you to change individual items quickly. Cells in certain columns, such as the Tagname column, are read-only and cannot be modified.
To change multiple fields for a particular block, you can double-click the block to display its dialog box. To change the same field for multiple blocks, you can find and replace data in a spreadsheet column. Refer to the chapter Locating and Displaying Data to learn more about finding and replacing data.
Exchanging Data
Database Manager also lets you edit blocks by copying or exporting them. Whenever you complete these tasks, the program converts the selected blocks into comma separated value (CSV) format, enabling you to paste or import the data into your favorite text editor or spreadsheet. Once you edit the data, you can copy or import the data back to Database Manager.
Often a quicker way to convert blocks into CSV format is by holding down the Control key and dragging and dropping the blocks from Database Manager and into Microsoft® Excel. The blocks you move appear in CSV format, allowing you to edit them. When you finish, you can drag them back. To learn more about using Excel with the Database Manager, refer to the section Copying and Pasting Blocks.
