Search found 5 matches

by MichelG
Thu Apr 11, 2024 10:11 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Convert numbers stored as text to numbers
Replies: 2
Views: 359

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 sc...
by MichelG
Mon Apr 08, 2024 1:50 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Convert numbers stored as text to numbers
Replies: 2
Views: 359

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 number...
by MichelG
Fri Jan 05, 2024 6:03 pm
Forum: PlanMaker 2021 for Mac
Topic: Linking data from Spreadsheets
Replies: 9
Views: 226744

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 own...
by MichelG
Thu Jan 04, 2024 8:05 pm
Forum: PlanMaker 2021 for Mac
Topic: Linking data from Spreadsheets
Replies: 9
Views: 226744

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: 226744

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 sep...

Go to advanced search