LibreOffice Calc Shows Formulas as Text? Restore the Results
Learn why Calc shows formula text instead of calculated values and fix display mode, Text-formatted cells, apostrophes, or stale results.
As we all know, Windows 10 provides users with the latest antivirus protection with Windows Security. When you start Windows 10 for the first time, Windows Security is turned on and actively protects your device by scanning for malware , viruses, and other security threats.
Attention:
Windows Security uses real-time protection to scan downloads and programs you run on your device. Windows Update also automatically downloads updates to Windows Security to help keep your device safe and protected from potential threats.
Windows Security will provide antivirus protection updates by showing you when:
Windows Security has seven areas of device protection and lets you specify how you want to protect your device as follows:
You will see some security zones will display status icons:
For example: Windows Security interface:

How to Open Windows Security in Windows 10
1. Click the Windows Security icon on your taskbar.
2. You can now view and change settings on Windows Security.
1. Open the Start menu.
2. Click Windows Security in the All Apps list.
3. You can now view and change settings on Windows Security.
1. Open Settings and click the Update & Security icon .
2. Click Windows Security on the left side, then click the Open Windows Security button or click the Protection areas you want to open directly.
Note : Starting with Windows 10 build 17093, the settings page has been renamed from “Windows Defender” to “Windows Security” on the left side, and a link for protected zones has been added).
3. You can now view and change settings on Windows Security.
Now you can view and change the settings you like right on the home page.
Virus & threat protection provides a new view of your antivirus protection, whether it's Windows Defender Antivirus, which comes with Windows 10, or an AV from one of our ecosystem partners. If you've selected Windows Defender Antivirus, scan results and information about threats to your device are displayed here, or you can launch a third-party AV protection application directly in Virus & threat protection.
Account protection makes it easier for users to protect their identity when signing in to Windows with Account Protection in Windows Defender Security Center. Account protection will encourage password users to set up Windows Hello Face, fingerprint, or PIN for faster sign-in, and will notify Dynamic lock users in case Dynamic lock stops working because of the phone or device.
Firewall & network protection provides information about network connections and active firewall settings on Windows, as well as links to network troubleshooting information.
App and browser control, lets you adjust SmartScreen settings for apps and browsers to help you stay more informed and safe by warning you about potentially malicious websites, unrecognized downloads and apps on the Internet.
Device security helps you better understand the security features built into your Windows device. The Device security page also provides you with status reports and management of the security features built into your device, including toggles to provide enhanced protection.
Device performance & health gives you the latest information about Windows updates, drivers, battery life, and storage. You also get the Refresh Windows feature. This option will keep your personal files and some Windows settings, and will remove most apps to “refresh” the system, helping to improve the performance of your device.
(Starting with Windows 10 build 17704, Microsoft added a new assessment for the Windows time service. If Windows detects that your device is not properly synchronized with Microsoft's time servers and the time synchronization service is turned off, Microsoft will provide you with the option to turn it back on.)
Family options gives you an easy way to connect to available online family options. This page can link you to information about parental controls , options to set up screen time habits, set up reports on your child's online activity, and manage purchase controls for apps and games. You can also monitor the stability and safety of your device using this option.
Good luck!
See also:
Learn why Calc shows formula text instead of calculated values and fix display mode, Text-formatted cells, apostrophes, or stale results.
Build a reusable Writer mail merge with Calc recipient data and a shared embedded image, then preview and save the personalized letters.
Turn off LibreOffice’s optional update statistics and crash-report prompts, then check what the settings cover and how to verify them.
Clean spacing, find structured text, and rearrange names with Writer regex patterns you can preview before replacing.
Enable Writer’s bidirectional controls, set RTL paragraph flow, and check mixed Arabic or Hebrew text without disrupting English words and numbers.
Install metric-compatible Linux fonts or map LibreOffice fallbacks, while keeping Microsoft font licensing and layout differences in view.
Add usable text fields, check boxes, and drop-downs in Writer, then export a PDF recipients can complete and save.
Fix missing or substituted fonts in LibreOffice Writer PDFs, choose the right export profile, and verify which fonts are embedded before sharing.
Convert a folder of Word documents to PDF with LibreOffice commands, handle nested folders safely, and verify the output before sharing.
Set a custom LibreOffice Writer template as the default so new documents open with your preferred styles and page layout.














