Search found 75 matches

by XL-Dennis
Thu Feb 11, 2016 12:33 pm
Forum: PlanMaker 2016 for Windows
Topic: Invoicing systems
Replies: 12
Views: 8773

Re: Invoicing systems

Thanks Jossi for the clear present situation. I'm the first to regret it. Nowadays spreadsheet softwares and databases tend to walk in hands more and more. The need for easy solutions will force individuals to look for an option to SMO suite. Personally I would recommend LibreOffice, which is free a...
by XL-Dennis
Thu Feb 04, 2016 11:27 am
Forum: SoftMaker Office 2016 for Windows (General)
Topic: Creating customized add-ins?
Replies: 2
Views: 2993

Re: Creating customized add-ins?

Thanks, I'm not surpriced as I suspected that would be the case.

However, I hope it's has a priority as it will give the power users a tool to customize and optimize PlanMaker :-)

Keep up the good work!
by XL-Dennis
Wed Feb 03, 2016 7:46 pm
Forum: SoftMaker Office 2016 for Windows (General)
Topic: Creating customized add-ins?
Replies: 2
Views: 2993

Creating customized add-ins?

Hello,

Is it possible to create customized add-ins to PlanMaker?

If so, does it exist any guidelines?

TIA,
Dennis
by XL-Dennis
Wed Feb 03, 2016 7:30 pm
Forum: PlanMaker 2016 for Windows
Topic: Invoicing systems
Replies: 12
Views: 8773

Re: Invoicing systems

Hello, Not sure what You looking for but a simple =A1 will do most of the time. Sometimes we need to extract the last numbers like =RIGHT(A1;4) for lookup or so. A running invoice system is doable. If it was me I would use a small database (like SQLite or so) but that will require additional knowled...
by XL-Dennis
Wed Dec 30, 2015 5:37 pm
Forum: PlanMaker 2016 for Windows
Topic: click cell to run command
Replies: 1
Views: 1794

Re: click cell to run command

Hi,

Look for the BasicMaker 2016 help file in the main directory for SMO 2016.

I suggest that You start to explore the help file. When You face anything that You have issues with, simple post back and we will try to help You out :D
by XL-Dennis
Wed Dec 23, 2015 7:58 pm
Forum: PlanMaker 2016 for Windows
Topic: Workbook Properties - Options and Sheet Protection
Replies: 2
Views: 2965

Re: Workbook Properties - Options and Sheet Protection

In my opinion it's a bug because a tab should never be removed. Instead some options under the tab should be disabled when for instance sheet protection is on.

In this case we can discuss if "Show formulas" and "Show hiddens object" should be disabled or not.
by XL-Dennis
Wed Dec 23, 2015 7:42 pm
Forum: PlanMaker 2016 for Windows
Topic: simple formula
Replies: 1
Views: 1900

Re: simple formula

Hello,

If You have incomes in A-column and expensives in the B-column You can add the formula in cell C2: =SUM(A2;-B2)
To get a running balance You add the following formula in cell C3: =SUM(C2;A3;-B3) and copy it down as long as needed in the C-column.
Now You got a running balance.
by XL-Dennis
Tue Dec 15, 2015 2:26 pm
Forum: BasicMaker 2016 for Windows
Topic: basic maker tutorial and samples?
Replies: 7
Views: 27010

Re: basic maker tutorial and samples?

You have some macro workbooks in the folder ...\UserName\Documents\SoftMaker Office 2016\Macro Files

Make a search in PlanMaker's help file with the word "Basic". It will give You some basic necessary information.

Ask questions here :D
by XL-Dennis
Tue Dec 15, 2015 1:11 pm
Forum: SoftMaker Office 2016 for Windows (General)
Topic: New website still a joy
Replies: 1
Views: 2065

Re: New Softmaker website excellent; mobile version might be improved

+1

Excellent work which makes it joyable to visit =D> =D> =D> :D
by XL-Dennis
Tue Dec 15, 2015 1:09 pm
Forum: PlanMaker 2016 for Windows
Topic: Copying/Moving Multiple Worksheets
Replies: 3
Views: 2923

Re: Copying/Moving Multiple Worksheets

Alex,

It must be a bug...

Let me know if You want a customized solution to work around the bug until SM can provide an updated version.

It will be in Basic.
by XL-Dennis
Wed Dec 09, 2015 12:52 pm
Forum: PlanMaker 2016 for Windows
Topic: Transfer [Conditional] Formatting ?
Replies: 4
Views: 3794

Re: Transfer [Conditional] Formatting ?

It's possible in MS Excel to use the Format Painter to copy conditional formats.

It should be possible to do it in PlanMaker as well. Logically it should be doable.


Sven, this should be added to the list of updates.
by XL-Dennis
Wed Dec 09, 2015 11:19 am
Forum: PlanMaker 2016 for Windows
Topic: Function Cell syntax
Replies: 10
Views: 5814

Re: Function Cell syntax

Yes, it's true that (ff75ccf7) base 16 = (4285910263) base 10 However, PlanMaker seems to behave like Excel does so please see the following articles: HEX2DEC https://support.office.com/en-us/article/HEX2DEC-function-8c8c3155-9f37-45a5-a3ee-ee5379ef106e%20 DEC2HEX https://support.office.com/en-us/ar...
by XL-Dennis
Tue Dec 08, 2015 4:10 pm
Forum: PlanMaker 2016 for Windows
Topic: AutoFilter problem
Replies: 12
Views: 25540

Re: AutoFilter problem

Sorry for not understanding the issue better...

This is something that SoftMaker should resolve in a coming update of PlanMaker.

Sven, this shouldn't be an issue to add, right?
by XL-Dennis
Tue Dec 08, 2015 1:47 pm
Forum: PlanMaker 2016 for Windows
Topic: Transfer [Conditional] Formatting ?
Replies: 4
Views: 3794

Re: Transfer [Conditional] Formatting ?

I can confirm the behavior.

Sven et al: This should be possible, right?
by XL-Dennis
Tue Dec 08, 2015 1:31 pm
Forum: PlanMaker 2016 for Windows
Topic: AutoFilter problem
Replies: 12
Views: 25540

Re: AutoFilter problem

Paolo, Thanks for the info :-) In PlanMaker we need select the whole row with column names and then select Filter > AutoFilter. When doing so we get the same output as when just having one cell selected in LibreOffice/Excel. Sven et al: This should be a no-brainer to add to PlanMaker in a coming pat...

Go to advanced search