LibreOffice Calc是Microsoft Excel 的最佳替代品,虽然它的整体功能不在同一水平,但Calc仍然相当强大。现在,并不是每个人都知道Calc可以做什么,这就是为什么我们选择讨论一些使它与Excel不同的功能。
LibreOffice Calc 功能
有问题的功能在应用程序中已经存在了很长一段时间,但是如果您是新手,那么您很可能以前从未听说过它,这很好。我们将介绍的功能包括:
- OpenOffice BASIC语言用于宏编程
- 拖放(Drag)功能在Calc中得到更好的实现(Calc)
- 按删除键提供更多选项
- 将 PDF 作为文档插入
让我们更详细地讨论这一点,以便更深入地理解。
1] OpenOffice BASIC语言用于宏编程
如果您有兴趣使用LibreOffice Calc进行一些宏编程,请不要担心,这里也支持此功能。但是,该工具使用OpenOffice BASIC语言而不是 Microsoft 的Visual Basic for Applications ( VBA )。
现在,由于这两种语言都是BASIC家族的一部分,从(BASIC)VBA到OpenOffice Basic应该不会有很多问题,这对于任何想要进行转换的人来说都是一个好消息。
尽管如此,这两种语言之间还是有不少差异,但这里就不一一列举了。
阅读(Read):LibreOffice Writer 功能(LibreOffice Writer features)。
2]拖放(Drag)功能在Calc中得到更好的实现(Calc)
Microsoft Excel和LibreOffice Calc将允许用户将单元格从一个区域拖放到另一个区域。问题是这个任务在Calc中更容易,这与必须执行的有限点击操作有很大关系。
只需(Simply)拖放,就是这样。与Excel不同,当光标变成手时,您需要单击所选单元格的边框。
阅读(Read):最佳 LibreOffice 扩展(Best LibreOffice extensions)。
3]按删除键提供更多选项
在Microsoft Excel中删除单元格时,您可以按键盘上的Delete键来完成。按下该键时,一切都会消失,但LibreOffice Calc并非如此。您会看到,当单击删除键时,程序会为您提供选择要删除的内容的选项。
我们喜欢这个功能,因为它使用户很难意外删除单元格。
阅读(Read):LibreOffice 评论(LibreOffice review)。
4]将PDF作为文档插入
我们在Microsoft Office(Microsoft Office)中无法做的一件事是将PDF文档添加为图像。为了让事情变得更有趣,这个工具可以轻松导入Apple Numbers电子表格文档,这是一个简洁的操作。
此外,用户还可以并排比较两个文档,并将Calc文档导出为XHTML。此外(Furthermore),如果您想旋转整个图表,LibreOffice Calc也可以做到这一点。
更不用说,如果您有理由在另一个窗口中查看电子表格的副本,那么(Spreadsheet)Calc是执行此操作的最佳工具。
The best features in LibreOffice Calc
LibreOffice Calc is the best alternative to Microsoft Excel, and while it is not on the same level in terms of overall functionality, Calc is still quite powerful. Now, not everyone knows what Calc can do, which is why we’ve chosen to talk about some of the features that set it apart from Excel.
LibreOffice Calc features
The features in question have been around in the app for quite some time, but if you’re new to it, then chances are you’ve never heard of it before, and that’s fine. The features we will cover are:
- OpenOffice BASIC language is used for macro programming
- Drag and drop feature is better implemented in Calc
- Pressing the delete key gives more options
- Insert PDF as a document
Let us discuss this in more detail for deeper understanding.
1] OpenOffice BASIC language is used for macro programming
If you’re interested in doing some macro-programming with LibreOffice Calc, then worry not, this feature is supported here as well. However, the tool works with OpenOffice BASIC language instead of Microsoft’s Visual Basic for Applications (VBA).
Now, since both languages are a part of the BASIC family, one should not have a lot of problems going from VBA to OpenOffice Basic, and that’s awesome news for anyone who is looking to make the switch.
Still, there are quite a few differences between both languages, but they are too much to list here.
Read: LibreOffice Writer features.
2] Drag and drop feature is better implemented in Calc
Microsoft Excel and LibreOffice Calc will allow users to drag and drop cells from one area to the next. The thing is this task is easier in Calc and that has a lot to do with the limited click actions one had to perform.
Simply drag and drop, and that’s it. Unlike Excel where you are required to click the border of the chosen cells when the cursor transformed into a hand.
Read: Best LibreOffice extensions.
3] Pressing the delete key gives more options
When removing cells in Microsoft Excel, you can press the Delete key on the keyboard to get it done. When the key is pressed, everything will go away, but that isn’t the case with LibreOffice Calc. You see, when the delete key is clicked, the program gives you the option to select what you want to delete.
We like this feature because it makes it quite difficult for users to delete cells by accident.
Read: LibreOffice review.
4] Insert PDF as a document
One of the things we are not able to do in Microsoft Office is to add a PDF document as an image. To make things even more interesting, this tool can import Apple Numbers spreadsheet documents with ease, which is a neat touch.
Additionally, the ability is there for users to compare two documents side-by-side, and to export Calc documents as XHTML. Furthermore, if you want to rotate an entire chart, LibreOffice Calc makes that possible as well.
Not to mention, if you ever had a reason to view a clone of your Spreadsheet in another window, then Calc is the best tool for doing that.