Microsoft’s new Office app now available for Android and iOS

Few months ago Microsoft has announced to publicly test a new version of the Office app that combines Word, Excel and the PowerPoint app at the Ignite conference in Florida, details can be found here.

So as promised, Microsoft has released its new unified Office app for Android and iOS which combines Word, Excel, and PowerPoint into a single application.

Microsoft’s new Office app now available for Android and iOS. Image courtesy: iphonehacks

All of the main apps are combined in this one. Means you can switch between documents quickly, scan PDFs, text and even capture whiteboards and tables into digital versions. Microsoft has also added support for third-party cloud storage like Box, Dropbox, Google Drive and iCloud. This release is also be available on Android tablets with “limited support” and a fully optimized tablet experience will be available on both iPadOS and Android soon.

Microsoft’s new Office app now available for Android and iOS.

More features they are planning in foreseeable future releases:

  • Word Dictation—This will turn your voice into written text and use voice commands and simple toolbars to easily apply the right formatting and punctuation you need.
  • Excel Cards View—View and edit data in an Excel table row in a simple, digestible card format so you do not have span across columns that extend beyond the limits of the screen.
  • Outline to PowerPoint—Write your presentation content as a simple outline and let PowerPoint Designer turn it into presentable slides with the proper styling, formatting, and iconography of your content.

Feeling thrilled? Download the Office app now and have a look:

Download for Android | Download for iOS

Standalone version user’s don’t panic, Microsoft is still planning to keep the individual Word, Excel, and PowerPoint apps available but this combined app is clearly where most of the new mobile-focused features will appear in the foreseeable release.

Google-Dataset-Search-Engine

25 million free datasets was published by Google!

Note: Google’s new dataset search tool was publicly released on January 23rd, 2020.

Google-Dataset-Search-Engine

Google recently released a free tool for searching 25 million publicly available datasets! Yes free! Click here to search these datas datasetsearch, .

Dataset Search was primarily launched in September 2018.

People using Dataset Search thus far range from academic researchers, to students, to business analysts can use these data sets, which range from pretty small ones that tell you how many cats there were in the Netherlands from 2010 to 2018 to large annotated audio and image sets, to check their hypotheses or train and test their machine learning models. The tool currently indexes about 6 million tables.

The most commonly searched for datasets include “education,” “weather,” “cancer,” “crime,” “soccer,” and “dogs”.

Word, Excel and PowerPoint in one app!

Microsoft has officially announced to publicly test a new version of the Office app that combines World, Excel and the PowerPoint app at the Ignite conference in Florida. This app will be available for both Android and iOS.

Microsoft says that with the new Office app users will be able to create new presentations, documents and spreadsheets as well as edit/view existing documents. Further more, you’ll can also “snap a picture of a document” and make it into an editable Word file, create and sign PDFs or “transform tables from a printed page into an Excel spreadsheet!”

New Office app by Microsoft. Image courtesy: iphonehacks

Any can use the unified Office app without signing into a Microsoft account, though signing in will give access to their files to be saved on OneDrive.

Animated GIF - Find & Share on GIPHY
via GIPHY

To be noted, Microsoft also told CNet, that the brand new Office app won’t be replacing the existing 3 individual apps. “We know some users may only need to use any one of the apps and it is the user’s choice to install the app that best fits according to their needs.

If you are interested to try out the new unified Office app for iOS, sign up for the Testflight program here.

Google brings new privacy controls for mobile users

Google launched Incognito Mode for Maps,YouTube and Google Assistant

Returning to Google I / O in May, we saw that Maps and Search are the next two Android apps to add Incognito mode. Google now officially rolls it out so that you can keep your activity off your Google account and search for information. The functionality will be available from within the app’s profile menu.

google launched incognito mode for maps youtube and google assistant
google launched incognito mode for maps youtube and google assistant

Google Maps Incognito mode

Google Maps Incognito mode first introduced at its Google I / O developer conference earlier this year in May.

The incognito mode of Google Maps is based on the similarly named feature found in all modern browsers and present in Chrome since its release back in 2008.

This enables users of Google Maps to search and access locations without adding this information to their history with Google Account.

Google says Google Maps incognito mode will begin rolling out this month on Android, with iOS coming soon. The functionality is not currently available for the internet version of Google Maps.

YouTube history auto-delete

And since we’re on YouTube, there’s also a new feature for Google to include. Google previously introduced this feature in May when it was added to Google Search, Google Maps, and Google Account (which allowed users to remove past use of the app).

Convert currentTimeMillis to a datetime in JAVA(Spring Boot)

Spring Boot

In this tutorial I’ll show how to save Time Stamp in Database in currentTimeMillis and retrieve in Spring Boot

Want precise time for some purpose? Normally, we can save Time Stamp in Database but what if the data need to be converted into several formats?

Let’s say we need to save “2019-6-27 00:59:59” and then convert it to several formats like ’27/2019/6 00:59:59′ and ’20-JUN-1990 08:03:00′. Though “2019-6-27 00:59:59” can be converted but that’s a little bit tough. The ideal solution is to save the data in millisecond format. In millisecond format “2019-6-27 00:59:59” would be “1564167599000”

I assume you already have the datetime picker data in controller, here’s the conversion code:

String expireTime = model.attribute; //your model attribute or request parameter name
Date date = formatter.parse(expireTime);
Timestamp timestamp = new Timestamp(date.getTime());
String expireTime2 = String.valueOf(timestamp.getTime());
//That's it! We've converted '2019-6-27 00:59:59' to '1564167599000'
//Add your save logic

Now the reading part. User can’t read ‘1564167599000’, right? Let’s convert this to readable format:

String convertedExpireTime = "1564167599000";
//Create a calendar instance
Calendar calendar = Calendar.getInstance();
calendar.setTimeInMillis(Long.parseLong(convertedExpireTime));
int mYear = calendar.get(Calendar.YEAR);
int mMonth = calendar.get(Calendar.MONTH);
int mDay = calendar.get(Calendar.DAY_OF_MONTH);
int mHour = calendar.get(Calendar.HOUR_OF_DAY);
int mMin = calendar.get(Calendar.MINUTE);
int mSec = calendar.get(Calendar.SECOND);
String readableFormat = mYear + "-" + mMonth + "-" + mDay + " " + mHour + ":"+ mMin + ":"+ mSec; // The value is now converted to 2019-6-27 0:59:59
//Add some logic

That’s all! We’re done!

If you’ve any confusion please let me know 🙂

Github free users can avail unlimited private repositories now!

GitHub is by far the most popular way to share code. That said, one weakness of the platform is that it limits who can create private repositories – that is, software projects that aren’t visible to the broader public, and are shared only with a handful of pre-defined collaborators – to paying users.

Days are over now! Yay!

No you can create unlimited free private repositories.

How to query data out of the box using Spring data JPA by both Sort and Pageable

Spring Boot

Developing REST API? Clients wants both sort & pagination?

That’s quite simple btw!

Since last few hours was trying to add this simple feature my Spring Boot project. In my project pagination was done using pageable

In this tutorial I’m gonna show how to achieve this.

Let’s copy the code from below:

public List<Model> getAllData(Pageable pageable){
       List<Model> models= new ArrayList<>();
       modelRepository.findAllByOrderByIdDesc(pageable).forEach(models::add);
       return models;
   }
//Model = Your Model where you want to implement this feature. 

That’s all! We’re done!
If you’ve any confusion please let me know 🙂

Windows KMS Activator Ultimate 2018 4.2

Windows KMS Activator Ultimate is the most simple and user-friendly activator for Windows Server, Windows Vista, Windows 7, 8.1, 10. It is a safe activator, without harm to system files. The Windows activation period is 180 days, and you can renew it after its expiry. You can delete all previous activation. You can find out information about your activation and the current activation status of your Windows.

Instructions:
– Install the program
– Run as administrator
– Click “Clean Activation History”.
– Click Update Server to update the Update KMS Server.
– Select your OS type.
– Click “Activate Now”.
– Done, enjoy it!

Latest Windows KMS Activator Ultimate 2017 CAN the BE activated
the Windows 10, all versions
the Windows 8.1, all versions
the Windows 8.1, the Preview all versions
the Windows 8, all versions
the Windows 7 Professional
the Windows 7 Enterprise
the Windows Vista Business
the Windows Vista Enterprise
the Windows Server 12, all versions
the Windows Server 08, all versions

For Permanent Activation
Click on the “Activation Permanent Now” Activate:
Windows Vista Business / Enterprise
Windows 7 Professional / Enterprise
Windows 8 / 8.1 / 10 All
Office 2010/2013/2016 Preview
Windows Server 2008 / 2008R2 / 2012 / 2012R2 / 2016

System Requirements
Net Framework 2.0
Internet connection
What’s new in 4.2
– the add “the Digital License Activation” tool by s1ave77 for permanent activation
– the Can the activate the latest version of windows 10
– Fixed For All Bugs.

So, why are you waiting for? Download from here

 

Show data from two JPA entity tables on same page using Spring Boot and Thymeleaf

spring boot thymeleaf bootstrap 4

Let’s say you want to display multiple table contents in Spring Boot project using Thymeleaf, JPA Entity and Model.

In my project I have mapped a relationship between the two entities I need to retrieve data from and am wondering how to display data from the two tables on list page. I’ve ‘category’ table and ‘product’ table like below:

Spring Boot, Thymeleaf Show data from two JPA entity tables on same page using Spring Boot and Thymeleaf

And in my controller I’ve list of both category and product in respective model. Here is the snippet:

model.addAttribute("products", productService.findAll());
model.addAttribute("categories", categoryService.findAll());

So, I’ve all the required data in the model and I can access them from Thymeleaf. Let’s copy the table code from below (N.B: I’ve used bootstrap table):

<table class="table table-striped table-bordered table-responsive" role="grid">
   <thead>
      <th>Category</th>
      <th>Product</th>
   </thead>
   <tbody>
      <tr role="row" class="odd" th:each="product:${products}">
         <td>
            <p th:each="category : ${categories}" th:if="(${category.id} == ${product.id})" th:text="${category.name}"></p>
         </td>
         <td th:text="${product.name}">
      </tr>
   </tbody>
</table>

It’ll produce something like this:

Spring Boot, Thymeleaf: Display data from two JPA entity tables on same page

That’s all! We’re done!
If you’ve any confusion please let me know 🙂

Thymeleaf select required not working?

thymeleaf

Since last few days trying to add select “required” attribute in my Thymeleaf project.  Neither of these works in Thymeleaf:

  • <select required=”required”>
  • <select required=’required’>
  • <select required=required>
  • <select required=””>
  • <select required=”>
  • <select required>

In this tutorial I’m gonna show how to achieve this.

Let’s copy the code from below:

<select th:name="someName" class="form-control" id="someID" th:required="true">
    <option value="">Select Category</option>
    <option th:each="model: ${someModel}" th:value="${model.id}"
            th:text="${model.Title}"></option>
</select>

Please note that, first/default option value must be set to “” if you put “0” it won’t work!

That’s all! We’re done!
If you’ve any confusion please let me know 🙂