Search found 13 matches

by MKVRC
Mon Oct 16, 2023 9:44 am
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Please provide "Filter" and "XLOOKUP" functions. Thanks
Replies: 3
Views: 17311

Re: Please provide "Filter" and "XLOOKUP" functions. Thanks

Thank you for your response. Any idea by when these will be made available?
by MKVRC
Thu Oct 12, 2023 9:01 am
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Please provide "Filter" and "XLOOKUP" functions. Thanks
Replies: 3
Views: 17311

Please provide "Filter" and "XLOOKUP" functions. Thanks

Please provide "Filter" and "XLOOKUP" functions. Thanks
by MKVRC
Wed Oct 04, 2023 7:17 am
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Please provide dropdown list like in excel for items.
Replies: 1
Views: 5768

Please provide dropdown list like in excel for items.

Please provide dropdown list like in excel for items.

In plan maker there is auto complete option but no dropdown option, this would be a great help. Thanks

I mean in the attached excel when I type A it should show a dropdown list like in excel
1.png
1.png (16.08 KiB) Viewed 5768 times


Sample.xlsx
(7.7 KiB) Downloaded 454 times
by MKVRC
Wed Oct 04, 2023 6:39 am
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Values change even for unselected items
Replies: 2
Views: 6385

Re: Values change even for unselected items

Thank you for your quick response and update… Meanwhile I found 2 of the work arounds for the reported issue and steps as follows: Workaround - 1: 1) From same excel apply auto filter 2) From column B (Description) -> Select item ABC 3) Then under column C, select 1st and 2nd row and change desired ...
by MKVRC
Mon Oct 02, 2023 12:08 pm
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Values change even for unselected items
Replies: 2
Views: 6385

Values change even for unselected items

Values change even for unselected items In the attached excel sheet, under description column there are 4 items by name: ABC, BCD QAZ & XYZ Sample.xlsx Issue what I am facing is something like as follows: I have put an auto filter and then did select ABC from the Description (Column B) -> this l...
by MKVRC
Mon Oct 02, 2023 12:02 pm
Forum: PlanMaker NX and 2024 for Mac
Topic: Values change even for unselected items
Replies: 0
Views: 98250

Values change even for unselected items

Values change even for unselected items In the attached excel sheet, under description column there are 4 items by name: ABC, BCD QAZ & XYZ Sample.xlsx Issue what I am facing is something like as follows: I have put an auto filter and then did select ABC from the Description (Column B) -> this l...
by MKVRC
Thu Sep 21, 2023 12:44 pm
Forum: FreeOffice 2021 for Mac (General)
Topic: How to insert pdf files in document and spreadsheets?
Replies: 3
Views: 10214

Re: How to insert pdf files in document and spreadsheets?

Thank you for the update so any plans to add this feature in Mac version? kindly clarify. Thanks
by MKVRC
Thu Sep 21, 2023 12:42 pm
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: How to exclude one sheet and hide all sheets in one go?
Replies: 2
Views: 8910

Re: How to exclude one sheet and hide all sheets in one go?

Hi stascheit, yes you did understand my query correctly :) forgot to mention I am on Mac OS Monterey version 12.6.9. in Mac OS "Control + Left Click" is equivalant of right click in windows. instead of "Control + Left Click" I used shift + CMD key combinations. Thanks a million f...
by MKVRC
Tue Sep 12, 2023 6:27 pm
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: How to exclude one sheet and hide all sheets in one go?
Replies: 2
Views: 8910

How to exclude one sheet and hide all sheets in one go?

How to exclude one sheet and hide all sheets in one go? Attached excel file has several sheets, if i want to hide all the sheets in one go then I get a message as “At least one worksheet must be visible” but did not find an option or way to exclude one sheet or make visible while hiding remaining in...
by MKVRC
Tue Sep 12, 2023 5:58 pm
Forum: FreeOffice 2021 for Mac (General)
Topic: How to insert pdf files in document and spreadsheets?
Replies: 3
Views: 10214

How to insert pdf files in document and spreadsheets?

How to insert pdf files in document and spreadsheets?

i didn't find a way to achieve the above.....could you please explain?

for more details refer to the following links.


https://www.youtube.com/watch?v=Fks2Y9SN8Mg


https://excelchamps.com/advanced-excel/pdf-into-excel/
by MKVRC
Sun Aug 27, 2023 7:51 pm
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Pivot table resulting in an error in Softmaker Freeoffice
Replies: 3
Views: 7681

Re: Pivot table resulting in an error in Softmaker Freeoffice

Thank you for your response and update....hope this feature will be included soon.
by MKVRC
Thu Aug 24, 2023 9:59 am
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Pivot table resulting in an error in Softmaker Freeoffice
Replies: 3
Views: 7681

Re: Pivot table resulting in an error in Softmaker Freeoffice

please find the excel file attached
Sample.xlsx
(15.43 KiB) Downloaded 545 times
by MKVRC
Thu Aug 24, 2023 9:57 am
Forum: FreeOffice PlanMaker 2021 for Mac
Topic: Pivot table resulting in an error in Softmaker Freeoffice
Replies: 3
Views: 7681

Pivot table resulting in an error in Softmaker Freeoffice

Pivot table resulting in an error in Softmaker Free office In the attached excel file i have created a pivot table and result looks like as follows PT-1.png In MS excel if i click on result of sum of device count, for example on 20 or 16 it opens result in another tab/sheet like as follows PT-2.png ...

Go to advanced search