search

ganesshkumar / obsidian-excel-to-markdown-table

An Obsidian plugin to paste data from Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc as Markdown tables in Obsidian editor.
MIT License
201 stars 7 forks source link

Pasting table doesn't work if the R1 and C1 is empty #23

Open LaurDr opened 1 year ago

LaurDr commented 1 year ago

Describe the bug If you try to copy a table in excel, and R1 and C1 of the table is empty, the plugin doesn't paste the table formatted as a table.

To Reproduce Steps to reproduce the behaviour:

  1. create a table with => 2 Rows and 2=> Columns in Excel
  2. leave R1 C1 empty
  3. Copy
  4. paste in obsidian.

current workaround

  1. Fill R1 C1 with any char
  2. copy and paste
  3. delete R1 C1 later on in obsidian

Expected behaviour Even if R1 C1 is empty, the table should be formatted correctly since markdown tables supports R1 C1 being empty

Desktop (please complete the following information):

ccchan234 commented 1 year ago

thanks, i just found it doesn't work and i have NO idea. now i know why. thanks

mtballday commented 1 year ago

Nice - I was wondering why I couldn't paste, but this was it.

Canadug commented 1 year ago

+1 for a fix for this. I love this plug-in but this is a must-have.