I have been using Miro tables where I need each column to represent one week; two header rows at the top of the table contain the week number and the week day. I can create the header info the hard way by manually typing in each date in each cell of the Miro table. Eventually, I figured out I could use excel to use simple formulas to calculate the week to week value as well as a second formula to create the week number in two rows on top of each other (see excel screen shot). I didn’t have to manually create the rolling date field because formulas can do it across whatever range I wanted.
I would then copy and paste these two rows calculated and created in excel and paste into the Miro board. As I understand it it would automatically copy the excel info as plain text.
This was an important feature because then I didn’t have to manually add the week numbers and week days to the Miro board: i could do it in excel and then copy over and paste as text into the Miro board.
However, Miro has pushed a new update where I can no longer paste excel data field as text into a Miro table. Instead it now only pastes it as a separate excel table in Miro. I see a new pop up window (see screenshot below) asking to paste data field values in new table or to paste data as stickies. Before there never was a popup “paste as” window, and would just paste as unformatted text.
Is there any workaround? Or can we bring back that capability? I think Miro now does not have the ability to paste as plain text data from other programs such as excel---instead it makes you only paste as a new object or table or post it notes.
Maybe with this new Excel capability in Miro opens up a different way to do this and not have to manually populate date fields?
