[Solved] Copy & paste BIN2HEX result, NOT the equation

[matchbox_man]

Hi.
I've created an image bitmap table, 64 columns by 32 rows to represent the screen of a tiny LED display. Each cell being a binary 1 or 0, representing the monochrome image. Using the BIN2HEX command I'm then converting them into 8-bit hex data, now I need to copy & paste the 256 hex byte results into micro-controller memory (Microchip PIC's), but copying the cells I just get the BIN2HEX equation being copied, so is it possible to convert those into text (as seen) in each cell??

Mark

[MrProgrammer]

I need to copy & paste the 256 hex byte results into micro-controller memory (Microchip PIC's), but copying the cells I just get the BIN2HEX equation being copied, so is it possible to convert those into text (as seen) in each cell??

When you use copy in Calc, both the formula and the formula result are stored on the clipboard. It is the responsibility of the application performing the paste to select the correct one. You have not said what application you are using to paste. Check the documentation for that application to determine if it allows you to control which item is retrieved from the clipboard.

If:
• you are not able to find its documentation, or
• you do not understand its documentation, or
• you are not interested in reading its documentation, or
• that application doesn't provide a way for you to control the choice
you can use Calc to convert the formula to its value. Calc allows you to control which item is retrieved from the clipboard using the Paste Special feature.

Select the cell(s) with the formula(s), Edit → Copy, select some unused cell area in any Calc spreadsheet, Edit → Paste Special → Uncheck Paste All → Uncheck Formulas → Options:None → Operations:None → Shift:Don't → OK. Now when you copy the result(s) from the formerly unused area to the clipboard there is no formula to copy. Only the result will be on the clipboard and the unspecified application you're using will only find that for pasting.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know