Search found 8 matches

by MichelG
Sun Jul 26, 2026 5:11 pm
Forum: BETA: PlanMaker NX and 2026 for Linux
Topic: copying/pasting a formula
Replies: 5
Views: 1201

Re: copying/pasting a formula

Thanks for the upcoming correction. I assume that the behavior for "Paste value and format" as well as the other paste icons has been verified/corrected as well ?

Cheers.
by MichelG
Sat Jul 25, 2026 5:28 pm
Forum: BETA: PlanMaker NX and 2026 for Linux
Topic: copying/pasting a formula
Replies: 5
Views: 1201

Re: copying/pasting a formula

Indeed it does paste properly when the shortcut "Paste" icon is selected. However, if you select the "Paste formula" it does not work; it only copies the formula to A3 and not to the full range selected (say A3 to A7), at least in the french version running on my LinuxMint computer.

Thanks for your ...
by MichelG
Thu Jul 23, 2026 2:30 pm
Forum: BETA: PlanMaker NX and 2026 for Linux
Topic: copying/pasting a formula
Replies: 5
Views: 1201

copying/pasting a formula

Hello,

Just wondering how to get the following to work:

Say I input the number 1 in cell A1 and then in Cell B1 I insert the formula : A1+1

And then I wish to copy the formula contained in B1 to a range of cells to the right (say from C1 to F1). If I use the copy function on B1 and then paste ...
by MichelG
Thu Apr 11, 2024 10:11 pm
Forum: PlanMaker 2024 for Windows
Topic: Convert numbers stored as text to numbers
Replies: 2
Views: 37807

Re: Convert numbers stored as text to numbers

I followed your procedure but with slight changes:

When loading the CSV file, in the left side of the dialog box I checked "decimal separator" and also "thousands separator". In the right side I used "Separator->Semicolon" and I also checked the "Extended number scanning" box as you recommended.

I ...
by MichelG
Mon Apr 08, 2024 1:50 pm
Forum: PlanMaker 2024 for Windows
Topic: Convert numbers stored as text to numbers
Replies: 2
Views: 37807

Convert numbers stored as text to numbers

Hello,

I'm using data tables extracted from the Statistics Canada website. The download format is in CSV.

I can import the files in Planmaker. The data tables contained in the files appear as a normal spreadsheet data (one number in each cell). The columns of numbers displayed look OK but the ...
by MichelG
Fri Jan 05, 2024 6:03 pm
Forum: PlanMaker 2021 for Mac
Topic: Linking data from Spreadsheets
Replies: 9
Views: 324736

Re: Linking data from Spreadsheets

What I meant is that one cannot press = then use the mouse and point/clic directly to a cell in a sheet from another file (to link both cells in a formula) as can be done in Exel and LibreOffice for instance. I couldn't get it to work.

But as you indicate, PlanMaker does allow you to link in its ...
by MichelG
Thu Jan 04, 2024 8:05 pm
Forum: PlanMaker 2021 for Mac
Topic: Linking data from Spreadsheets
Replies: 9
Views: 324736

Re: Linking data from Spreadsheets

Thank you for your answer and providing a solution.

Are there any intentions in enabling linking two cells from sheets in different files using the equal sign as can be done linking two cells from two sheets of a given file ?

-mg
by MichelG
Thu Jan 04, 2024 3:40 pm
Forum: PlanMaker 2021 for Mac
Topic: Linking data from Spreadsheets
Replies: 9
Views: 324736

Re: Linking data from Spreadsheets

Hello, I have a similar issue trying to link two spreadsheets contained in two different files (tes1.xlsw and test2.xlsw), using Planmaker running in win11.

If the two sheets are within the same file I can link cells from one to the other (say in a formula). However, if the two sheets are in two ...

Go to advanced search