Видео

Just some thoughts, nothing serious: 1. There's nothing there that is specific to LibreOffice Calc. You do it exactly the same way in all the spreadsheet applications that I know of, at least. 2. The separator between parameters in cell functions is not always a comma. It depends on your language settings. For instance, in my case, a comma is used as the decimal separator, so the separator between parameters is a semi-colon. About half of the world use a comma for a decimal symbol, so it's not a rare exception. 3. At 2:06 - 2:14, you could fill both rows in one go by first selecting B2:B3 and then fill to the right. Still a thumbs up, though.

cool

Check out courses at: www.itseasy.co.uk

Would like to see you select the named Range by typing the partial Name. Cannot figure out how to select the name of a Range without entering the whole thing.

When I try to bring monday across, it simply keeps on copying MONDAY 4 TIMES, in 4 cells. it doesn't fill in with the other ays of the week

Is it possible to create dynamic list ?

Really enjoyed this video! Much appreciated! 💚

Cool

Drop down lists

Super helpful! Thank you. :)

Thanks, but couldn't get past 2.30 cause my Alt key and the = (equals sign) key DON'T DO THE TRICK for the totals. How do I go around that?

This works nice, but it feels limited (maybe because I don't know how to do it). I want a whole table from calc synced. But if I add a row or remove a row, it doesn't update the amount of rows to sync. How can I do this? I tried it with OLE Objects but I don't get it synced... Edit: I have also a second question. I merged some cells, but they aren't merged in Writer anymore (I get this working with OLE, but not with DDE)

Thank you very much. I have been trying to do this for 2 days. It is not in the help menu.

This video is amazing! Thank you for sharing! 😊

love it

nice one

Check out courses at: www.itseasy.co.uk

but what if you could change the blue squares in your examples to a small picture (you can do this) BUT each point would show the face of the person... so in your example imagine the face of saxton smith jones green etc on your chart

285

thank you!

Cool

Very good thanks

Check out courses at: www.itseasy.co.uk

Thank you

it would be easier going into destination cell and type = then go to source cell and click on it, enter? So the destination cells is same as the source cell, including formatting. You could also add additional calculations to the destination once the result of the source is added. You may want to calculate a percentage, add/deduct an amount, just type it at the end in the right format.

6:05 - Whenever I use a background color or a background image, they only appear as of the presentation (F5), and never on the normal view of the slides. What can I do to change that? It's very hard to organize and design my slides if the BG color or BG images only show up on the show view.

this should be integrated to integrate with base

cool

Great thanks

Cool

Thanks for this

Cool way to filter data

Great video. I am going to enter my lps (6000), as well as my cds(3000). Does bease support autofilling so if i have several recordings of Queen, i could just type qu and it will fill in the rest.

Would be great if there's a formula such as =sparkline(...)

Fill series, check it out

How would this work if I have a column full IDs that need every account associated with it to be populated as a new row

is there any way to get similar feature with slicer? thank you sir

Going to make a grocery database to help me meal plan and budget. 😊

I think it's important that people leave comments, so that others will know that the video is a good one to watch. Now how many of you actually read this whole comment from start to finish. If you did leave a like, give credit where its due.

that's good, but how to align them

Love it

Nice to know

Check box in Calc

Using LibreOffice 7.6.0.3 doesn't have a Layout Tab as far as I can see. However, after much searching, the following gets to the additional Page Break Style drop down options. From the main menu bar select... Insert, then ... More Breaks, then Manual Break. The Page Style option drop down is now available.

Thanks. Praying this goes as well for me tomorrow.

thank you

Nice to know

Nice

Match Function