dream-num / univer Goto Github PK

• Rendering @DR-Univer
  • Selecting
  • Freeze
  • Resizing
  • Dragging to move
• Features @wzhudev
  • Insert rows / cols
  • Delete rows / cols
  • Set row heights / col widths
  • Row col context menu
  • Move rows / cols
• Unit tests @wzhudev

Select one or more cells, click to set the text color, and then click the undo button three times to return to the previous state.

Sheet

• Features in the toolbar @wzhudev
• Features in the context menu @Dushusir @wzhudev
• Features in upper level plugins @Dushusir
• Delete legacy toolbar code @wzhudev

Doc

• Toolbar @DR-Univer no toolbar actually

The dev branch reported an error after executing the pnpm run dev: sheet command:

When I run pnpm run start:sheet, the following error is reported:

请问作者 这个现在怎么使用呢，需要下载源码后自己打包，和luckysheet一样？

• Migrate from Preact to React
• Migrate to React Hooks

Initial checklist

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Problem

How do I export or save it？

Solution

I can't find the exported code

Alternatives

no

运行npm run dev:sheet报错Uncaught SyntaxError: The requested module '/@fs/F:/univer/packages/core/src/DI/Decorators.ts?t=1689907140611' does not provide an export named 'AsyncDependencyItem'

支持把插入图片设置背景吗

Menu Registry

• MenuService @wzhudev

UI Library @jikkai

• Remove abstract Component and PureComponent
• Remove Preact and only React, remove abstracting layer at packages/base-ui/src/Framework/Preact.tsx
• Adopt React Hooks Components

UI Parts

• ToolbarService unnecessary
• ContextMenuService unnecessary
• (optional) FooterService @jikkai
• (optional) PanelService @jikkai
• (optional) CanvasPopoverService
• ShortcutService @wzhudev

Components

• Toolbar @wzhudev
• ContextMenu @wzhudev

Features

Architecture

• Migrate on IShortcutService @wzhudev
  • Implement IFocusService
  • Shortcut should check if it should be triggered before gets triggered
• (later) Migrate on IClipboardService @wzhudev

有没有后端的代码呀，谢谢

• ClipboardInterfaceService
• ClipboardService
• Basic copy paste feature of cell contents

比如公司会设置一些单据或者工单，模板肯定是不能让用户编辑的，只能编辑可填项，这种需求目前有API可以实现吗？

用了lucksheet2.0感觉功能很好，就是没有导出，用了别人的导出的方法都不太好。在这里蹲一个最新的包

• BSIU @wzhudev
  • Write unit tests as demonstration
• Clear cell content / clear cell styles @Dushusir
• Font family & font styles @Dushusir
• Border @Dushusir
• Foreground color & background color @TonyTonyChopper123
• Horizontal align & vertical align @Dushusir
• Text rotation @Dushusir
• Merged cell @TonyTonyChopper123

Univer很惊艳，能把Office三大利器制作成在线编辑这个难度极高。
但是，我们目前遇到的最大问题其实是：在线预览Word和Excel

这个需求极大，或者说这个是刚需，至于在线编辑Word和Excel，反而并不那么大。
因为，更多用户还是喜欢用Office软件本地编辑。

所以，希望能最先开发这个功能：在线预览Word和Excel。

（1）比如 https://officeweb365.com?src=Word_Online_URL
（2）微软的 https://view.officeapps.live.com/op/view.aspx?src=URL
（3）葡萄城的开发组件 https://www.grapecity.com.cn/ 等
都是通过云服务收费，提供在线预览。

你这个如果做成这种最好，通过URL传递远程word或者exel， 然后在线预览。
https://dream-num.github.io/doc?url=http://xx.com/test.docx
https://dream-num.github.io/xls?url=http://xx.com/test.xls

什么时候才有正式的使用文档呢？

1. 无法导入大数据，简直就是个笑话
   2.你这开发的，连个demo都不算，怎么通过评审的

好像都还是在开发状态？

• Adopt a monorepo managing tool (lerna / turbopack / rush)
  • Make sure building toolchain works
  • Incremental building & testing on CI
• Commit lint
  • Enforce Angular commit style
  • Eslint
• Migrate CI from CircleCI to GitHub Actions
• CI
  • Build
  • ESLint
  • Type checks
• Support package.json exports in plugins
• Preview link for each PR
• Provide a vscode task to launch debug windows
• Adopt typedoc to generate API website (maybe later)
• Migrate test framework to vitest

很高兴能看到这么优秀的开源项目，通过架构介绍和源码结构，让我学到了很多。
我虽然看到了README中宏伟的开发计划，但是作为新人，想要参与开发，也很难找到切入点。
因此，斗胆建议管理员使用issue将研发任务拆分到issue中。

demo里看的，编辑时候转义一下，要不又出现奇怪的东西了。

• Migrate doc commands & shortcuts to new architecture
• Remove legacy CommandManager
• Move UI framework to base-ui
  • Toolbar
  • Context menu
  • Slots for business to add their own components (later)
• Embed doc as sheet's cell editor (maybe fx editor in the near future)
• Support running multi-instances of different business type in underlying services (shortcut, menu)
  • IContextService
  • IUndoredoService
  • IShortcutService
  • IMenuService (later)

• integrate to SheetInterceptorService ViewModel
• integrate to CellEditorService
• #293 @wzhudev
• formula-input
  • Temporary style design (supports in-memory text highlighting: formulas, syntax coloring).
  • Formula-selection
  • Shotcut
  • Cross-sheet selection.
• formula engine
  • Integrate into the DI system.
  • Successfully compiled the let and reduce functions.
  • Integrated with view model
• sheets-plugin-formula UI @Dushusir
  • Formula real-time search list
  • Formula details pop-up windows data structure
  • Formula details pop-up window UI
  • toolbar formula menu button and dropdown
  • More Functions dialog
  • toolbar formula tab
  • error tootip @Dushusir basic component+cell notification service
  • integrated with worker.
  • Integrated with refservice.
  • The formula supports offset referencing in dropdown filling and copy scenarios. @Dushusir

• Row & col selections @DR-Univer
• Change selections with pointer @DR-Univer
• Change selections with keyboard @wzhudev
  • Simple movement with keyboard
  • Move to the next cell that has value
  • Shift-key moving
  • Ctrl-A
  • Tests

Range RangeList and other models should not rely on ICurrentUniverService.

• Range
• RangeList
• Workbook
• Worksheet

初始清单

• 这真的是个问题吗？
• 我已经在 Github Issues 中搜索过了，但没有找到类似的问题。

受影响的包和版本

dev分支

复现步骤

git clone https://github.com/dream-num/univer.git 
pnpm i
pnpm run dev:sheet

预期行为

可展示、可编辑

实际行为

表格可点击，可更改样式，但不可输入内容

运行环境

Chrome

操作系统

macOS

构建工具

esbuild

I have a problem with the setRangeMerge function. When I try to use it I get the following error:

api.js:3114
Uncaught TypeError: Cannot set properties of undefined (setting '9_3')
at Object.setRangeMerge (api.js:3094:41)
at UnisciCelle (prova_LuckySheet.html:45:20)
at HTMLInputElement.onclick (prova_LuckySheet.html:21:98)

This is my code:

<title>EasyGrooming</title>

    <input type='button' id='btnUnisci' value='Unisci celle' onclick='UnisciCelle()'>
    <input type='button' id='btnLeggiCella' value='Leggi cella' onclick='LeggiCella()'>
    <div id="luckysheet" style="margin:0px;padding:0px;position:absolute;width:600px;height:70%;"></div>
        
 
<script> 
    $(function () 
    {
        //Configuration item
        var options = {
            container: 'luckysheet' //luckysheet is the container id
        };
        luckysheet.create(options);
    });
    
    function UnisciCelle()
    {
        alert("Here I am!");
        luckysheet.cancelFrozen();
        luckysheet.setRangeMerge("all", "D10:E15");
    }
    function LeggiCella()
    {
        luckysheet.setRowHeight({5:50, 6:80});
        luckysheet.setCellValue(3, 4, "puppa");
        luckysheet.setCellFormat(4, 5, "bd", {borderType: "border-right",style: "1", color: "#ff0000"});
        luckysheet.setRangeShow("D10:E15");
        var sVal = luckysheet.getCellValue(0, 0);
        alert("Valore : " + sVal);
    }
    
</script>
  
</html>

Can somebody help me?
Many thanks

Facade expose API to SDK users and it also serves as an interpreter of AppScript.

移除 Worksheet Workbook Range RangeList 上的 mutate 方法，接入新的命令系统

• Refactor old Apply & Action to new Command & Mutation
• Remove API methods on the classes above
• Remove callers to these API. Invoke commands instead.

To the developers who will be responsible for implementing these features, please ensure that:

• All related commands, mutations, operations, menu items, and models are thoroughly unit tested.
• The undo-redo functionality is working correctly and without any issues.
• All design requirements have been met in the implementation.
• Your pull request (PR) is reviewed by another member of the team before merging.

Milestone 1 - Basic Sheet Features

To reach this milestone, we should diligently implement essential components and fundamental features, with the aim of providing a solid foundation to support future advancements and developments.

Deadline October 21th, 2023

• #117 lead by @jikkai, participants @Dushusir @TonyTonyChopper123
  • #154 @yuhongz
• #70 @jikkai
• worksheet
  • #147
  • Draggable tab @jikkai
• #148 @Dushusir @TonyTonyChopper123
• #149 @wzhudev
• #124 @wzhudev
• #150 @wzhudev
  • Support multi selections
  • Change selections with keyboard and cursor
• #151 @yuhongz

Milestone 2 - Features II

• #152 @DR-Univer @Jocs
  • copy paste
  • rich text editing
• Packaging format
• #153 @DR-Univer @Dushusir @TonyTonyChopper123
• Facade layer
• Data format
• Filling
• Sorting
• Data protection
• Menu grouping and toolbar collapsing
• Import & export

Milestone 3 - Advanced Features & Facade

我尝试使用npm安装发现失败了

Focus on transforming the core. After the structure is stable, plug-ins will be involved

Architecture related tasks

• core: Circular dependencies
  • The worksheet workbook should be split into model and api, the former only includes snapshot and get related, the latter is set modification @eiji-th
  • undo in CommandManager @eiji-th
  • Styles module changed to worksheet. When transferring, the modification of the worksheet does not depend on the workbook, and the two are decoupled @eiji-th
  • Action Apply @Dushusir
• ui-plugin-sheets: Circular dependencies @TonyTonyChopper123
• Using DI: sheets-plugin-numfmt @eiji-th
• Using DI: sheets-plugin-find @TonyTonyChopper123
• Move @wendellhu/redi into core package @wzhudev
• Add a dependency layer in core package @wzhudev
• Check for typos, like genname @eiji-th
• Remove unneeded modules like Server @Dushusir
• Interface Enum Types Const These directories are merged into the Types directory @Dushusir
• Don't put Univer in Basics @wzhudev
• Univer and Context are also a problem of holding each other, transform it into an injector on Univer @wzhudev
• [Optional] Remove index.ts, remove the introduction of ./index
• [Optional] Remove static methods and propertoes

• 中文输入
• 回车换行
• update更新输入
• 上下快捷键支持
• 排版文字太紧密
• 鼠标点击空白处体验
• 光标体验
• doc重构
• editor接入sheet
• ime input bugfix
• show scroll bar
• shortcut
• 网格调试
• indent不生效
• 排版问题优化：中英文间隔、
• 快捷键
• 复制粘贴
• 范围选择器开发及优化（抽象及开发优化选择器）
• 导入
• editor样式编辑重构
• editor最后一个段落不能被删除

I found that the framework core records all user commands in the _undoStack, including non editing operations such as selecting cells.

This results in if I modify the table content and frequently switch between selected cells, and then want to undo the modified content, I will need to click the undo button multiple times.

The last step to Univer Architecture Ready milestone is to clean up legacy code.

• [ ] fix unit tests (we will do it layer when we implement features)
  • setup unit tests environment @jikkai
• fix type problems & lint problems
• remove legacy system
• remove unused files

Selection

• Set selection operation
• Set selection shortcuts

Implements basic components and services to improve code reuse and provide consistent behavior across different plugins and platforms.

Deadline Oct 14, 2023

Components

• Message
• Button
• Icon: integrate @univerjs/icon
• Input @Dushusir
• InputNumber @Dushusir
• Container
• Layout
• Slider
• Tooltip

Docs

• Design Token / Palette
• Deploying storybook

Services

Services should be platform-agnostic.

• ThemeService (manages themes and dark mode)
• IMessageService

Deadline Oct 27, 2023

Components

• Dropdown
• CanvasIcon: rename CanvasIcon to BorderLine
• Menu
  • Item
  • NeoCustomLabel
  • CustomLabel: completely deprecate theCustomLabel component
  • Select
• ColorPicker
• ColorPickerCircleButton

Deadline Nov 4, 2023

Components

• Tabs
• Dialog: rename Modal to Dialog
• Notification @Dushusir
• Confirm

Services

• INotificationService @Dushusir
• IDialogService
• IConfirmService

Deadline Nov 11, 2023

Components

• CellRange
• Collapse
• Separator
• ResizeDialog
• SiderModal
• Avatar
• Checkbox
  • CheckboxGroup
• Radio
  • RadioGroup
• Drag
• Slot
• Modal

Not in plan

Components

• DatePicker move to #378

• Scrolling:
  • mouse scrolling
  • focus cell make scrolling
  • scrolling to specific position
• Zooming:
  • mouse wheel with shortcut key
  • slider bar in sheetbar
• Use operations to set scrolling positions and zooming scales
• Freezing
  • context menu