Git Product home page Git Product logo

logseq-plugin-luckysheet's Introduction

中文 | English

logseq-plugin-luckysheet

在 Logseq 中嵌入电子表格 Luckysheet。你也可以用它来维护一张 markdown 表格。

表格数据存储在 assets 文件夹下。

使用展示

demo

使用示例

{{renderer :luckysheet, workbook name}}

免责声明

本插件中使用的表格是第三方的开源软件 Luckysheet,非插件作者维护。插件作者不对由此带来的可能数据丢失或错误负任何直接或间接责任。

Buy me a coffee

如果您认为我所开发的软件对您有所帮助,并且愿意给予肯定和支持,不妨扫描下方的二维码进行打赏。感谢您的支持与关注。

wx ap

logseq-plugin-luckysheet's People

Contributors

sethyuan avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar

logseq-plugin-luckysheet's Issues

Is it possible to auto rename the source file?

(First, it's an incredible plugin, thanks for your amazing work!)

  • As the question says is it possible to automatically rename the source file?
    • I know I can change the name in the UI, but the source file keeps the same and I didn't find where it store the name information.
    • And I found that I can manually change it without losing my data, but once I make further modifications on the sheet, it will create a new file with the original name.
  • I want to make sure all the stored files are at use, otherwise they can be deleted safely.

Data loss

Hi! I've happily been using the Luckysheet Logseq plugin, which I like very much apart from one thing: this plugin tends to lose data.

I understand that for performance reasons it writes to temporary files and syncs with the child block markdown only on the next app start, but this process is not entirely reliable and I have lost hours of work on a few occasions. Plus I sync my Logseq graph on multiple devices, and Luckysheets aren't part of that sync unless I close and reopen Logseq everytime, which is cumbersome and slow.

How about a "save" button that syncs with the child block markdown when clicked? This way the plugin keeps its current performance profile, and would also provide data safety.

建议导出表格为hiccup

如果lucksheet上的表格有合并行,则无法导出为markdown表格。因为logseq支持hiccup语法,建议lucksheet导出为hiccup以支持复杂表格。参考如下:

Office&WPS转Logseq表格
https://getquicker.net/Sharedaction?code=7993fcd0-c6ed-4a69-5cb8-08db541d6de4

https://docs.logseq.com/#/page/hiccup

另外如果可以的话,建议可以从markdown表格或hiccup表格导入到lucksheet,这样就可以处理已有的表格,有导入导出功能简直就无敌了!

<br /> doesn't show properly in heading row after MD generation

First of all, I love this plugin!

Even through <br /> is correct markdown, it shows as is in a logseq block after exporting luckysheet to markdown.

This only happens if the table heading has <br /> but works ok if the a normal table row has it.

Instead, if I use [:br], it works fine and a new line is correctly rendered as the heading row in the logseq table block

Thank you!

保存的表格信息需要如何直接打开呢

根据说明,我在'.logseq\storages\logseq-luckysheet'中找到的保存的表格文件,文件被保存为类似‘workbook-9f303b8837ccde59ad8016a901a3e8e1b874643e’形式。

  1. 尝试过增加文件后缀xlsx,打开失败。
  2. luckysheet项目提供的在线工具仅支持xlsx文件。

请问有没有方法可以读取插件自动保存的表格文件?感谢您的插件,给笔记带来了很棒的体验!!!

Feature Request: Persist to/Read from CSV/TSV

Hi @sethyuan, thanks a lot for this plugin!

One way to approach #10 and solve another great use case is to persist the data locally in the assets folder as CSV.

This is very consistent with how logseq handles non-text datatypes

  • drawings are persisted in the draws subfolder
  • images are persisted in the assets subfolder
  • pdfs are persisted in the assets subfolder

Additionally this also enables a lot of other benefits, which I'd be most excited about

  • Data is not locked into the serialization format used by luckysheet
  • Much easier to handle larger tables in a dedicated table file format than markdown
  • Edit data in a dedicated spreadsheet software, view in logseq
  • Use tables as databases and reuse them across applications - e.g. do data engineering in a jupyter notebook, then read/view/comment in logseq
  • use command-line utilities for quick data engineering - xsv, visidata, cut, ....

One option to implement:

Save button persists to disk in asset folder, vs storing in markdown
This could be configurable in the plugin settings

Make it easier to find and open luckysheet files

Right now, creating another reference to an existing luckysheet file requires copying the exact filename. It would be nice to have an open function in the gui or an autocomplete/dropdown while renaming the luckysheet to help us find previously created luckysheets and in a new reference. Bonus points for a Save As function to make it easier to create versions of a sheet.

Super cool idea! But it doesn't sync to other machines.

Is there no way for the plugin to save the worksheet data in the logseq graph folder? I see that it saves it in $HOME/.logseq/storages/ but since that is not synced across all machines (and probably won't be synced by Logseq's new sync service) it makes the plugin less useful.

Frame around table

In the GIF demo, your table has a frame around it, my Luckysheet-plugin-generated table does have that. Is there something I have not done?

安装插件后,命令菜单里没有 luckysheet,为什么?

从logseq 0.6.0版本开始,我在电脑上装了luckysheet,尝试很多版本(无论是logseq还是 lucksheet 官网每发布一个新版本,我都会尝试安装一次,希望能用上luckysheet),logseq命令菜单就是没有lucksheet。我的系统是window10,logseq0.6.7,luckysheet0.6.1。
图片
图片
图片

`数据读取错误!` - Data loading error caused by wrong substring index

Hi,

Thank you very much for the plugin!

I use the desktop version of Logseq 0.75 on macOS.

After a reindex I get the following error: 数据读取错误!

When I printed the error that comes out of the exception (document.getElementById("sheet").innerHTML = '<p class="error">数据读取错误!' + err + '</p>' ;) I go the following:

SyntaxError: Unexpected token ` in JSON at position 69265

The issue is in this line:

JSON.parse(firstChild.content.substring(7, firstChild.content.length - 3)),

I'm not sure whether it's a CR/LF/encoding issue, but for me the correct index is not -3, but -4.

I locally replaced the line with the issue with the following to patch the issue:

JSON.parse(firstChild.content.substring(7, firstChild.content.lastIndexOf(']') + 1)),

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.