How to save formulas function in LibreOffice Calc? I am having trouble saving the formula function and all values becomes a solid value not function value.
Having some trouble with Calc, hoping maybe someone here can help. When putting the months or the weekdays, Calc will display them automatically in sequence as one would expect but only if the default language is Spanish {I use Spanish and English languages for Calc}. When I change the default language to English and try doing the same it will not display them sequentially, just repeat Monday or January. What is the fix for this? Regards.
@@dcpwebdesigners @12:19 that vertical line looks more like Extended ASCII Code 221 or 222. Don't think I could do that with borders in the middle of a cell. Is that right?
AHH sorry that is called "pipe character" www.google.com/search?q=pipe+character&oq=pipe+charwct&aqs=chrome.1.69i57j0l3.10728j0j4&client=ms-android-h3g-gb-revc&sourceid=chrome-mobile&ie=UTF-8
How would I make a formula for subtraction? I want to do some mileage data, and subtract beginning numbers from ending numbers. Would I use the '=IF and then the greater or lesser sign? Thanks in advance. Can you tell I am new at this? 🤷♀️
Hi what function do I use to determine the monthly payment on an amortization? I'd like to input the amount of the loan, the number of months and the interest rate. From that data I'd like to generate the monthly payment amount. Thanks much :) ..
Sorry to bother you but i have tried this for 3 months i have created a spreadsheet about my dvd's three columns 2 of text 1 of numbers times 58 entries .but when i look in print preview nothing there . and how to i add grid lines please . Im not very technical i hope you can help please .
Well don't know how to thank you brilliant but i must say i had to pause it a few times i'm not as quick as you. But sad to say nothing in the tutorial worked on my particular sheet must be corrupt so have started all over again . All the other documents the border worked on and was excellent many thanks and i will keep it in favourites for use again at my speed. Thanks Again very kind. .
@@dcpwebdesigners Thank you it works on most spread sheets but not on the one i have been trying . But thanks again will try another way delete the entry and re enter it . Cheers
![Libre Office Calc - Array Formulas and Functions - Part 1 - [ Libre Calc Office Advanced Tutorial ]](http://i.ytimg.com/vi/66dz_nomJoA/mqdefault.jpg)
Thanks for the video. We need intermediated and advanced LibreOffice tutorials.
Thanks 😎
Subscribe to access 150+ video tutorials: ruclips.net/user/dcpwebdesigners
Do you know how to save Solver models at each sheet after exporting to .xlsx?
Not sure I will have to research that
I may be a bit dim but is there a way of minus-ing using this? so you have one total and want to minus another one...
Yes
Formula
=A1-B1
This is an excel tutorial but works the same in libre office calc
ruclips.net/video/HfcH6-z-GCs/видео.html
@@dcpwebdesigners thank you mr. dcp! i'm having to teach this next week so am needing to know about it!!!
Great 👍
How to save formulas function in LibreOffice Calc? I am having trouble saving the formula function and all values becomes a solid value not function value.
Make sure you save the file as clac file or excel file, CSV does not retain formumas
Where can I find Formula ~ # days remaing in Guarantee? Thanks!
Having some trouble with Calc, hoping maybe someone here can help.
When putting the months or the weekdays, Calc will display them automatically in sequence as one would expect but only if the default language is Spanish {I use Spanish and English languages for Calc}. When I change the default language to English and try doing the same it will not display them sequentially, just repeat Monday or January.
What is the fix for this?
Regards.
After you feel the sequence there should be an option just below the last cell which allows you to select series filling
How did you generate that vertical line next to MEDIA COST? What is Vat?
Use cell boarders for line, Vat is value added tax in the UK
@@dcpwebdesigners @12:19 that vertical line looks more like Extended ASCII Code 221 or 222. Don't think I could do that with borders in the middle of a cell. Is that right?
AHH sorry that is called "pipe character" www.google.com/search?q=pipe+character&oq=pipe+charwct&aqs=chrome.1.69i57j0l3.10728j0j4&client=ms-android-h3g-gb-revc&sourceid=chrome-mobile&ie=UTF-8
@@dcpwebdesigners Thanks!
NICE EXPLANATION SIR IM FROM INDIA
Thanks 😎
can you make a video on how to insert a specific value from a website into a calc cell?
I will try, but not sure how, would need to store spreadsheet online and write alot of code to API the data
Better to use mySQL db
How would I make a formula for subtraction? I want to do some mileage data, and subtract beginning numbers from ending numbers. Would I use the '=IF and then the greater or lesser sign? Thanks in advance. Can you tell I am new at this? 🤷♀️
Go to this video ruclips.net/video/bgO40-CjYNY/видео.html
Check the description and click on chapter 7 - subtraction
@@dcpwebdesigners Many thanks!
Cool 😎
Hi what function do I use to determine the monthly payment on an amortization?
I'd like to input the amount of the loan, the number of months and the interest rate.
From that data I'd like to generate the monthly payment amount.
Thanks much :)
..
How would you [in IF... Comparison] B2 [NOT EQUAL TO] A2? Thanks!
Sorry to bother you but i have tried this for 3 months i have created a spreadsheet about my dvd's three columns 2 of text 1 of numbers times 58 entries .but when i look in print preview nothing there . and how to i add grid lines please . Im not very technical i hope you can help please .
Hi, 1. Watch this .. ruclips.net/video/CFHqFFz1rqM/видео.html
I am not sure why you do not see data in print preview, try clicking on the first cell in spreadsheet and then go to print preview
Well don't know how to thank you brilliant but i must say i had to pause it a few times i'm not as quick as you. But sad to say nothing in the tutorial worked on my particular sheet must be corrupt so have started all over again . All the other documents the border worked on and was excellent many thanks and i will keep it in favourites for use again at my speed. Thanks Again very kind. .
Try to copy the data into a new blank spreadsheet and then save to your desktop, that might fix the issue
Also download latest version of libre office ruclips.net/video/a-EmSL1Zmrw/видео.html
thank you, that was very clear to understand awesome
Thanks 😎 have fun learning new skills 👍
i needed this x
Cool 😎 thanks 👍 have fun 👍
Hello back again, I have been trying to inset a line on a spread sheet , and get the following . Filled cells cannot be shifted beyond the sheet ,
1. Save you file
2. Close file
3. Open file
4. Select row
5. Right click / insert row
@@dcpwebdesigners Thank you it works on most spread sheets but not on the one i have been trying . But thanks again will try another way delete the entry and re enter it . Cheers
Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm
spot on dude thank you
Thanks 😎
R u British bro.?
Yes from London UK
This libreoffice tutorial is useful for me, thankyou.
Cool 😎