I agree with all you said, except libre office calc does not support creating tables which is a huge lack of a fundamental feature, that means no auto calculated columns, no auto resize, no auto fill, no filters and no everything else that tables in Excel provide.It also uses the same commands, macros and formulas
libre office calc IS a table. perhaps you are not using the correct terminology but a spreadsheet is a table.I agree with all you said, except libre office calc does not support creating tables which is a huge lack of a fundamental feature.
No you're confusing a spreadsheet for a table.libre office calc IS a table. perhaps you are not using the correct terminology but a spreadsheet is a table.
then please explain to me what the difference is between what you call a table and a spreadsheet. I have never seen the difference nor set up a table in a spreadsheet. So educate me on the difference please (not spoken sarcastically)No you're confusing a spreadsheet for a table.
Spreadsheet may contain one or more tables, but there are no tables in calc.
No problem I'll explain the best I can, but have you never used Excel?then please explain to me what the difference is between what you call a table and a spreadsheet. I have never seen the difference nor set up a table in a spreadsheet. So educate me on the difference please (not spoken sarcastically)
I have used excel but I am a M$ hater so stick to libre office. I have never seen a need for such a feature but I am not living off of spreadsheets so maybe I just never had the reason. What kind of purpose would this feature be used for? Not sure of the advantage to it. maybe an example would help. I did look to see about tables in calc and it does not have but had some work around that was pretty complicated.No problem I'll explain the best I can, but have you never used Excel?
A table is a rectangular set of cells, once created you can resize the table to the bottom or to the right, making it smaller or bigger (ex. to consume less or more cells)
Every table thus has it's own columns and rows that are independent or rows and columns in the spreadsheet where the table is created.
A formula entered into any of the cells in the table auto fills entire table column without you having to copy\paste it over rows.
Also as you expand the table so do the formulas auto fill along all columns.
Tables also have filters for each column to filter the table according to what ever criteria.
Tables also have it's own optional coloring and formatting independent of the spreadsheet the table is in.
You can reference a table from another table or it's individual columns or rows.
And as you expand, reduce or move the table all references in other tables or spreadsheets are auto updated.
Since this is lacking in calc this mean a lot of manual work that would be much easier if it did support tables.
Tables are so powerful it's a huge lack of calc for not having them.
You can think of tables as of tables in SQL database, can you think of SQL without tables? that would really suck.
It depends on how complex your calc or Excel book is, I've been working with really complex books in the past in Excel and tables were very useful to me.What kind of purpose would this feature be used for? Not sure of the advantage to it. maybe an example would help.
Online Spreadsheet Editor | Open Excel Sheets | ONLYOFFICE
Create, open, and edit powerful and secure spreadsheets online with your colleagues. Work in the cloud, on your desktop or mobile device (iOS / Android).www.onlyoffice.com
Insert tables - ONLYOFFICE
helpcenter.onlyoffice.com
I do believe we are off topic now. The OP wanted to know about install M$ 365 on a chromebook and we are not on target now.I believe that Only OFFICE will do excel spread sheets with tables. But haven't tried it my self.
Your right. Short story is don't think it can be installed directly on most chromebooks.I do believe we are off topic now. The OP wanted to know about install M$ 365 on a chromebook and we are not on target now.
Short story is don't think it can be installed directly on most chromebooks.
So the conclusion, if you ask me, is to ask MS to refund your purchase because they're unable to deliver their product to your computer.I have a Chromebook and I purchased Microsoft 365.
Hi,
I have a Chromebook and I purchased Microsoft 365. I have registered Microsoft 365 Key with my Microsoft Account.
With Regards
NndnG