Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.

I use the snapshot sources. I followed "Get started". So I have put the widget into <div id="luckysheet" style="margin:0px;padding:0px;position:absolute;width:100%;height:100%;left: 0px;top: 0px;"></div>. However, it turned out that the div inside, of the class luckysheet, had dimensions of 100x100 pixels. I needed to resize the browser just to make the div scale. It scaled too large, though. I attach a screenshot with "double" scrollbars. I would expect the external scrollbars to not exist at all. Probably, the widget thinks that is is smaller, when in reality it is larger. One of the reasons might be local cache restored information, which goes beyond the right margin, and also the large branding at the top.

• is there some resize api, to inform the widget that it should initially resize itself?
• how to get rid of the info about cache which looks like debugging, and which may cause the scaling problems?
• how to remove the branding, which may also cause the scaling problems? I would want a clean widget in a div.

[Cannot read properties of undefined (reading '0')](luckysheet.umd.js:9 Uncaught (in promise) TypeError: Cannot read properties of undefined (reading '0'))

Describe the bug Getting this error in console:

Uncaught ReferenceError: jQuery is not defined
    at Object.eval (plugin.js?a083:1)
    at eval (plugin.js:12)
    at Object../node_modules/luckysheet/dist/plugins/js/plugin.js (chunk-vendors.js:3364)
    at __webpack_require__ (app.js:854)
    at fn (app.js:151)
    at eval (cjs.js?!./node_modules/babel-loader/lib/index.js!./node_modules/ts-loader/index.js?!./node_modules/cache-loader/dist/cjs.js?!./node_modules/vue-loader/lib/index.js?!./src/components/Sheet.vue?vue&type=script&lang=ts&:8)
    at Module../node_modules/cache-loader/dist/cjs.js?!./node_modules/babel-loader/lib/index.js!./node_modules/ts-loader/index.js?!./node_modules/cache-loader/dist/cjs.js?!./node_modules/vue-loader/lib/index.js?!./src/components/Sheet.vue?vue&type=script&lang=ts& (app.js:1019)
    at __webpack_require__ (app.js:854)
    at fn (app.js:151)
    at eval (Sheet.vue?24b5:1)

To Reproduce

1. Create a Vue project with vue cli;
2. yarn add luckysheet;
3. In an SFC add this code:

<script lang="ts">
import { Component, Vue } from 'vue-property-decorator'
import 'luckysheet/dist/plugins/js/plugin'
import luckysheet from 'luckysheet'

@Component
export default class Sheet extends Vue {
  mounted () {
    luckysheet.create({
      container: 'lucky-sheet',
      showinfobar: false,
    })
  }
}
</script>

What is expected? An empty sheet. No errors in the console.

Environment

• OS: Linux
• Browser: Chrome
• Luckysheet Version: latest

Additional context One must note that if <script src="https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/plugins/js/plugin.js"></script> is added to index.html than everything is fine, no errors.

描述错误 通过gulp编译出来的这几个插件在项目中都加载不了

重现 重现错误的步骤： 1.第一步操作：引入luckysheet

2.最后报错：在项目中报错，导致在Excel中有小数类型的数字会加载不出来luckysheet

环境： -操作系统：[Windows，Mac，Linux] -浏览器 版本号：[Chrome 版本 84.0.4147.105（正式版本） （64 位），Safari，Firefox，Edge] -Luckysheet版本：[最新]

Is your feature request related to a problem? Please describe. A clear and concise description of what the problem is.

Describe the solution you'd like A clear and concise description of what you want to happen.

Additional context Add any other context or screenshots about the feature request here.

In the current snapshot, even if the label "More..." is properly placed at the right margin, the toolbar icons are still displayed below and to the right of the label:

This makes the whole component too wide. Possibly caused by the spreadsheet being displayed in a div which is smaller than the entire web page.

PROTECT SHEETS AND CONTENT IN LOCKED CELLS

Is your feature request related to a problem? Please describe. A clear and concise description of what the problem is. It is not possible to protect the spreadsheet and to lock cells so that users of a preconfigured spreadsheet cannot mess up the formulas.

Describe the solution you'd like A clear and concise description of what you want to happen. to be able to protect sheets and the content of locked cells on these sheets (as in Excel)

Additional context Add any other context or screenshots about the feature request here. excel equivalent...

刚同步了官方仓库的主分支，发现一个很严重的错误。

#977 这个PR，一次修改了22个文件，变动是 $("body") 变成了 $("body").first()

如下图：

这个改动一言难尽，怎么会有多个 body 标签呢？一个开源库没必要给非正常的使用买单修改吧。

描述错误 在通过CDN引入到React项目中，一直报JQuery的错误 重现 重现错误的步骤： 1.第一步操作 在HTML文件中引入

4.最后一直报这个错误

环境： -操作系统：[Mac] -浏览器 版本号：[例如 Chrome 版本 84.0.4147.105（正式版本） （64 位）] -Luckysheet版本：[最新]

Is your feature request related to a problem? Please describe. What I get through API: luckysheet.getRange() is the number of visit rows and columns of the current selection, {column: [0, 1], row: [0, 1]}

But I want to get something like A1:B2

Describe the solution you'd like Open: range to coordinate api

Is your feature request related to a problem? Please describe. Context: We would like to embed the luckytable in a simple web interface for end users. Currently end users get confused with menu, toolbar, column and row headers, etc.

Describe the solution you'd like Thus end users shall NOT have the option (nor need the option) to code/edit/layout the model, with exception of few cells that are preconfigured for user inputs.

Moreover, we would love a simple and clean representation/view of the coded spreadsheet for end users - without any of the menus, tools (e.g. formatting table) and the column and row headers.

Related is request #45 about protecting the spreadsheet: in the end user representation, one would only be able to make few inputs in predefined cells and then the model will provide the output.

Additional context Add any other context or screenshots about the feature request here. Hope it's clear, am available for questions, and would be very happy to get this feature. thank you!

描述错误

在 sheet2 中设置一个单元格 link 到 sheet1，如：=Sheet1!C3，在此单元格向上增加一行，单元格的公式被改变为 =Sheet1!C4。

重现

1. 第一步操作: sheet2 中设置一个单元格：=Sheet1!C3
2. 第二步操作: 在此单元格向上增加一行
3. 最后看到了什么错误: 此单元格公式和值都被改变：=Sheet1!C4

期望的结果

期望这个l单元格的link目标保持不变 屏幕截图或演示

未增加行前：

增加一行后：

环境：

• 操作系统：Mac
• 浏览器 版本号：Chrome
• Luckysheet版本：最新

备注

1. 通过传入 triggerBeforeUpdate 和 triggerUpdated 两个参数来决定是否触发hook事件
2. setRangeConditionalFormatDefault方法支持regExp，正则表达式

// conditionName string regExp
// conditionValue array [正则表达式, 0或1] 0表示对正则表达式结果取反，1表示不取反，默认是1
// option 
luckysheet.setRangeConditionalFormatDefault('regExp', [/^\d{2,3}$/g, 1], {cellrange: {row:[0,30],column:[0,0]}, "format": {
    "textColor": "#000000",
    "cellColor": "#ff0000"
}})

描述错误 在A单元格中插入链接后，拖拽A单元格至B单元格，A单元格的内容虽然清楚了，但链接依旧生效。

重现

1. 点击A单元格:
2. 插入链接至A单元格中:
3. 拖拽A单元格至B单元格:
4. A单元格的内容清楚了，但点击A单元格跳转链接了:

期望的结果 1.清除A单元格的内容及内容的附属功能； 2.插入的链接，使用Ctrl+左键触发，不然无法修改链接内容。

屏幕截图或演示

环境：

• 操作系统： Windows10
• 浏览器 版本号： Chrome
• Luckysheet版本：最新

备注 谢谢各位作者

i cannot trigger rangeCopyAfter function as many other "Selected area" functions unless, rangePasteBefore it works fine as this example : 我无法像许多其他“选区操作”函数一样触发 rangeCopyAfter 函数，除非 rangePasteBefore 它工作正常 作为这个例子： rangeCopyAfter : (range,data) => { console.info(range); },